Basic SQL/PHP DIsplay and Administrative Interface

已完成 已发布的 Nov 11, 2009 货到付款
已完成 货到付款

Sample SQL attached. View Component: Display all servers that is not status 0 Show the following columns in display: name, dyndns, status, down, service_tag, serial_number, contact_name, street_address, city, state, zip, phone, email, computer_type, computer_ram account_number from server_info All the way on the right, you should be able to press an "Edit" button At the very bottom of the page, it should say: Number of servers: X (total # of servers that are not status 0) Number of servers by an array of computer_type and computer_ram Administrative Component for New Server We need to be able to create new servers. When we create a new server, we will need to enter the following information: Server Name: name Dyndns: dyndns Service Tag: service_tag Serial Number: serial_number Contact Name: contact_name Street Address: street_address City: city State: state Zip Code: zip Phone Number: phone Email Address: email Computer Type: computer_type Computer RAM: computer_ram Account Number: (allowed to be blank) Internet Type: type Bandwidth: bandwidth_out [SUBMIT] When you submit a new server, you should create a new entries in "server" and "server_info": Server Server Name -> name Updated -> updated (in 2009-11-11 07:25:00 format, EST) Dyndns -> dyndns Location -> NULL Status -> 1 Down -> 0 Powerx10id -> NULL Service Tag -> service_tag Serial Number -> serial_number Contact Name -> contact_name Street Address -> street_address City -> city State -> state Zip Code -> zip Phone Number -> phone Email Address -> email Server_info Server Name: -> server_name Internet Type: -> type Disabled -> 1 Instances -> 4 Ultra_connections -> 125 Network_interface -> eth0 X10id -> NULL Dslhop -> 0 Bandwidth -> bandwidth_out Address -> NULL Account Number -> account_number Updated -> updated (in 2009-11-11 07:25:00 format, EST) [Same as above] Administrative Component for Edit Server When you edit a server, all of the items should be editable on the Edit Page.

## 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

SQL/PHP

工程 MySQL PHP 软件构架 软件测试

项目ID: #2959248

关于项目

8个方案 远程项目 活跃的Nov 11, 2009

授予:

darwelljones

See private message.

$25.5 USD 在1天内
(47条评论)
5.0

有8名威客正在参与此工作的竞标,均价$42/小时

shihan033010

See private message.

$34USD 在1天里
(248条评论)
6.4
mentorvisionpak

See private message.

$42.5USD 在1天里
(34条评论)
6.0
SKJoy2001

See private message.

$63.75USD 在1天里
(81条评论)
5.9
webbaysyssys

See private message.

$59.5USD 在1天里
(32条评论)
4.7
redcic

See private message.

$34USD 在1天里
(19条评论)
3.0
technochalleger

See private message.

$42.5USD 在1天里
(3条评论)
1.3
gmedsoftware

See private message.

$32.3USD 在1天里
(2条评论)
0.0