Very Strange PHP Behaviour

cesarovich

Hi everybody,
I am experiencing a very strange UNDOCUMENTED phenomenon in a PHP script in RedHat 7.2 and IIS.

I make a very time consuming process, which consists of filling 1,000,000 rows in a MySql database. Instead of populating the database till the end of the task, it somehow re-starts, PROCESSES again the script (!!!!), and instantly RE-PROCESS IT again.

The result, it inserts around 200,000 lines, delete them, and insers around 700,000 and finally stops!!!!...
I call the script via HTTP through a web browser (IE 6) with

http://www.mydomain.com/my_script.php

I would appreciate any coment. Thanks in advance.

global $REMOTE_ADDR;

// your data here
$host="";
$user="";
$password = "";
$db="";
// end of data

$server= mysql_connect($host,$user,$password);
mysql_select_db($db,$server);

$sql = "SELECT COUNT(*) as numero FROM cdint.ip_accesos";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_object($res);

if ($row->numero > 10000){
$sql = "DELETE FROM cdint.ip_accesos";
$res = mysql_query($sql) or die(mysql_error());

}else{
for($i=0;$i<1000000;++$i){
//echo $i . "<br>";
$sql = "INSERT INTO cdint.ip_accesos (ip,fecha) VALUES ('$REMOTE_ADDR', NOW())";
$res = mysql_query($sql) or die(mysql_error());

} // for

} // if

?>

trooper

Just a little question for you

Are you 100% sure that the queries are actually running

I ALWAYS put or die(mysql_error()) after my db connection and select_db commands to ensure that i am aware of any problems at the begining of the script

Start with adding that to your code. I noticed that you have it in other areas of the script. Consistency is always good 😃

HTH

hermand

Should be $i++ not ++$i surely?

cakkafracle

++$i would increment $i AFTER the loop.... meaning

$i would equal 0 twice

am I wrong?

cesarovich

When you limit the superior edge of the for statement to 100000, the script runs perfectly (so queries are perfectly working, and no, it goes through 0 only once!!!)... Even when you execute the script in the console mode, it runs much faster and perfectly.
The problem seems to lie in some kind of "re-start" mechanism which may be in the side of the web browser or proxie.

Any idea would be very appreciated. You can check with your own scripts, no matter what they do, if the time running is very long (more than 5 minutes), the script re-switches itself!!!!...