Thank you, but it doesn'T explain why i can run the other script for 5 minutes without any set_time_limit
i'd like to get a precise explanation on why it's doing it, for the time being i will use set_time_limit for this script. Mathieu Dumoulin "Joel Colombo" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROTECTED] > stick a..... > > set_time_limit(XXX); > > at the top of the page.... > where XXX is the maximum time u would like it to run. ex... 180 for say 3 > minutes. > > Joel Colombo > > > "Mathieu Dumoulin" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Ok, i got this script i run on my server, this script runs exactly 47 secs > > or so (45 to 49) each time i run it. I run it from the command line cause > > it's going to be a CRON job i'll run every month. > > > > My question is, why after 47 seconds or so does my script end saying: > > > > <b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in > > <b>/var/www/autoexpert/includes/db.php</b> on line <b>69</b><br> > > > > This sucks, i did another script that imports data, it takes something > like > > 5 minutes to execute, and it's pretty much the same code, why does this > one > > end like that with a fatal error while the other goes trough its very long > > task of import a whole set of data in 5 minutes. > > > > I'd like to know exactly how PHP calculates that my script ran too much > > time. Here is the code in case you need to see it. Please do not fix my > code > > for me, if there are bugs i will find them, i just want to know how PHP > says > > it's been 30 seconds. > > > > Mathieu Dumoulin > > Web Solutions Programmer Analyst > > > > Code: > > > > #! /usr/bin/php > > <?php > > /*This file is used each month on the 1st day to compile the whole > > previous month data for the cars and for the person to which this > > post pertains to.*/ > > > > //Definition > > define('IN_INDEX', 1); > > > > //Connect to the database > > include("../includes/config.php"); > > include("../includes/db.php"); > > > > //Open the connection > > $db->connect(); > > > > //Get the current date > > //$curDate = date("Y-m-d"); > > $curDate = "2003-03-01"; > > > > //Get the previous month's complete date > > $cur_expl = explode("-", $curDate); > > $cur_month = $cur_expl[1]; > > if($cur_month == 1){ > > $prev_month = 12; > > $prev_year = $cur_expl[0] - 1; > > }else{ > > $prev_month = $cur_month - 1; > > $prev_year = $cur_expl[0]; > > } > > $prev_day = "01"; > > $prevDate = (string)$prev_year . "-" . @str_repeat("0", 2 - > > strlen($prev_month)) . $prev_month . "-" . $prev_day; > > $prevDateYearOnly = (string)$prev_year . "-" . "01" . "-" . $prev_day; > > > > //Echo > > echo "Running... please wait\n"; > > > > //Get all this month's stats > > $db->query("SELECT * FROM stats_vehicules_days WHERE day >= '$prevDate' > AND > > day < '$curDate' ORDER BY vehiculeid", "stats_vehicules_days"); > > > > //Loop and add all lines as needed > > while($row = $db->fetch_array("stats_vehicules_days")){ > > //Update the line in the stats_vehicules_month > > $db->query("UPDATE stats_vehicules_months SET clicks = clicks + " . > > $row[clicks] . ", views = views + " . $row[views] . " WHERE vehiculeid = " > . > > $row[vehiculeid] . " AND month = '$prevDate'", "updateStats"); > > //Get the Info ID for this vehicule > > $db->query("SELECT i.id AS info_id FROM info AS i, annonces AS a, > vehicules > > AS v WHERE i.id = a.infoid AND a.id = v.annonceid AND v.id = " . > > (string)$row[vehiculeid], "infoId"); > > $infoid_row = $db->fetch_array("infoId"); > > //Write the stats for this user > > $db->query("UPDATE stats_info_months SET clicks = clicks + " . > $row[clicks] > > . ", views = views + " . $row[views] . " WHERE infoid = " . > > $infoid_row[info_id] . " AND month = '$prevDate'", "updateStats"); > > $db->query("UPDATE stats_info_years SET clicks = clicks + " . > $row[clicks] > > . ", views = views + " . $row[views] . " WHERE infoid = " . > > $infoid_row[info_id] . " AND year = '$prevDateYearOnly'", "updateStats"); > > } > > > > //Close the connection > > $db->close(); > > ?> > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
