I need a basic report writter that will allow my employees to display and export data from several mySQL databases. The databases are stored on a Linux Server running PHP 4.x.
The report writter should work very similar to MS Access Query Tool or something similar.
**Requirements:**
- basic: no need for charts or graphics -- something formatted in columns and can be exported for Excel would be great.
- can connect locally to our **MySQL** database (no remote access (no ODBC))
- want something written in **PHP**
- Web-based (all staff telecommute so we need to design & view reports online)
- has a GUI as these reports will be designed & viewed by various level staff.
- not looking for a DBA-type tool (we're using PHPMyAdmin for that)
These reports range from the basic (e.g. showing lists of members) to reports with calculations (counts, averages, sorts) for certain periods of time (daily, weekly, monthly).
I have an open mind and will consider other alternatives that meets the requirements listed above.
## Deliverables
1) Complete and fully-functional working program(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) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
## Platform
Linux