need a php function that does this

[leocrawf]

Hello you all. I am trying to find or code( never written a php function before, manage to get by without it) a function that does the following:

run a process by means of a loop based on how many records in a database. Now the process may run for more that 30 seconds due to the size of the database, how do i get the function to check the time and continue with the process after 30 seconds until the database reocrds are processed and dont have the page time out.

for example this simple script does what i want but it only works based on the server time of 30 seconds:

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

if(isset($_SESSION['randomUserId']))
{
$rsstalecartitems = "SELECT ter_orderlist_ord.id_ord
FROM ter_proddet_prd where ter_history_his.ip_his = '12345' ";


$rsstalecartitems_result = mysql_query($rsstalecartitems,$ksConnection) or die(mysql_error());

$num_rows = mysql_num_rows($rsstalecartitems_result);
//echo $num_rows;

if($num_rows != ""){
$i=0;
while ($row_rsstalecartitems=mysql_fetch_assoc($rsstalec artitems_result)){

$addedby = $row_rsstalecartitems['idusr_ord'];

$i++;

$deletecartinfo = "delete from ter_orderlist_ord where idusr_ord='$addedby'";
$deletecartinfo_result = mysql_query($deletecartinfo,$ksConnection) or die(mysql_error());

$deleteuserinfo = "delete from ter_user_usr where id_usr='$addedby'";
$deleteuserinfo_result = mysql_query($deleteuserinfo,$ksConnection) or die(mysql_error());


}

}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Any Help is appreciated.

[solomon]

It maybe easier to modify the timeout of the script by using set_time_limit(300);

This will set the time out to 5mins i.e 300 seconds.

details here - www.php.net/set_time_limit

If you still want to extend the time by 30 seconds you do some thing in the loop like


$startTime = time();

$i=0;
while ($row_rsstalecartitems=mysql_fetch_assoc($rsstalec artitems_result)){

$diff = time() - $startTime ;

if ($diff >= 15) ;// You should use a number that is less than the maximum execution time
{

set_time_limit(30); //extend the time

$startTime = time(); //reset start time
}


.
.
.
rest of code follows

[Utech22]

Did you get the solution to work?

[icymint3]

1. keep track of the id of the last record processed in your while loop (in the session or something).
2. keep track of the time elapsed in the while loop
3. whenever the page is close to timeout, end the loop so the request completes
4. allow the user to see how many of the records were processed and continue from the last one (or use a redirect so it is automatic )

[leocrawf]

I will give the solution a try. Hope it works
.