PHP/MYSQL script to display and maintain data

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,

`question` text,

`id` int(11) NOT NULL auto_increment,

`ts` timestamp NOT NULL default CURRENT_TIMESTAMP,



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.

## Deliverables

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).

## Platform

Mysql/php on linux. IE 6+, Mozilla 1+, Safari.

Habilidades: CSS, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website, XML

Ver mais: web config php, ts web, table data structure, simple data structure, questions of data structure, question of data structure, production tool, php script null, php create table, php coder file, new hire questions, new data structure, need of data structure, mysql gpl, mozilla web design program, key data structure, html code for contact form to email, gpl mysql, design a data structure, dd for hire, data structure with c, data structure that, data structure questions, data structure in, data structure design

Acerca do Empregador:
( 121 comentários ) United States

ID do Projeto: #3028129

Premiar a:


See private message.

$63.75 USD em 2 dias
(27 Avaliações)

4 freelancers are bidding on average $68 for this job


See private message.

$102 USD in 2 dias
(572 Comentários)

See private message.

$42.5 USD in 2 dias
(671 Comentários)

See private message.

$63.75 USD in 2 dias
(203 Comentários)