间歇性地获得“最长执行时间”错误

Question

I am facing this problem, firstly I would like to say that I am very new to PHP and MySQL.

Fatal error: Maximum execution time of 30 seconds exceeded in 
.........................\cdn\wished.php on line 3

I don't know what is wrong in line 3, its giving error only sometimes. Here's my code:

<?php
//wished.php
$CheckQuery = mysql_query("SELECT * FROM users WHERE ownerid='$user->id'");
$wished = 0;
while($row = mysql_fetch_assoc($CheckQuery))
{
//  echo $row['fname']."<br/>";
    $wished++;
}
echo $wished;
?>

It was perfect when I run this in localhost with XAMPP. As soon as I hosted my app on my domain and used their database, it start getting error.

thanks every one :)

Answer 1

The issue is that the SQL query is taking too long, and your production PHP configuration has the PHP script time limit set too low.

At the beginning of the script you can add more time to the PHP time limit:

http://php.net/manual/en/function.set-time-limit.php

set_time_limit(60);

for example to add 30 more seconds (or use 0 to let the PHP script continue running).

If your production database is different than your development DB (and I'm assuming production has way more data) then it might be a really expensive call to get everything from the user table.