First time using rentacoder so this is a very small project.
We have a number of files (all with the same format, well defined and with samples) that are uploaded every 5 minutes.
Each file contains data for a master record, with 3 slave tables. Tables have around 5 fields, so very slow.
We need a program that loads these files into a database (SQL is fine) either creating the master records or updating them as needed.
We also need a simple PHP script that reads the tables and displays them. The table must be sortable (it's OK to use any of the freeware implementation that exists).
- Script for creating the tables must be provided. We will provide a few samples of the data so this is rather trivial, but must be done.
- No need for user/pass, etc, to access the HTML. This will be handled somewhere else.
- Remember, the HTML table must be sortable.