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

Κλειστό Αναρτήθηκε Sep 22, 2014 Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

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

Ταυτότητα Εργασίας: #6489780

Σχετικά με την εργασία

26 προτάσεις Απομακρυσμένη εργασία Ενεργό Oct 29, 2014

26 freelancers κάνουν προσφορές κατά μέσο όρο $51 για αυτή τη δουλειά

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 μέρες
(119 Αξιολογήσεις)
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 Περισσότερα

$157 USD σε 1 μέρα
(513 Αξιολογήσεις)
7.6
waelfree

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

$54 USD σε 1 μέρα
(118 Αξιολογήσεις)
7.1
html5css3php5

A proposal has not yet been provided

$210 USD σε 3 μέρες
(75 Αξιολογήσεις)
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 μέρες
(38 Αξιολογήσεις)
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 Περισσότερα

$35 USD σε 2 μέρες
(20 Αξιολογήσεις)
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 Περισσότερα

$40 USD σε 5 μέρες
(21 Αξιολογήσεις)
4.4
shennz

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

$35 USD σε 1 μέρα
(8 Αξιολογήσεις)
4.1
balamuralip

A proposal has not yet been provided

$35 USD σε 3 μέρες
(12 Αξιολογήσεις)
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 μέρα
(12 Αξιολογήσεις)
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 Περισσότερα

$28 USD σε 2 μέρες
(14 Αξιολογήσεις)
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 μέρα
(7 Αξιολογήσεις)
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 Περισσότερα

$25 USD σε 3 μέρες
(3 Αξιολογήσεις)
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 Περισσότερα

$35 USD σε 3 μέρες
(2 Αξιολογήσεις)
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 μέρες
(0 Αξιολογήσεις)
0.0
mukeshkumar0130

A proposal has not yet been provided

$35 USD σε 3 μέρες
(0 Αξιολογήσεις)
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 μέρα
(0 Αξιολογήσεις)
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 μέρα
(0 Αξιολογήσεις)
0.0