oo7ml
03-08-2007, 07:37 AM
My page randomly generates a photo from my database. When a user rates the photo, the page randomly generates a new photo from the database, however, as soon as the user rates the photo, the page seems to generate a photo twice over.... It loads a new image for .01 of a second, then a new images replaces it again and stays there until the user rates it.... and the same thing happens again each time a user rates a photo....
Here's my code below:
<?php
if (isset($_SESSION['previousid']))
{//print "first";
$id = $_SESSION['previousid'];
$sqllastrating = "SELECT average_score, votes FROM accounts where id= $id"; // select 1 random record from accounts
$previousresult = mysql_query($sqllastrating);
$previouslist = mysql_fetch_array($previousresult);
$votedaverage = $previouslist['average_score'];
$votedvotes = $previouslist['votes'];
session_destroy();
}
$sql = "SELECT * FROM accounts ORDER BY RAND() LIMIT 1"; // select 1 random record from accounts
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
if ($nrows != 0) {
$list = mysql_fetch_array($result);
$id_to_rate = $list['id'];
$current_score = $list['average_score'];
$current_votes = $list['votes'];
//print "ID=".$id_to_rate." <b>Current rating:</b> ". $current_score . " out of " . $current_votes . " voter(s)";
?>
<?php
echo "<img src='/site/uploaded_files/".basename($list['file'])."' alt=''>"; // call image
}
if (array_key_exists('id_value',$_POST))
{
//Get value from radio button
$id_to_rate = ereg_replace("[^A-Za-z0-9]", "", $_POST['id_value']);
print $id_to_rate;
$new_rating = $_REQUEST['rating'];
//Get values of results according to ID
$query = "SELECT total, average_score, votes FROM accounts where id ='$id_to_rate'"; // select 1 random record from accounts
$results = mysql_query($query);
$scoreslist = mysql_fetch_array($results);
//Retrieve current values from database
$total = $scoreslist['total'];
$average_score = $scoreslist['average_score'];
$votes = $scoreslist['votes'];
//Calculate new values
$new_votes = $votes + 1;
$new_total = $total + $new_rating;
$new_average= $new_total / $new_votes;
$new_average= number_format($new_average, 2);
session_start();
$_SESSION['previousid'] = $id_to_rate;
//print "Average: ". $new_average;
//print "Votes: ". $votes . " Total: ". $total ." Average: ". $average_score ."<br>";
//print "Votes: ". $new_votes . " Total: ". $new_total ." Average: ". $new_average;
$updatequery = "Update accounts set total = $new_total, average_score = $new_average, votes = $new_votes where id = $id_to_rate";
if (!mysql_query($updatequery, $dbh))
{
die('Error: '.mysql_error());
}
echo "Storing...";
mysql_close($dbh);
echo "<meta http-equiv=\"Refresh\" content=\"0;url=".$HTTP_SERVER_VARS[php_SELF]."\">";
}
?>
Here's my code below:
<?php
if (isset($_SESSION['previousid']))
{//print "first";
$id = $_SESSION['previousid'];
$sqllastrating = "SELECT average_score, votes FROM accounts where id= $id"; // select 1 random record from accounts
$previousresult = mysql_query($sqllastrating);
$previouslist = mysql_fetch_array($previousresult);
$votedaverage = $previouslist['average_score'];
$votedvotes = $previouslist['votes'];
session_destroy();
}
$sql = "SELECT * FROM accounts ORDER BY RAND() LIMIT 1"; // select 1 random record from accounts
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
if ($nrows != 0) {
$list = mysql_fetch_array($result);
$id_to_rate = $list['id'];
$current_score = $list['average_score'];
$current_votes = $list['votes'];
//print "ID=".$id_to_rate." <b>Current rating:</b> ". $current_score . " out of " . $current_votes . " voter(s)";
?>
<?php
echo "<img src='/site/uploaded_files/".basename($list['file'])."' alt=''>"; // call image
}
if (array_key_exists('id_value',$_POST))
{
//Get value from radio button
$id_to_rate = ereg_replace("[^A-Za-z0-9]", "", $_POST['id_value']);
print $id_to_rate;
$new_rating = $_REQUEST['rating'];
//Get values of results according to ID
$query = "SELECT total, average_score, votes FROM accounts where id ='$id_to_rate'"; // select 1 random record from accounts
$results = mysql_query($query);
$scoreslist = mysql_fetch_array($results);
//Retrieve current values from database
$total = $scoreslist['total'];
$average_score = $scoreslist['average_score'];
$votes = $scoreslist['votes'];
//Calculate new values
$new_votes = $votes + 1;
$new_total = $total + $new_rating;
$new_average= $new_total / $new_votes;
$new_average= number_format($new_average, 2);
session_start();
$_SESSION['previousid'] = $id_to_rate;
//print "Average: ". $new_average;
//print "Votes: ". $votes . " Total: ". $total ." Average: ". $average_score ."<br>";
//print "Votes: ". $new_votes . " Total: ". $new_total ." Average: ". $new_average;
$updatequery = "Update accounts set total = $new_total, average_score = $new_average, votes = $new_votes where id = $id_to_rate";
if (!mysql_query($updatequery, $dbh))
{
die('Error: '.mysql_error());
}
echo "Storing...";
mysql_close($dbh);
echo "<meta http-equiv=\"Refresh\" content=\"0;url=".$HTTP_SERVER_VARS[php_SELF]."\">";
}
?>