upload excel data to mysql using PHP

mohans
03:01:14
hi ,
i have a excel file with data fields like classname,city,mobile,e-mail,etc
but i have mysql database with two tables.one table contains classname,another one contains remaining fields.Now i want to upload a single excel file like datas mentioned above to both the table by a single upload using php.Can anyone help...
smo1234
03-03-2014
By uploading excel file you can't populate MySQL table. Save the excel file as CSV file and then develop a PHP script to use the CSV data and insert required fields to different tables.

Using CSV file generate two arrays. Use each array for each table.
priya77755
04-14-2014
Save the excel file as CSV file and then develop a PHP script to use the CSV data and insert required fields to different tables.To have php training click on - http://netultimateschool.com/
Please Login to post your reply or start a new topic