Can anyone see why this is happening…PLEASE

@oo7mlMar 12.2007

I have been trying to solve this for the last week so please please let me know what is causing this… 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…. ~~[COLOR=”RoyalBlue”]~~THANKS IN ADVANCE[/COLOR]

Here is my code below:

[code=php]<?php session_start(); //rate.php

$dbh = mysql_connect(“localhost”, “root”, “”) or die(mysql_error()); mysql_select_db(“sample”) or die(mysql_error()); ?>[/code]

<!DOCTYPE HTML PUBLIC ‘-//W3C//DTD HTML 3.2 Final//EN’>
<html>
<head>
<title>Rate People</title>
<meta http-equiv=’Content-Type’ content=’text/html; charset=utf-8′>
<link rel=stylesheet href=stylesheet.css type=text/css>

</head>

<body>

<tr> <td width=”145″><a href=”index.php” target=”_self”><img src=”Images/lt.gif” width=”145″ height=”58″ border=”0″></a></td>

<td width=”145″><a href=”index.php” target=”_self”><img src=”Images/rt.gif” width=”145″ height=”58″ border=”0″></a></td>

</tr> <tr> <td height=”58″><a href=”index.php” target=”_self”><img src=”Images/lb.gif” width=”145″ height=”58″ border=”0″></a></td>

</table>

<!–<table width=760 border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=”12″> </td>
</tr>
</table>–>

[code=php]<?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’];

?> [/code]

</td> <!– rate bar –>

</tr>
<tr>
<td align=”center”>

[code=php] <?php echo “<img src=’/site/uploaded_files/”.basename($list[‘file’]).”‘ alt=”>”; // call image

}

if (array_key_exists(‘id_value’,$_POST)) {

$id_to_rate = ereg_replace(“[^A-Za-z0-9]”, “”, $_POST[‘id_value’]); print $id_to_rate;

$new_rating = $_REQUEST[‘rating’];

$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].””>”; } ?>[/code]

</td>
</tr>
</table>

</td>

</tr> <tr> <td colspan=”2″ vAlign=top bgcolor=”#FFFFFF”><br> <br></td>

</tr>

</table>

<br>

<tr align=center>
<td height=29><a href=”info.php” class=”linksFooter”>About Us</a><img src=”Images/footer_seperator.gif” width=”15″ height=”25″><a href=”contact.php” class=”linksFooter”>Contact
Us</a><img src=”Images/footer_seperator.gif” width=”15″ height=”25″><a href=”terms.php” class=”linksFooter”>Terms
and Conditions</a><img src=”Images/footer_seperator.gif” width=”15″ height=”25″><a href=”privacy.php” class=”linksFooter”>Privacy</a></td>
</tr>

</div>

</body>

</html>

to post a comment

PHP

6 Comments(s) _↴

@NightShift58Mar 12.2007 — #I see nothing in your code that's would be causing the 0.1 sec flashback.

It's "probably" a browser issue. Does this happen with all browsers?

One thing you could try to use would be [b]ob_start()[/b] and [b]ob_end_flush()[/b], though I'm not sure it would help much as loading the image is not included in the output buffering.

You can also look around for so-called javascript "image preloaders", to make sure the image is "in" the browser as it begins displaying the page.

@oo7mlauthorMar 13.2007 — #it happens in both browsers, no one can seem to find out what is causing it....eeerrh...

@aj_nscMar 13.2007 — #EDIT: I had the wrong idea in this post, please see my next one

Ok, lets think about this, whats happening the first time is that everything runs smoothly, then something must get changed which makes it different the second time it runs. And then what's happening is the last block of php code you have there, is getting executed in its entirety when you dont want that. You want to either echo the image, OR refresh the page (am I right?, if not, please clarify).

So that means that when you go to the page first, there is no $_POST['id_value'] because you just went to the url, nothing got posted, then when you rate a photo, this value gets set and the page refreshes and shows another photo normally.

I can't put my finger on it, (because I don't want to spend all day on this thread or anything) but I think it has something to do with the refresh with $HTTP_SERVER_VARS[php_self]

If I were you, I would start echoing out every variable that is used to do something at the beginning of your document so you can see what they are all set to and see how they change through the course of executing the script. I think we can figure this out

@aj_nscMar 13.2007 — #Wait a second, I think I understood the question wrong, the page generates the photo twice over EVERY TIME THIS SCRIPT IS EXECUTED?? I thought you meant it only generated the photo twice over the second time it was executed. I can understand completely why it does this, you're using some bad logic here in my opinion, you're using a refresh to make a query if somebody has just voted for a picture AFTER the page loads meaning that a new picture will load, then the refresh will take place, and then another new picture will load.

So, I think you need to rearrange this script.

I think it would be best to evaluate if $_POST['id_value'] exists in the header of the document (get all the queries from the previous photo being rated out of the way first, then deal with the matter at hand). And there's no need for having a refresh at all. After you've done everything concerning the last record, you just start anew and grab another one.

Let me know what you think.

@oo7mlauthorMar 13.2007 — #Thanks a million for taking time out to look at this, i will try your theory as soon as i get back, thanks again, i really appreciate it

@aj_nscMar 13.2007 — #I'm interested to know how it works out, let me know.

Also in #PHP _↴

Mashing JS & php [RESOLVED] Is this a type of "IF" "ELSE" statement?redirect to html thankyou on submit

Success!

Help @oo7ml spread the word by sharing this article on Twitter...

Tweet This

Can anyone see why this is happening…PLEASE

6 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Can anyone see why this is happening…PLEASE

6 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

6 Comments(s) _↴

Also in #PHP _↴