use php to download csv, and import into mysql

script language: PHP

database: mysql



name varchar

state (varchar) 2 letter us state code

type varchar(city, county, school district, university, college)

url varchar

id (auto insert)

createddate (auto insert)

modifieddate (auto update)

the script will need to do the following actions:

1 create the table

2 download the 4 csv file mentioned below

3 import the data into the table


[login to view URL]

get the unique LEA_NAME for the name value. Each of the LEA_NAME values is in the csv multiple times. i only want each unique entry in the database once.

populate type = "school district"

put LEA_NAME into name columnn

put ST imto state column

put website into url column


[login to view URL]

populate type = "county"

put the first column into name column

convert the state from full name to 2 letter acronym

put second column in the state column


[login to view URL]

populate type = "city"

put NAME into name column

put USPS into state column


[login to view URL]

populate type = "university"

ignore any row where the first column is not US

put second column into name column

put third column into url column

Taidot: PHP, MySQL

Näytä lisää: export data from mysql table to csv file using php, upload csv file in php example, import csv file data into mysql database using php & ajax, import excel file into mysql using php, import large csv file into mysql php, how to read csv file in php and store in mysql, export csv file in php, import csv file into mysql using php demo, php browse file import mysql, php csv import mysql, php transfer csv file mysql table, use php script capture email mysql, php upload csv database mysql, php download csv file yahoo finance, csv import mysql perl, php process csv file mysql, php upload csv file mysql, php download csv file script, php ajax csv import, php pixmania csv import

Tietoa työnantajasta:
( 15 arvostelua ) Kennesaw, United States

Projektin tunnus: #20114278

Myönnetty käyttäjälle:

                                                's Profile Picture"                                                    >
                                        <div class=

Hi there So I can create PHP script which will download zip files with csv, unpack and import data to created mysql tables in accordance with your project description. Will deliver in an 2 hours or less. Regards, Vla Lisää

$50 USD 1 päivässä
(335 Arvostelua)

69 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, I can create this using pure PHP (no framework). It should be run as cron or only one time? I can complete in 24 hours.

$120 USD 1 päivässä
(823 arvostelua)

Hello! Hopefully you are fine! I am a freelancer PHP developer and have experience in PHP script writing. You can view my profile regarding this and can view ther following project as an example: [login to view URL] Lisää

$175 USD 3 päivässä
(163 arvostelua)

Hello Nice to meet you. I am a PHP expert with over 10 years experience. I will do my best to satisfy you. I promise quick turnaround times, great customer service and 100% quality work. I look forward to hear Lisää

$155 USD 3 päivässä
(137 arvostelua)

Dear client PHP, MySQL expert with 8+ years of experience. Please contact me and let me know your job in detail I can start right now Thanks Regards. Widad

$140 USD 3 päivässä
(85 arvostelua)

PHP MYSQL EXPERT WITH 7+ YEARS OF EXPERIENCE Hi, I have checked the attachments and i can complete this data management job for you as per requirements. I am expert in PHP, MySQL, MS SQL, WordPress, woocommerce, W Lisää

$200 USD 4 päivässä
(102 arvostelua)

I can do it for you. Please check my reviews and then decide on me. Looking for a long term relationship. Thanks, Ajit

$100 USD 3 päivässä
(276 arvostelua)

Dear Sir! I’d like to describe myself as someone who is versatile and determined and someone who loves learning. I am creative, open-minded and easy going and I enjoy working with others. And I tried to use all these q Lisää

$150 USD 3 päivässä
(82 arvostelua)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] Lisää

$155 USD 3 päivässä
(86 arvostelua)

Hi there, I am expert level of PHP/Mysql developer. I have already done similar kind of work many times , i mean import csv or excel file into Mysql database in specific manners. Not only import i can make it so you ca Lisää

$120 USD 2 päivässä
(63 arvostelua)

⭐Dear Hiring Manager, Thanks for your positng. I have read your description carefully with good experiences in the skills for your project. I hope work for you because my skill set is very suitable to your project. I a Lisää

$150 USD 1 päivässä
(117 arvostelua)

Greetings. I'm very happy to have a chance of bidding your project. I am serious bidder here and I have a deep understanding with 11 years of experience in this industry and can deliver as you have mentioned. I can su Lisää

$140 USD 7 päivässä
(66 arvostelua)

Hello Sir, I can deliver simple php based code to do database insert in 1 day. I am willing to start right away. Please check my profile for work and experience. Regards Ashwin

$120 USD 1 päivässä
(178 arvostelua)

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$250 USD 4 päivässä
(66 arvostelua)

Hi, employer. i am strong in PHP and database programming I've read your proposals carefully and I think I can do it. I have many previous works in this work and I will complete your project definitely. The person wh Lisää

$150 USD 2 päivässä
(20 arvostelua)

Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a Lisää

$140 USD 7 päivässä
(42 arvostelua)

Hello I have read your posting with great interest, because it is very proper for my skills I am Full Stack Developer with 10 years experience for Web development I have rich experience with Php, Java, MySQL, Git & Lisää

$155 USD 2 päivässä
(32 arvostelua)

Hi Mate, Hope you are doing well !! I have read job description and your requirements are fully clear to me and I am applying only because I meet all the requirements that you are looking for. I am Sr. PHP/MySQL De Lisää

$250 USD 7 päivässä
(64 arvostelua)

Hi, client. Thank you for your posting. I can finish your task in time successfully and you will be satisfied my result. Because I have rich experience of php and mysql and I have developed many project. Please discuss Lisää

$300 USD 7 päivässä
(34 arvostelua)

Hello My name's Hongri, Sr Full-Stack Developer with 7 years of experience. After reading your description carefully, I have convinced that this project will be completed in time perfectly as you want. ⭐⭐⭐⭐⭐Especially Lisää

$140 USD 7 päivässä
(27 arvostelua)

Thank you for your posting. I am interesting in your project. I'm senior Laravel, PHP, SQL, Javascript developer. I am sure, I will do my best to work with you on your project to present the best possible outcome for y Lisää

$140 USD 3 päivässä
(82 arvostelua)