Golden Gate bridge and surf with light reflections, seen from E Baker Beach, dusk. San Francisco, California, USA
$view_c = (isset($_COOKIE['view']) ? $_COOKIE['view'] : null);
$pos = strpos($view_c,'gallery'); if ($pos === false) {
$rating = (isset($_GET['rating']) ? $_GET['rating'] : null);
$ref_prev = (isset($_GET['ref_prev']) ? $_GET['ref_prev'] : null);
if ($rating == "") {
echo "
" ;
} else {
$mysql= mysql_connect('localhost','qtl1','tgdbtgdb;;') or die('could not connect to mysql');
mysql_select_db('photo', $mysql) or die ('Could not select database');
$result=mysql_query("select ratings_nb,ratings_av from image_stats where ref = 'usca9282'",$mysql)
or die ("query failed = " . mysql_errno() . ": " . mysql_error());
if (mysql_num_rows($result) > 0) {
$array = mysql_fetch_row($result);
$nb = $array[0];
$av = $array[1];
}
if ($nb == 1) {
echo "You were the first to rate this image. Thank you !";
} else {
printf( "Thank you ! This image has been rated $nb times with an average of %.1f/10",$av);
}
mysql_close($mysql);
}
if ($ref_prev != "") {
$mysql= mysql_connect('localhost','qtl1','tgdbtgdb;;') or die('could not connect to mysql');
mysql_select_db('photo', $mysql) or die ('Could not select database');
$result=mysql_query("select ratings_nb,ratings_av from image_stats where ref = '$ref_prev'",$mysql)
or die ("query failed = " . mysql_errno() . ": " . mysql_error());
if (mysql_num_rows($result) > 0) {
$array = mysql_fetch_row($result);
$nb = $array[0];
$av = $array[1];
}
if ($nb == 1) {
echo "
You were the first to rate the previous image $ref_prev. Thank you !";
} else {
printf( "
Thank you. Previous image $ref_prev has been rated $nb times with an average of %.1f/10",$av);
}
mysql_close($mysql);
echo " ";
}
}
?>
require('/home/tega/httpdocs/scripts/retrieve_keywords_new.php'); { $mysql= mysql_connect('localhost','qtl1','tgdbtgdb;;') or die('could not connect to mysql');
mysql_select_db('photo', $mysql) or die ('Could not select database'); $keyword_string = retrieve_keywords_image("usca9282","Themes" ); print "$keyword_string"; } ?>
$mysql= mysql_connect('localhost','qtl1','tgdbtgdb;;') or die('could not connect to mysql');
mysql_select_db('photo', $mysql) or die ('Could not select database');
mysql_query("update image_stats set views = views + 1 where ref = 'usca9282'",$mysql)
or die ("query failed = " . mysql_errno() . ": " . mysql_error());
mysql_close($mysql);
?>