Fatal error: Maximum execution time

[tho-can-code]

When I have a large data in CSV file (in my case, I have the data with 24 columns and 1000 rows need to be imported), it's will have the error

Fatal error: Maximum execution time of 30 seconds exceeded...

Would you like to check to avoid this issue?

[suin]

You may have to increase your PHP maximum execution time setting.

See:

• http://php.net/manual/en/function.set-time-limit.php
• http://php.net/manual/en/info.configuration.php#ini.max-execution-time

[tho-can-code]

The problem is if I'm using a server and I don't have permission to modify PHP maximum execution time setting, how can I increase it. And how can we determine what time is enough if we have a very big data to import ???

[suin]

Did you try set_time_limit() above?

[tho-can-code]

I have tried to call set_time_limit(0)

if ($count === 0) {
$stmt = $pdo->prepare('INSERT INTO user (id, name, email) VALUES (?, ?, ?)');
$stmt->execute($columns);
set_time_limit(0);
}
...

but it can't work well.

[suin]

Humm... You should contact your server admin.
It seems that you have no permission to change that limitation.
If safe-mode is enabled by php.ini, you have no way to increase that.

http://php.net/manual/en/ini.sect.safe-mode.php#ini.safe-mode

[tho-can-code]

Hummm... I'll contact my server admin to find a solution for this.
Another one, I have tried to debug, it seems that we always have an exception error at the end.
Can you check?

try {
echo "importing.........";
$lexer -> parse($path, $interpreter);
} catch (\Exception $e) {
echo "error.........";
$result['error'] = 'error message';
}