Completed

PHP parse a csv file and prepare to insert into a mysql database

Using PHP parse a csv file and prepare to insert into a mysql database table with the same fields as outlined in the attached Excel spreadsheet tab 1. The CSV file will identical to tab 1 of the attached Excel file.

In the attached Excel file I need a new row created where the field has a delimiter of ; the fields that contain this delimiter are qty, price and uom.

I also need the rnge field to auto increment if the line was split.

Example of what I am looking for is on second tab. 0 fields delimited by ; can be ignored.

Skills: HTML, Javascript, MySQL, PHP, Software Architecture

See more: data csv file mysql database using aspnet, insert images mysql database using php, php parse xls file toupdate database, upload csv file using ajax in php, import csv file data into mysql database using php & ajax, php upload csv file to server -mysql, how to insert data in csv file using php, how to read csv file in php and store in mysql, php load csv into mysql, import csv file into mysql using php, mysql import csv command line, php registration form insert mysql database, update mysql database using csv file, import csv file mysql database using codeigniter, php parse txt file mysql, import excel file mysql database using php, insert json data mysql database using php, insert data excel file mysql database using jsp, upload excel file mysql database using php, php json insert mysql database

About the Employer:
( 35 reviews ) louisville, United States

Project ID: #18893268

Awarded to:

rajeshsonisl

Hi there, What do you mean by "prepare to insert into a mysql database" ? Do you just need the code to parse the CSV and you would be taking it forward to do the actual inserts (error handling) ? I have a 99% pr More

$100 USD in 1 day
(1000 Reviews)
8.7

31 freelancers are bidding on average $135 for this job

TenStar718

Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web More

$222 USD in 3 days
(255 Reviews)
8.7
WebInfoSolutions

Respected Sir, I needed access to database. Will I get access to online database or any database script? Will it be done in any existing code or completely independent of anything? Below is the app I worked on More

$55 USD in 0 days
(235 Reviews)
8.0
Ideallsolution

Hello How are you? I have read your job description. I am expert web design and development, can help your project surely I have rich experience with WORDPRESS, WOOCOMMERCE, MySQL, PHP, JQUERY, PSD TO HTML, PSD More

$250 USD in 3 days
(223 Reviews)
7.6
nataliaomelchenk

Hi. I am a full time developer and have high skills in web develop by PHP & MySQL. So I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service.

$155 USD in 3 days
(53 Reviews)
6.8
KashirinA

Hello, this looks like everything we could help you with. I specialize in: PHP & PHP frameworks such as Laravel, CI, Yii and CakePHP, API development, HTML5, CSS, JavaScript, Bootstrap, MySQL, etc. If you give you More

$250 USD in 3 days
(108 Reviews)
7.1
abugosia

Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$222 USD in 7 days
(166 Reviews)
6.9
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac More

$155 USD in 3 days
(53 Reviews)
6.8
AndrejStastny

Hello, Please check my previous work. https://www.freelancer.com/projects/php/Mod-plugin-for-Parsing-CSV/ I can shortly complete your requirement. Looking forward to working with you. Regards!

$111 USD in 1 day
(58 Reviews)
6.3
anatolygenay123

Hi, PLEASE CONTACT ME. I’m a senior web developer who are very confident in parse csv to database. Your task is very exciting because my ability is very suitable. I have rich experiences in responsive website design More

$155 USD in 3 days
(33 Reviews)
6.3
androidc

Hello, I have a few questions regarding your shared requirement. Please open the chat so we can discuss. I have 8 years of experience in PHP, Wordpress, YII Framework, Python, Django, Codeigniter, Laravel, JS & AJAX, More

$100 USD in 3 days
(131 Reviews)
6.7
fleedsteed

Greetings. I READ your job description carefully and checked the excel file you attached. Very confident! I have rich experience in php excel library and mysql RDBMS. So I can completely finish this job with high qu More

$150 USD in 3 days
(28 Reviews)
6.0
brightstar928

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ Hi I read your job description carefully and I can do your job perfectly. I have developed many websites So I can know what you mean and I am ready for you now. If you hire me, I will finish your job A More

$100 USD in 3 days
(37 Reviews)
5.7
Mihailovic0120

Hi, there! I've just read your job description fully and feel very interested in your job. I've been working as a full stack web developer for 7 years. I think I'm the right person you're looking for. My major skil More

$250 USD in 3 days
(25 Reviews)
5.8
lightingdavid

Hello. How are you? I am highly interested to work on the "PHP parse a csv file and prepare to insert into a mysql database". I am a full stack website developer. I have more than 7 years experience in "HTML, Javas More

$140 USD in 3 days
(89 Reviews)
6.0
liviuconcioiu

Hi, I can do the script right now. Please see my feedback as it speaks a lot about me. Lets chat. Thank you!

$30 USD in 1 day
(62 Reviews)
5.2
harrysart

⭐Dear sir.⭐ I have read your description with great interest. I have experiences with many project. Also i am able to finish the task on time. Please check my portfolio if you want to know my skill and experience. More

$80 USD in 1 day
(72 Reviews)
5.3
ranatech

sir i have read your requirement of PHP parse a csv file and prepare to insert into a mysql database .ready to start sir we can do this job because we have 10 years of experience in webdesign and development we a More

$100 USD in 3 days
(75 Reviews)
6.0
asadanjum226

Hello, I am a professional web developer with over 5 years of experience. My Skills include: 1- HTML 2- CSS 3- PHP 4- Javascript 5- WordPress 6- Code Igniter Looking forward to hearing from you.

$111 USD in 3 days
(17 Reviews)
4.9
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I have check the sheets and will code it in the same way. I have been in this industry for 1 year and such jobs are my daily practice. I More

$100 USD in 1 day
(20 Reviews)
4.6
DianaOrlove

Hello I'd really like to work with you on this task if possible! My name is Diana and I am a web developer with nearly 10 years of experience, with 9 of those years in PHP. I am interested in your project and I am More

$80 USD in 0 days
(6 Reviews)
3.8