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
php file that does the tasks described above.
26 freelancers estão ofertando em média $51 para esse trabalho
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
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
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