Đã hoàn thành

use php to download csv, and import into mysql

script language: PHP

database: mysql

NO FRAME WORKS

Table

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

A

[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

B

[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

C

[login to view URL]

populate type = "city"

put NAME into name column

put USPS into state column

D

[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

Kĩ năng: PHP, MySQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 15 nhận xét ) Kennesaw, United States

ID dự án: #20114278

Được trao cho:

rsdsoftsl

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 Thêm

$50 USD trong 1 ngày
(335 Đánh Giá)
7.5

69 freelancer đang chào giá trung bình $148 cho công việc này

uhjk

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 trong 1 ngày
(823 Nhận xét)
8.2
mushrraf

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] Thêm

$175 USD trong 3 ngày
(163 Nhận xét)
7.6
drgold03

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 Thêm

$155 USD trong 3 ngày
(137 Nhận xét)
7.3
widadsaghir1993

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 trong 3 ngày
(85 Nhận xét)
7.3
abhaygoswami1

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 Thêm

$200 USD trong 4 ngày
(102 Nhận xét)
6.8
csajit

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 trong 3 ngày
(276 Nhận xét)
6.8
yuriyes43

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 Thêm

$150 USD trong 3 ngày
(82 Nhận xét)
6.9
polarjin2017

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] Thêm

$155 USD trong 3 ngày
(86 Nhận xét)
6.7
fahada305

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 Thêm

$120 USD trong 2 ngày
(63 Nhận xét)
6.2
harrysart

⭐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 Thêm

$150 USD trong 1 ngày
(117 Nhận xét)
6.4
Mickelson

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 Thêm

$140 USD trong 7 ngày
(66 Nhận xét)
6.3
nixtech

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 trong 1 ngày
(178 Nhận xét)
6.4
dynamitewebsol

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

$250 USD trong 4 ngày
(66 Nhận xét)
6.3
wonwon424

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 Thêm

$150 USD trong 2 ngày
(20 Nhận xét)
5.8
adampohp79

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 Thêm

$140 USD trong 7 ngày
(42 Nhận xét)
5.7
HongCStar86

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 & Thêm

$155 USD trong 2 ngày
(32 Nhận xét)
5.9
symaticssolution

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 Thêm

$250 USD trong 7 ngày
(64 Nhận xét)
6.9
dokam2050

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 Thêm

$300 USD trong 7 ngày
(34 Nhận xét)
5.7
hanchenglu

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 Thêm

$140 USD trong 7 ngày
(27 Nhận xét)
5.4
jinxing4

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 Thêm

$140 USD trong 3 ngày
(82 Nhận xét)
5.7