We have got an Excel file where we would like to move over the information to a (non-existing) mysql database instead.
**Required:**
- PHP4 & PHP5 compatible
- Mysql db
- Import the old information from the Excel file to the database.
A password protected admin section
- to update the database (add/delete/edit records)
- Export possibilities of data (all or via search result)
- Each data field/column should be search able in combination with each other.
- Free text search
- Mark a data field/column as "hidden" for the users
User view
- Output, sort by all columns (ascending and descending as well)
- All data fields search able, in combination with each other
- Free text search
The user interface should be able to include easily in a current design (for instance via a PHP include).
An option would be to give the application a header and footer where we could make an easy design.
Any thoughts?
Sample db attached.