How to upload CSV file data to mysql database by php || With demo

Here you get How to upload CSV file data to mysql database by php.

Folder / file structure :

INDEX.PHP : 

In this file you get the file upload and submit form and get the list of entered data.

EXTRA.PHP :

Here we use the CSS and some javascript for display the loader.

CONTROLLER.PHP : 

Here we get the csv data and insert into the mysql table and one more query for get the all data from the mysql table.

MODAL.PHP :

Here we made the database connection like add database config, define table name etc.

CSV.SQL :

Here you get the 1 table ( code_import_csv )

CSV-TO-MYSQL.CSV :

Here is the sample file where you can change the data accordingly.

In this folder get the state and city data when user change the dropdown of country, state and city.

Technology use :

• PHP 
• MYSQL

!! Enjoy the Code !!