Find Jobs
Hire Freelancers

Create php script to upload thousands of line into mysql database qetting data from csv file

$10-30 USD

Cancelled
Posted over 7 years ago

$10-30 USD

Paid on delivery
Need to create a php script to upload thousands of lines into mysql form .csv file, I want to avoid to insert line by line due to server performance. The script should do: 1. read a .csv file located in server and identify each column in a separate variable. For example $file = @fopen("'".$file_name."'", "r"); $lines = @file($file_name); $type_sep = ","; foreach ($lines as $line) { $items = explode($type_sep, $line); $col1= $items[$col1]; $col2= $items[$col2]; $col3= $items[$col3]; } 2. If file has 2000 lines the script should construct and sql query withing a loop and execute the query every time that meet an specific value from a variable, for example every 100 lines that comes from variable $execute _every = 100; .
Project ID: 12552673

About the project

17 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $62 USD for this job
User Avatar
Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery. I have over 5 years industry experience in development and graduated with a Masters Degree in IT from the Hong Kong University. My PHP L1 exam score in Freelancer places me in the top 3% of developers. Please have confidence in my skill and quality of work. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will also do my best to correct any area of work where quality comes into question, I want to have pride in my service to your company and the final product provided. While I am happy to make adjustments and alterations as your project progresses please understand that I am a dedicated freelancer and any work that is substantially different from the project description may need the awarded fee to be re-negotiated. Feel free to contact me if you have any questions, and please review my 5 star profile. I look forward to working together in partnership on your project and into the future. Regards
$54 USD in 1 day
5.0 (161 reviews)
7.9
7.9
User Avatar
Hi sir I am Hasan Jack and I have have been doing php development since last 5 years and because of my relevant skills and experience I really find my best fit for this job. Looking forward to hear from you. Regards, Hasan Jack
$30 USD in 1 day
4.8 (13 reviews)
4.9
4.9
User Avatar
Hi! I would be happy to help setup the csv uploader. I would be happy to show a demo prior to your decision to award the project. Regards, Ku
$25 USD in 0 day
5.0 (23 reviews)
4.8
4.8
User Avatar
Greetings I have read your job description and I want to talk about more that regards that I can do that project within the time frame I have more than 3 years’ experience in web development skills like PHP WordPress jQuery and I can do it in required time frame you can view my profile for the description and I have work I work on 100% satisfaction never leave client unjustified so I am waiting for you positive reply Regards Amjad Ali
$25 USD in 1 day
5.0 (27 reviews)
4.6
4.6
User Avatar
Hi, I would like to give the solution for getting the data from csv to mysql database. Come in chat for further discussion. Thanks
$20 USD in 1 day
4.8 (7 reviews)
3.4
3.4
User Avatar
***Ready for the Interview. ***Ready for the Quality test demo. ***Ready without any Upfront milestone. Hi, Hope you are keeping well and thanks for posting the Job. I have read and understood your requirement of creating php script to upload multiple data. I would like to work with you as the dedicated resource. Securing over 5 years of professional experience in the Php Look forwards to hearing from you, Many Thanks. Regards
$30 USD in 1 day
4.6 (6 reviews)
3.1
3.1
User Avatar
Dear Boss, We could use python script to do this task. If you like this solution, plz pm me. Thanks !
$25 USD in 2 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Hi, I am an experienced php developer. I have 4 years experience in this field. I will do your project with minimum amount and with maximium quality.
$20 USD in 1 day
5.0 (1 review)
0.7
0.7
User Avatar
Hello! My 5 years experience with PHP and mysql would make me the perfect candidate for your problem. If you can provide me with an example csv, database information and a rough layout how you want the UI to look like, I am sure I can complete your task within a short amount of time. BR Chris
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of COSTA RICA
Grecia, Costa Rica
5.0
10
Payment method verified
Member since Feb 12, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.