$connection_string = "dbname=joe user=joe host=localhost password='spork22'";
$id=$_GET["photoid"];
$size="orig"; // there are med and sm images, not using here
if ($dir == "" ) $dir=1;
for ( $i = 0; $i < $dir; $i++ ) {
$dir_dots .= ".";
}
$connection = pg_pconnect($connection_string);
if ( $qr=="" ) {
$myresult = pg_query ( "select * from images where id='$id'");
} else {
$myresult = pg_query ( "select * from images where id='$id' and quality='$qr'");
}
$id = pg_result($myresult, 0, 0);
$caption = pg_result($myresult, 0, 1);
$description = pg_result($myresult, 0, 2);
$country = rtrim(pg_result($myresult, 0, 3));
$spec_loc = rtrim(pg_result($myresult, 0, 4));
$date = pg_result($myresult, 0, 5);
$photographer = pg_result($myresult, 0, 6);
$quality = pg_result($myresult, 0, 8);
$fileext = pg_result($myresult, 0, 9);
$exposure = pg_result($myresult, $lt, 16);
$aperture = pg_result($myresult, $lt, 17);
$focal = pg_result($myresult, $lt, 18);
$flash = pg_result($myresult, $lt, 19);
$width;
$link;
$file_loc=escape_space ("https://xenotropic.net/images/{$country}/{$spec_loc}{$id}_$size.{$fileext}");
$file_loc=str_replace ( "'", "%5C'", $file_loc );
echo "
"; echo "$description
"; echo "
";
?>
"; echo "$description
"; echo "
← Previous Next → "; echo "
$country #$id | "; echo "|
Photographer | $photographer |
Date | $date |
Exposure | $exposure |
Aperture | $aperture |
Focal Length | $focal |