PHP script for populating database with tables, according to a .sql file
$20-40 USD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #6489780
Σχετικά με την εργασία
26 freelancers κάνουν προσφορές κατά μέσο όρο $51 για αυτή τη δουλειά
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
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 Περισσότερα
Hi, I can do that Let us start ......................................................................
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
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 Περισσότερα
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 Περισσότερα
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
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 Περισσότερα
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
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 Περισσότερα
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 Περισσότερα
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
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.
Well, i have made scripts like this before. I'm newbie here, so i will make this script for you pretty cheap and fast.