I have a table in an MySQL database that needs to be filled with data from a text file. The text file is in CSV (comma separated values) format and contains the following fields: sku, title, price, image url and description. **The database has been provided by my web hosting company so it is _online_, however, I have access to an online interface (phpmyadmin).**
The fields present in the MySQL table are: sku, title, price, image and description.
I've tried using the LOAD command but it apparently has been deprecated or removed. I need a PHP script that will read the text file and put the data into the table.
The script should be well commented enough so that I can make any necessary changes quickly and easily. The script will be opened using Notepad.
Instructions on how to upload the script as well as where to store the text file **MUST** be included.
1) Complete and fully-functional working PHP script(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.