Import excel to mysql using php + manual field matching
$30-100 USD
Completed
Posted almost 14 years ago
$30-100 USD
Paid on delivery
Please see attachment for a visual example of what is needed.
you need to create 1 page that will have a fileupload browse + upload button.
Once the user pick the file (excel) and click upload, the script must parse the? first row of the uploaded file? and display a list of these headers. Next to each header, display a select list containing all the fields available in a mysql table. Then for each? header the user is able to choose which column should go with each database field. A validation should be done here in order to verify that? every selected field is unique (it has not be choosed for 2 or + headers). Once the matching has been done, the user clicks ok and the script inserts the data from the excel in the right database field, as selected in previous screen.?
Thank you for your time