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 freelancere byder i gennemsnit $145 på dette job
Hello, I am experience with this. I do some script regarding CSV to MySQL. Let's discuss. I am ready to start today and complete in 48hrs. Regards Rais
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