|All requests||>||Import Excel CSV into MySQL table||>||Request new recommendation||>||Featured requests||>||No recommendations|
by RAJESH BHATT - 5 years ago (2015-07-17)
I have tables in MySQL database. This is the structure of my database tables:
table 1 - tbl_main_categories:
My excel sheet data as follows(product.xls)
How to import file product.xls to MySQL table (tbl_products), as it contains ids from table tbl_sub_categories where as in my Excel there is name of sub_categories?
Please suggest me a library as I am beginner to PHP world.
You can use this class if you export your Excel spreadsheet to the CSV format.
It is important that the spreadsheet headers match the database field names.