The loop just won't stop

[Erlesand]

Hey there,

The following code should keeping getting the info from the databases (which is does) and then the code should stop to execute once the page has been stopped or shut down (left), which it does not. I looked around at PHP.net at found that I could use connection_aborted() which I tried, but it still keeps executing the code. Any ideas on how I would solve this?

Thanks on beforehalf

<?PHP
  require("./include/config.php");

  $sqldb = mysql_connect ($dbhost,$dbuser,$dbpass) or die ('I cannot connect to the database because: ' . mysql_error());
  $db = mysql_select_db ($db); 

  $nick = $_GET['nick']; 

  print str_repeat(" ", 300) . "\n";
  echo "<H1>$nick</H1>";
  $chat_date = date("j M H:i:s");     

  $query = "INSERT INTO `Chat` ( `Id` , `Time` , `User` , `Text` ) VALUES ('', '$chat_date', '$nick', 'has entered the chat')";
  $query = mysql_query($query);

  $query = "SELECT * FROM `Chat` WHERE Time='$chat_date' AND User='$nick'"; 
  $query = mysql_query($query); 
  $query = mysql_fetch_array($query);
  $chat_id = $query[0]; 

  Set_Time_Limit(0);  

  Ignore_User_Abort(True);

  While(!Connection_Aborted()) {
    Echo "\n";
    Flush();

while (1) {

  $ctime = date("U"); 
  $chat_date = date("j M H:i:s"); 

  $query = "UPDATE `Chat_Online` SET `Ctime` = '$ctime', `Time` = '$chat_date' WHERE `Nick` = '$nick' LIMIT 1";
  $query = mysql_query($query);

  $query = "SELECT * FROM `Chat` WHERE `Id` >= $chat_id";
  $query = mysql_query($query); 

  while ($line = mysql_fetch_array($query)) {
    $chat_id = $chat_id+1;
    echo "[$line[1]] $line[2] $line[3]<BR>";
  }

  sleep(3);
  flush(); 
}
sleep(1); 
  }

?>

[sijis]

well from what i can tell it seem that you might be talking about this while loop.

while (1) {

right? well, the problem with that is your don't have a condition of when that loop will stop. you are basically saying...
while(ALWAYS TRUE) continue..... this will NEVER stop.

on top of this you have 3 nested while loops. I'm not sure if that is really necessary. i think you just need 2.

this is what i would do.
remove the outer while loop. the one that goes:
While(!Connection_Aborted()) {

then change this:
while (1) {

to something like this: (just an example)

$end = mysql_num_rows($query);
$count = 1;
while($count < $end){
... you code
$count++;
}

hope that help or gives you an idea.

[Erlesand]

Thanks for your help, finally got the thing working. I did the opposite of what you said and tada 😃 The loop should end first when the page is left, so I simply removed the while (1) loop and added some other function and it worked like a charm 🙂 Thanks again