How to Import Large Excel File to MySql using PHP

In this tutorial we will learn how to “Import Excel Sheet Data in MySQL Database using PHP. If we insert data one by one it will be very difficult and time consuming. Here You will learn how to insert bulk of data in database from excel sheet in a couple of minutes.

Many times excel sheet import to mysql and generate this type error.

Fatal error: Allowed memory size of 134217728 bytes

This error solution describes just two line code.

ini_set('memory_limit', '20000M');
ini_set('max_execution_time', 600); //600 seconds = 10 minutes