code to import excel data into mysql using php?

Question

code to import excel data into mysql using php?

Answer 1

The easiest way would be to save it from Excel as a csv file, then php can just read the lines and split at the commas. Reading an xls file in php is more complicated.

Answer 2

save your excel data into a file with a option given in excel



then import that file in mysql using wamp or any other server.



gud luck

Answer 3

Save the Excel data as .csv, then execute



LOAD DATA INFILE 'path/file.csv' INTO TABLE your_table;