We have an existing Mysql table called "questions" that is fed by an existing form. Here is data structure.
-- Table structure for table `questions`
CREATE TABLE `questions` (
`firstname` varchar(60) default NULL,
`lastname` varchar(60) default NULL,
`phone` varchar(60) default NULL,
`email` varchar(60) default NULL,
`id` int(11) NOT NULL auto_increment,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
We need to build a password-protected admin application. End user would check the page, see recent questions and contact information sorted by timestamp ascending, have the ability to click a "mailto" link for each listing to reply to the question, have the ability to delete selected questions after replying.
We would like to have some visual cue that tells end user when a particular question has been previously viewed usin this tool, as opposed to new unviewed questions.
The design of this page should be simple, elegant, and professional looking, with page header text that can be configured in a php config file. The password and username can also be hard-coded in a php config file, no recovery mechanism needed.
Timestamp should be displayed in the format mm-dd-yyyy.
All HTML and layout should be valid HTML and css.
This will be used on a secure site, and the page needs to identify traffic coming in to http:// and redirect it to https://
There is no data in existing table yet, and I cannot give you access to production server, so this will have to be built on your server with dummy data. I can provide dummy data if needed, in tab delimited text.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Mysql/php on linux. IE 6+, Mozilla 1+, Safari.