PHP script for populating database with tables, according to a .sql file

Suljettu Julkaistu Sep 22, 2014 Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

I setup a mySQL database which now is still empty and I need to populate is with tables.

I have the .sql file with complete information about the tables (16 in total).

What I need is the php script that automatically populates the database with the respective tables, according to the sql file.

Yes, I know, it's a lot of copy-paste work.

After populating the database, two of the tables must be filled with data that never change (like ZIP codes).

The necessary information for these two tables is quite large, so it is saved in .csv files (only 2-3 fields, but many rows).

So the script should open these external .csv files, read the information and write it automatically in the respective tables of the database.

I will provide:

- one sql file

- two csv files

#Deliverables:

php file that does the tasks described above.

MySQL PHP

Projektin tunnus: #6489780

Tietoa projektista

26 ehdotusta Etäprojekti Aktiivinen Oct 29, 2014

26 freelanceria on tarjonnut keskimäärin $51 tähän työhön

netdevbiz

Hi, Please send us the SQL file and the CSV file from which the data needs to be imported. Also please specify the name of the tables that will be populated from the CSV files data. Thanks

$40 USD 2 päivässä
(119 arvostelua)
7.9
rajeshsonisl

Hello, With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wron Lisää

$157 USD 1 päivässä
(513 arvostelua)
7.6
waelfree

Hi, I can do that Let us start ......................................................................

$54 USD 1 päivässä
(118 arvostelua)
7.1
html5css3php5

A proposal has not yet been provided

$210 USD 3 päivässä
(75 arvostelua)
6.3
sukum

Hi, I am a PHP programmer. I can create the script which will automatically read from the sql file and the csv files and populate the database. Regards, Sukum

$39 USD 2 päivässä
(38 arvostelua)
6.2
freshjah

This bid includes the creation of a PHP file that does the following: 1) Restores Database from a .sql backup file 2) Populate two tables from .csv source I have been working wih PHP and MySQL databases for over Lisää

$35 USD 2 päivässä
(20 arvostelua)
4.8
needdone

Hello I can write these 2 scripts for you. I understand that you need a script that can create MySQL tables and a PHP script that reads a CSV file which contains ZIP codes that need to be added to those MySQL tables Lisää

$40 USD 5 päivässä
(21 arvostelua)
4.4
shennz

hii... ready to start.... please PM me for more details.......Thank You

$35 USD 1 päivässä
(8 arvostelua)
4.1
balamuralip

A proposal has not yet been provided

$35 USD 3 päivässä
(12 arvostelua)
4.1
kaloyan13

Hello, I can start working on your script today, and have it ready in 3-4 hours. I have done PHP parsing scripts for reading data from CSV. Thanks

$30 USD 1 päivässä
(12 arvostelua)
3.6
avinashjain09

Hello, You will provide CSV file that will have complete data ?, and I want to discuss something more with you. I have understood your requirement, I have expertise in database. In my profile maximum projects are of t Lisää

$28 USD 2 päivässä
(14 arvostelua)
3.5
gcStudioOrg

Hello, i have done this before with a few past projects & can do the same for you. Please message me if you would like for further discussion or to get started, thanks. Best regards

$35 USD 1 päivässä
(7 arvostelua)
3.3
drajendran89

Hi, I'm interested in doing this project. I have 4yrs experience in building web applications with expertise in PHP, MySQL, Oracle, MSSQL, Zend, Wordpress, Drupal, Code Igniter, HTML, CSS , jQuery. Can you please let Lisää

$25 USD 3 päivässä
(3 arvostelua)
2.0
deb4t1

Hi, I am an expert php mysql programmer and will be able to provide you a script that will populate the db tables with data from the csv files. What is the format of the csv file, will they match the table columns? Le Lisää

$35 USD 3 päivässä
(2 arvostelua)
1.7
LionTheKing

Hello, I would be very happy to collaborate with you in this project. The project seems pretty much straight forward and I think I can help . Best wishes and good luck. Luan

$40 USD 3 päivässä
(0 arvostelua)
0.0
mukeshkumar0130

A proposal has not yet been provided

$35 USD 3 päivässä
(0 arvostelua)
0.0
zephyrzx

Hello. This is a fairly simple project and I am looking to get back into freelancing again so I will do it at a low cost and quickly. Thank you and I look forward to hearing from you.

$30 USD 1 päivässä
(0 arvostelua)
0.0
dreigons

Well, i have made scripts like this before. I'm newbie here, so i will make this script for you pretty cheap and fast.

$25 USD 1 päivässä
(0 arvostelua)
0.0