How to increase maximum execution time in laravel?

php laravel laravel-5 maatwebsite-excel laravel-excel
Nadeshiko Rin picture Nadeshiko Rin · Dec 18, 2018 · Viewed 13.4k times · Source

I want to upload large excel file. But because the file contains many rows, the loading is so slow and I got this error:

FatalErrorException in Controller.php line 457: Maximum execution time of 120 seconds exceeded

I already put this on my .htaccess:

<IfModule mod_php5.c>
    php_value max_execution_time 1500
    php_value upload_max_filesize 15M
</IfModule>

I also add this at the top of the controller:

ini_set('memory_limit', '3000M');
ini_set('max_execution_time', '0');

I also change max_execution_time at the php.ini:

max_execution_time = 300

And also add this on config.inc.php:

$cfg['ExecTimeLimit'] = 0;

I wonder why it's not work at all and keep getting me into that error... Is there a miss at the code? Any help would be appreciate, Thanks!

Answer

Mayur Panchal picture Mayur Panchal · Dec 18, 2018

Edit php.ini:

php.ini path : /etc/php5(your php version)/apache2/php.ini

max_execution_time = 360      ; Maximum execution time of each script, in seconds (I CHANGED THIS VALUE)
max_input_time = 120          ; Maximum amount of time each script may spend parsing request data
memory_limit = 128M           ; Maximum amount of memory a script may consume (128MB by default)

I hope this could help you.

Related questions

Call to undefined method Maatwebsite\Excel\Excel::load()

I'm trying to import excel file (.xlsx) using maatwebsite 3.0. How to fix This error Call to undefined method Maatwebsite\Excel\Excel::load() My controller public function importsave(Request $request) { if($request->hasFile('excel')) { $path = $request->file('excel')-&…

Read More
Reading excel file in Laravel

I'm using Maatwebsite's library for reading and creating excel file. The creating was easy and somehow intuitive, but when it comes to reading one, I simply can't figure it out. This is how my excel file looks like: I figured …

Read More
Laravel Checking If a Record Exists

I am new to Laravel. Please excuse the newbie question but how do I find if a record exists? $user = User::where('email', '=', Input::get('email')); What can I do here to see if $user has a record?

Read More