Lengkap

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

Kemahiran: PHP, MySQL

Lihat lagi: 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

Tentang Majikan:
( 15 ulasan ) Kennesaw, United States

ID Projek: #20114278

Dianugerahkan kepada:

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 Lagi

$50 USD dalam sehari
(335 Ulasan)
7.5

69 pekerja bebas membida secara purata $148 untuk pekerjaan ini

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 dalam sehari
(823 Ulasan)
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] Lagi

$175 USD dalam 3 hari
(163 Ulasan)
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 Lagi

$155 USD dalam 3 hari
(137 Ulasan)
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 dalam 3 hari
(85 Ulasan)
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 Lagi

$200 USD dalam 4 hari
(102 Ulasan)
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 dalam 3 hari
(276 Ulasan)
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 Lagi

$150 USD dalam 3 hari
(82 Ulasan)
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] Lagi

$155 USD dalam 3 hari
(86 Ulasan)
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 Lagi

$120 USD dalam 2 hari
(63 Ulasan)
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 Lagi

$150 USD dalam sehari
(117 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(66 Ulasan)
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 dalam sehari
(178 Ulasan)
6.4
dynamitewebsol

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

$250 USD dalam 4 hari
(66 Ulasan)
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 Lagi

$150 USD dalam 2 hari
(20 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(42 Ulasan)
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 & Lagi

$155 USD dalam 2 hari
(32 Ulasan)
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 Lagi

$250 USD dalam 7 hari
(64 Ulasan)
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 Lagi

$300 USD dalam 7 hari
(34 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(27 Ulasan)
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 Lagi

$140 USD dalam 3 hari
(82 Ulasan)
5.7