Tamamlanmış

CSV file to MYSQL

This is the first of several more complicated PHP/MYSQL projects I need completed.

This PHP script will be running on a standard ubuntu 18.04 installation. It will have LAMP installed.

I have a several csv files of varying length (300 lines (148k) - 12000 lines (3.1mb)), with a header and 21 fields of mixed text and numbers. I need the contents of the csv file read and put into an existing MYSQL db. Before it adds, it needs to check if the information is already existing. Only one field (the first, a string) needs to be checked to see if it is an existing entry in the database.

I would like an HTML page running on the LAMP server that allowed me to upload the csv files, one at a time. I would also like a button to download the entire database in a csv file.

I would like the code well documented.

Thank you for taking the time to consider.

Beceriler: MySQL, PHP, Linux, Yazılım Mimarisi

Daha fazlasını gör: import csv to mysql phpmyadmin, mysql create table from csv, load data infile mysql, import csv to mysql command line, automated csv import to mysql server, csv to mysql, csv to mysql converter, import csv to mysql workbench, upload data csv file mysql, uploading csv file mysql php script, perl read csv file mysql select, php script upload csv file mysql, import outlook csv file mysql, csv file mysql php large size data fastly, php transfer csv file mysql table, sned csv file mysql, send csv file mysql, upload csv file mysql database php code, upload csv file mysql using php, perl csv file mysql database

İşveren Hakkında:
( 0 değerlendirme ) Chicago, United States

Proje NO: #27569482

Seçilen:

vw580939vw

Dear Sir, -> We read your description and it looks doable so Kindly manage to get us an exact list of requirements, we can review and conclude the best estimation for you. -> We offer an hourly basis of working at th Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 20%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(174 Değerlendirme)
7.5
setiawanutama

This is an easy PHP gig. If you send me the sample of CSV file along with the table structure of MySQL, I can provide you with the PHP script.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(67 Değerlendirme)
4.7

Bu iş için 17 freelancer ortalamada $60 teklif veriyor

smilemittal181

Hello, I can easily convert CSV file into MYSQL. I am a PHP and Mysql expert who loves to code. For over the last 6+ years, I have built and customized so many websites. I use these technologies to build awesome stuf Daha Fazla

$50 USD in 3 gün içinde
(183 Değerlendirme)
7.1
websolutioner

hi sir/madam i have lot of experience like these project and i have done so many projects like this i can deliver within time and adjust whatever you asked please feel free to contact me for more details thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(79 Değerlendirme)
6.0
kripanidhi

I will make automated script that will convert CSV file to MYSQL efficiently. We are looking forward to working with you! ▶ Expert DevOps and I will update daily from Github to Production Server ▶ Focus on high-qualit Daha Fazla

$150 USD in 2 gün içinde
(55 Değerlendirme)
5.8
Flattzi

Hello, we are ready to help you build your PHP system to manage all your csv files uploading & downloading. We are expert software engineers working for big companies like PSA Group & Capgemini, and we have many yea Daha Fazla

$150 USD in 2 gün içinde
(37 Değerlendirme)
5.0
igorchrepanovdev

Hi, I understand your project enough. I can add csv file to database as bulk I have already done like this same project part before. I can do that perfectly that function in short time I want you to contact me about t Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
4.8
wangdao5211

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. As a skillful software developer, I have rich experience with CSV and MySQL data processing in PHP. I promise I will finish thi Daha Fazla

$30 USD in 2 gün içinde
(16 Değerlendirme)
4.6
CrazyProger

I already developed an PHP page running on the LAMP server that allowed me to upload the csv files, one at a time. https://www.freelancer.com/projects/php/desarrollo-script-php-con-interfaz/details Hope your kind conta Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
3.9
mayankinnovative

Dear Client, We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, OpenCart, Magento, PSD to HTML, Angular JS, Node JS photoshop, OPencart, Codeignitor, Laravel and many other technologies. We have Daha Fazla

$250 USD in 7 gün içinde
(100 Değerlendirme)
4.6
zherchang316

Hello. I have read your project description carefully and it is suitable in my skill. I can start your work right now. I'm a new freelancer here in this site, but have full experience in HTML, CSS,JAVASCRIPT,BOOTST Daha Fazla

$80 USD in 2 gün içinde
(5 Değerlendirme)
3.1
petrushin

Hi, I will build your website using Laravel and Mysql. I am a web developer with 8 years of experience. I have worked on several similar projects using Laravel and mysql, and can deliver good result to tight deadlines. Daha Fazla

$20 USD in 7 gün içinde
(1 Yorum)
2.2
bouktaibadil

Hello, i can create the script needed in a reasonable amount of time with a reasonable price i have worked on many php projects i think i can help Best regards

$20 USD in 4 gün içinde
(0 Değerlendirme)
0.0
jp89148

GENUINE PHP Expert Developer My motto: Passion, commitment, and a lot of hard work. A genuine experienced passionate web developer with relevant and proven expertise. To me,  the goal isn't to build a website. The g Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
0.0
gerrylu1

Hi there. I have completed a project which includes reading from an excel file to import user information into the database before. Reading a CSV file is very similar to reading an excel file. If you would like to disc Daha Fazla

$19 USD in 7 gün içinde
(0 Değerlendirme)
0.0
parminder67116

I'm an expert in PHP, HTML, JS, jQuery, Android, Unity, CSS, Bootstrap. I'd love to be part of your team to work on ongoing projects. ➥ Which framework I'll use:- 1. Design: PHOTOSHOP/ ILLUSTRATOR/ CORAL / PSD TO HTML Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
SolutionsTrack

Hi, It is easy job for me. I am Ashfaq, I have more than 8 years experience in web development and DevOps (Docker, Vagrant, VM). Programming was my hobby then I started using this interest as a profession and enter i Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0