Em Andamento

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,

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.

## 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 data structure, question data structure, production tool, php script null, php create table, php coder file, new hire questions, new data structure, need data structure, mysql gpl, mozilla web design program, key data structure, gpl mysql, design data structure, data structure questions, data structure design, data structure code, css admin tool, create table php, application web php mysql, application data structure

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

ID do Projeto: #3028129

Premiar a:

ericski

See private message.

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

4 freelancers estão ofertando em média $68 para este trabalho

betatea

See private message.

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

See private message.

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

See private message.

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