Encerrado

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

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.

Habilidades: MySQL, PHP

Veja mais: what is a php file, according to the, php script open file, read codes database, php script sql, php read large file, php script setup, php file read, read file zip, copy tables, mysql tables rows, mysql empty database, read csv file php write csv file, According , sql file csv, php read write csv, read data mysql php, php script zip files, database codes, copy paste php

Acerca do Empregador:
( 49 comentários ) Tokyo, Japan

ID do Projeto: #6489780

26 freelancers estão ofertando em média $51 para esse trabalho

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 in 2 dias
(119 Comentários)
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 Mais

$157 USD em 1 dia
(513 Comentários)
7.6
waelfree

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

$54 USD em 1 dia
(118 Comentários)
7.1
rginfotech1

Greetings & Hope! you are doing well & have time to read our Proposal. We have gone through your project-requirements & we are clear regarding your project tasks. To begin work; we need : # Your said: one sql file & Mais

$40 USD in 2 dias
(107 Comentários)
6.9
html5css3php5

A proposal has not yet been provided

$210 USD in 3 dias
(75 Comentários)
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 in 2 dias
(38 Comentários)
6.2
swapnilchavan18

I have 5 years of experience in web development. I have satisfactory reviews from all the clients for more than 60 [login to view URL] review my portfolio on freelancer.com or visit www.wedevelopers.in. Please discuss with Mais

$40 USD em 1 dia
(38 Comentários)
5.9
vickycolt

Hi sir,i am interested in the project and ready to start.I can do this [login to view URL] let me know when to [login to view URL]

$50 USD in 3 dias
(59 Comentários)
5.5
jenishfaldu

Hi, Sir,, PHP specialized CORE PHP,MYSQL,XML,ajax,jQuery,CSS3,HTML5, expert is here. i am sure that m able to work on this [login to view URL] COOL 5+ YEAR experience with above skill..ready to do any work on above skill an Mais

$35 USD in 3 dias
(21 Comentários)
4.9
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 Mais

$35 USD in 2 dias
(20 Comentários)
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 Mais

$40 USD in 5 dias
(21 Comentários)
4.4
MrPathu

Hello Employer I'll be glad handle your project I am proficient in web development (HTML5,PHP, Magneto,Joomla,WordPress,Website Designing) I have been working with web-development since last 7 years. I have also Mais

$54 USD em 1 dia
(9 Comentários)
4.4
shennz

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

$35 USD em 1 dia
(8 Comentários)
4.1
balamuralip

A proposal has not yet been provided

$35 USD in 3 dias
(12 Comentários)
4.1
CaptainOfLogix

I am confident I can assist you. We are team of Pro-Coders. Moreover, I am Top Ranked American Company Expert, Done more than 1300 (full star Feedbacks) projects on Liveperson Inc. See link for my detailed list of sati Mais

$34 USD in 4 dias
(3 Comentários)
3.7
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 em 1 dia
(12 Comentários)
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 Mais

$28 USD in 2 dias
(14 Comentários)
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 em 1 dia
(7 Comentários)
3.3
lavizsolutions

Hi, Ques 1. Is it possible to have desktop application that will do it more easily and accuratly. Ques 2. When can u provide me .csv file and your database structure. Live Site : [login to view URL] Demo Url: http://l Mais

$111 USD in 3 dias
(1 Comentário)
3.3
aruna470

Hi, I already have a PHP script which does the same requirement. Which creates database, table and default data on the fly (SAAS application). Process ====== PHP script reads the SQL file and execute queries on Mais

$35 USD in 2 dias
(3 Comentários)
3.0