Completed

PHP Script to import CSV file into MySQL with field mapping

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

Skills: MySQL, PHP

See more: php script import csv file magento, php script import csv file database, php script import csv file, php import csv to mysql, import csv file into mysql using php code, php, mysql, css, javascript, css html java my sql php, script import csv file mysql, php script import csv file mysql database, php script import csv mysql field mapping, php script import csv file mysql, script import csv file mysql php, php script insert csv file mysql database, php script uploading csv file mysql database, mysql script import csv file, php script import excel file, php script upload csv file mysql

About the Employer:
( 28 reviews ) Marlton, United States

Project ID: #17286387

Awarded to:

riteshjain009

//**CAN DO THIS AS PER YOUR NEED **// Hello Employer ! Hope you doing great. With the reference of your description We would like to inform you that we are the most eligible team here with whom you can discuss More

$155 USD in 3 days
(268 Reviews)
7.4
AshleyCASTILLO

Hi, Greetings I got your project scope and I'm very interested in your project,I can help you to code a script using PHP where allow a user to select and upload a .CSV file and then map the .CSV data to the correct f More

$222 USD in 5 days
(107 Reviews)
6.9
digitalwebricots

Hello Concern I assure you that I will build a PHP script that will allow the 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 the More

$155 USD in 8 days
(0 Reviews)
0.0

62 freelancers are bidding on average $145 for this job

WebInfoSolutions

Respected Sir Can you confirm if the csv will have total 2 type of date format? Will I abort the import in case the phone verification is failed? Can u clarify more in details about cleaning the field state? As p More

$555 USD in 5 days
(203 Reviews)
7.8
naumanrandhawa

Hi, I have gone through the project description, I can make a custom script for cleansing and importing data into the mysql database. I can start job straight away as I don't have any project running. Looking forwar More

$100 USD in 2 days
(181 Reviews)
7.5
spiretech

Hello, Greetings!!! I have gone through the post details and would like to help you writing a php script to import csv and do the rest process accordingly for sure! Let us discuss a little to understand the requirem More

$90 USD in 3 days
(84 Reviews)
6.9
webdesign786

HI My Motion: "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews to determine the quality of our work. Let’s discuss in detail and start now? I am co More

$155 USD in 3 days
(112 Reviews)
7.0
liangjongai

Hello, sir I am web developer. I have a detail look to your project, I have a great skill in design and php. I'm sure I can complete your project. My price and period is negotiable. We can discuss the details via More

$155 USD in 3 days
(219 Reviews)
7.3
raisdhaka

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

$115 USD in 2 days
(184 Reviews)
6.8
widadsaghir1993

Hi there, I just checked your proposal. I am Senior PHP Developer with 5+ years strong practical experience in building various kinds of web projects. I developed number of projects so far and I can provide perfect More

$155 USD in 3 days
(41 Reviews)
6.3
developer2581

HI Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you giv More

$111 USD in 3 days
(34 Reviews)
6.6
cmitexperts

Hello! Did go through your Job Description and glad to share that I have experience in working with PHP and mysql with import data using csv. I have more than four years of industry experience and have been the pa More

$155 USD in 3 days
(91 Reviews)
5.9
Sonicoders

I have four years experience as a web developer will do these changes quickly, we can discuss more over chat.

$100 USD in 2 days
(127 Reviews)
6.1
drgold03

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

$155 USD in 3 days
(40 Reviews)
5.9
$250 USD in 2 days
(15 Reviews)
5.4
$111 USD in 4 days
(47 Reviews)
5.5
$150 USD in 3 days
(8 Reviews)
5.1
shingjin

Hello, Thanks for your consideration. =========== Your project is related with reading CSV and operating & maintaining DB. =========== If you will award me, I will give you the perfect result and make you glad. More

$222 USD in 3 days
(32 Reviews)
5.4
pindianwebhub

Dear hiring manager, Hope you are doing well! I am a professional Web developer. I have gone through the project description. As per the given brief you are looking for a Web expert cum Designer to build a site More

$123 USD in 3 days
(11 Reviews)
4.8
adampohp79

===========Do you want to php developer? Then please choose me. ============== Dear Sir. I am Adam Poh. I have over 7+ years experience in WEB and APP development. I'll bring your idea to the next level or extend More

$155 USD in 3 days
(21 Reviews)
4.9
javedaasim

Hi, We are expert website designer and developer with more than six years of experience in website [login to view URL] will develop your website in PHP laravel so you have the full power to be able to maintain your content More

$250 USD in 3 days
(12 Reviews)
4.5
shiningdevelopor

⭐⭐⭐⭐i can do it perfectly ⭐⭐⭐⭐ I read your job description very carefully. i understood your job clearly i am very good at PHP and MySQL , of course with CSV i am ready for you and i can finish your job perfectly More

$155 USD in 3 days
(18 Reviews)
4.6
paulprabhakarand

Greetings! I am a skilled PHP developer with excellent designing skills and sure can undertake designing as well as developing of website as per your desire We are different as compare to others because of following More

$150 USD in 5 days
(23 Reviews)
4.8