I need a PHP script that will allow a user to select and upload a csv file and then map the csv data to the correct fields in the database.
During the import process I need the script to either insert a field into the csv file (subuserid) OR insert the subuserid into the imported records. The subuserid field is coming from a cookie.
The data that will be imported will be: first name, last name, street address, city, state, phone number, gender, date of birth and email address.
The database table has many other fields, but only the fields I describe need to be mapped.
There are some fields that may need extra "cleaning" during import: date of birth, phone and state
date of birth: mySQL date (ie Nov 12, 1985 or 11/12/85) needs to be entered in table 1985-11-12
phone number: must be 10 digit string
state: California must be CA
62 freelancers are bidding on average $145 for this job
Hello I am good in php/mysql/csv etc and have a lot experience I have done similar to this project before. I will do my best to satisfy you. Looking forward to connecting and working with you soon. Regards