PHP-MYSQL database - Need an application that works similar to Will Woodward's , address book v2.1 "[login to view URL] [login to view URL]". The purpose of this application will be to assign an undefined number of report writers with the ability to create short reports for inclusion on my Web Site. Each report will consist of five data fields: date, title, content, author and report name. Fields Data Validation All fields"not null" Date = > todays date. Content =< 625 Title =< 50 Author set by admin =< 50 Report Name set by admin =<50 Install - will create tables and fields in a mysql database for purpose explained above and below. (similar to Will Woodwards address book) Logins: Admin will have permission to login and create passwords, login names, "report names" and "author names" for report writers to use. Report writers will use assigned passwords and login names to login and write reports. Report writers will not have permission to change "report name" or "author name". They will be able to enter data for "date", "title" and "content" only. When report writers first log in their last report will be displayed for them for editing. Write - When a report writer submits a report it will be: stored in a mysql database created for that purpose and written to two text files. Admin will set the name of the text files. One text file will contain the current reports data. The second text file will contain the last four reports data, Alpha by date. (I will be parsing this data to an html file for viewing under that report name) Search - All visitors will have the ability to search the report database by any field and display reports. Admin will have the ability to search on all fields and display reports and be able to export that search result to a text file.
## 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) Complete ownership and distribution copyrights to all work purchased.
## Platform
Unix, Apachie web server