Find Jobs
Hire Freelancers

Generic PHP script to upload data to mysql

$30-250 USD

완료함
게시됨 6년 이상 전

$30-250 USD

제출할때 지불됩니다
I am looking for a generic php script that will let me select a csv file (see sample below) and insert the data in the file in to a mysql database. Details of the the upload should be displayed on the screen. In case of errors, the exact error and line number should also be mentioned. The following features are required. 1) The database name, server ip, username and password would be configured in the script. 2) The table name would be the first row of the csv file. 3) The column names would be the second row of the csv file. 4) The delimiter used in the CSV would be comma (,) but it should be configurable at the top of the script in case I need to change it. All data elements would be enclosed in double quotes ("). Commas in between two double quotes should be ignored. 5) MySQLi should be used. 6) mysqli_real_escape_string() Function should be used to escape any special character. 7) After completing the execution of the script, the number of records inserted should be displayed. 8) In case of error, the entire file should be rolled back using mysql transactions. The line number and error details of the first encountered error should be displayed. 9) Basic validation of the csv file should be done. The following errors should be captured. -a The database and table name should be a valid one. -b Column names in the file should be found in the table. -c Right number of data elements based on the first row -d Proper enclosure of data in double quotes. -e NULL values being inserted into NON-NULL columns. -f proper handling of string and numeric values. 10) The script should be able to handle up to 10,000 rows. SAMPLE CSV FILE =============================== "Employees" "Employee_Name","job_title","salary" "Mike","CEO","500000.00" "John","Manager","100000.00" "Mark","Supervisor","25000.00" ===============================
프로젝트 ID: 14025045

프로젝트 정보

28 제안서
원격근무 프로젝트
활동 중 7년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi! I already have working parts so I'll do it quickly and qualitatively. I'm ready to start working on your project right now.
$55 USD 1일에
5.0 (29 건의 리뷰)
5.2
5.2
28 이 프로젝트에 프리랜서들의 평균 입찰은 $149 USD입니다.
사용자 아바타
Hello. I'm professional web developer since 2006. My specifications: eCommerce and custom scripts. I have experience in such areas: PHP, MySQL, HTML5, CSS3, JavaScript, Bootstrap, jQuery, XML, csv. I can develop this script. Regards
$140 USD 2일에
4.9 (92 건의 리뷰)
7.0
7.0
사용자 아바타
HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 10+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON ME. LOOKING FOR A LONG TERM RELATIONSHIP. -------------- THANKS, AJIT
$120 USD 3일에
4.9 (284 건의 리뷰)
6.8
6.8
사용자 아바타
I can get this done for you pretty quickly, in just a couple days time, just let me know when you are ready to start.
$138 USD 3일에
4.8 (154 건의 리뷰)
6.5
6.5
사용자 아바타
Hello Sir, hope you are fine, I am interested in your work "Generic PHP script". I will create this application in Custom PHP I have 5 year experience in Web Development Service I am able to this job quickly. You can view my profile for details to skills and customer feedback https://www.freelancer.com/u/kazimking
$150 USD 3일에
4.9 (45 건의 리뷰)
5.5
5.5
사용자 아바타
Ready to cooperate with you. My experience is more than 6 years. I work with php, mysql, js, css, html.
$111 USD 2일에
4.7 (20 건의 리뷰)
5.8
5.8
사용자 아바타
Hi! I can help you with this project. Had a similar experience about uploading CSV and importing to MySQL. Do you need any special UI? Ready to discuss in chat
$250 USD 1일에
5.0 (17 건의 리뷰)
5.5
5.5
사용자 아바타
Hi, I'm Ing of systems With over 10 years of experience developing large-scale applications and providing web technology solutions for freelancers , small, medium and large businesses. Habilidades y experiencia relevante 1) HTML5 + CSS3 2) PHP POO laravel, Zend 3) Javascript Boostrap, Jquery, Angular 4) Database Mysql, Oracle, Postgresql 5) GIT, SVN Thanks good day.
$138 USD 2일에
4.5 (41 건의 리뷰)
5.4
5.4
사용자 아바타
Sir that's a pretty straightforward project, I have read it. I'm new to this platform that's why my bid is low, I just need a good review, I will do the best work for you.
$35 USD 4일에
4.5 (22 건의 리뷰)
5.2
5.2
사용자 아바타
I completely understand your requirements. I have experience working in CSV parsing and insertion in database. I will also use proper validations before inserting data in database. I will also use transactions, so that data can be rolled back. I have 4+ experience in PHP and MySQL and I ensure you that you will be getting only quality work.
$50 USD 2일에
5.0 (11 건의 리뷰)
4.3
4.3
사용자 아바타
Hello I understood that you are looking for a configurable PHP script where you can put any excel data into any table of your choice. You want to have access to choose DB, table, columns, CSV delimeter and show relevant error info on failure + rollback MYSQL transaction (or) show number of inserted rows. I can build the script in native PHP with MYSQL support with configuration file where you can make the changes.
$138 USD 3일에
4.8 (6 건의 리뷰)
3.8
3.8
사용자 아바타
A proposal has not yet been provided
$222 USD 3일에
5.0 (2 건의 리뷰)
2.5
2.5
사용자 아바타
Respected Sir, Thank you for taking the time to read our initial posting. I have read initial project description and i am ready to start this project.I have done similar project by using pdf and excel also. For further details, please message in the pmb. Look forward to hearing from you. Thanks, Nomakram
$188 USD 3일에
5.0 (2 건의 리뷰)
0.2
0.2
사용자 아바타
I am a web developer in PHP and MYSQL.I have inhand 4 years of experience in this field.I have also worked in Ajax ,Javascript,Codeigniter,wordpress and Joomla.I am sure I can complete the task within the timestamp as per the requirements.
$155 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Looks easy for me. Hope to deliver as fast as possible .
$155 USD 6일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
plz send me the details. I think I can do that. also I have a 4 member team so... I am have enough protentialily to do write the code then others
$187 USD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi I'm PHP guru I already have a generic PHP for CRUD and upload. You just define table structure in XML and run. escaping , datatypes a dynamically managed I can demo you the script Hire me to update this script and release yours
$166 USD 2일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
> will use mysqli and prepared statement. > insert in transaction or display failed lines. > in only one php file. as simple as possible.
$111 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED ARAB EMIRATES)
Newark, United Arab Emirates
4.8
13
결제 수단 확인
9월 1, 2005부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.