Đã hoàn thành

156134 Database Interface (PHP, CGI)

This project is for the creation of a simple MySQL database interface.

We need two panels.

***** PANEL #1 *****

The first panel requests a zipcode and an order number, then returns the results:

Order #

Order Date

Item #

Item Name



Expected Ship Date



The "Status" is either Backordered (default), Shipped, Canceled By Customer, or Canceled By Warehouse.

If the "Status" is Backordered, then a Cancel button appears beside each result. When clicked, this changes the "Status" to "Canceled By Customer".

***** PANEL #2 *****

The second panel is the same as the first panel, but has an administrator username and password. The search fields are Order Number and Item Name.

It also includes an "Add Listing" feature where items can be added with all of the previous attributes, and a View All feature which allows viewing all items in the database. Also, a View All Open Items link (which doesn't display any items with the "Status" of Shipped, Canceled By Customer, or Canceled By Warehouse).

This panel also has one additional "Status" option: "Shipped". It also allows the admin to change the status (Update), and a text field to enter data into the Comments field and Expected Ship Date (optional). The default values for these two fields is (Comments) "None" and (Expected Ship Date) "Not Yet Assigned".

In this second panel, the Cancel button is available on items that have a "Status" of Backordered. If the cancel button is pressed in this second panel, the status is changed to "Canceled By Warehouse".

Thank you for your interest in this project.

Kĩ năng: Bất kì công việc gì, MySQL, Perl, PHP

Xem nhiều hơn: mysql customer database, mysql database administrator, database administrator, update status php mysql, interface panel, enter data database, php view data, php data view, added database, database project php, mysql update values, update values mysql, simple project database php, database warehouse, customer interface, simple customer php mysql, add search feature php, project warehouse, php changes database, update quantity mysql, simple mysql database admin panel, search interface mysql, simple display results php, search interface, date link creation date

Về Bên Thuê:
( 85 nhận xét ) Grandville, United States

ID dự án: #1902319

Được trao cho:


Can do this, Arsen

$99 USD trong 4 ngày
(133 Đánh Giá)