Project Detail

Simple Flatfile Database w/PHP or Perl Admin Panel  

Simple Flatfile Database w/PHP or Perl Admin Panel is project number 367975
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: ShahidMahmood

Budget: $30-250

Created: 01/09/2009 at 14:45 EST

Bid Count: 11

Average Bid:
$ 142

01/10/2009 at 14:45 EST

Project Creator: havacodirect
Employer Rating: 9.6875/109.6875/109.6875/109.6875/109.6875/109.6875/109.6875/109.6875/109.6875/109.6875/10 (16 reviews)

Bid On This Project
 

Description

This is a small, simple database project.

We need two PHP or Perl CGI screens that write to a flat file database.

SCREEN #1 (User Screen)

The first screen lists the contents of a separate .csv file (which we manually export from an Excel spreadsheet). This database contains fields SKU, Item Name, Gender, Size, Color, QTY AVAIL.

Beside each line item on the User Screen is a check box. The user can check-mark only one item in the list. If the QTY field in the Item Database = 0, this item does not appear in this list on the User Screen.

At the top of the User Screen is an input field that requests an Order Number. When the Submit button is clicked, the page checks another .csv flat file database (Order Number Database). If that Order Number appears in the APPROVED field in this database, then the Item Name that was check-marked is e-mailed to us (all item attributes) and a thank-you message appears. If the Submit button is clicked without first selecting an Item in the list, an error message is displayed to the User.

When the submission is successful, the Order Number is moved to the FILLED column in the database. Also, the Item selected by the user is adjusted in the QTY column of the Item Database (-1).

SCREEN #2 (Admin Screen)

This admin screen is password protected. Upon authentication, admin sees a list of all items in the Item Database (even items with QTY = 0).

The admin can change and save all attributes, including adding and deleting items.

This screen should allow a .csv export of the database.

This screen should also allow admin to view, add, change, and delete entries in the Order Number database (Approved and Filled fields).

DATABASES

There will be about 100 entries in the Item Database.

There will be about 50 entries in the Order Number Database.

MISC

Please see mock-ups attached.


Additional files submitted:
user-screen.jpg

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

150

4 days

01-09-2009 16:28 EST

Hello, i can do this. Please refer PMB. Thanks.

help

 

95

1 day

01-09-2009 20:47 EST

I would like on your project.

help

 

100

3 days

01-09-2009 21:47 EST

Hi, I would love to do it for you. Ready to proceed. Regards Shahid

help

 

200

5 days

01-09-2009 20:53 EST

Please see PM for details. Thank you!

help

 

100

5 days

01-09-2009 17:23 EST

Hello, please see PM for details. sduras

help

 

250

10 days

01-09-2009 14:54 EST

Please check the PMB

help

 

200

4 days

01-09-2009 14:57 EST

This would require very basic php scripting. I could get you up and running in no time.

help

 

100

1 day

01-09-2009 15:56 EST

I noted the urgency, and I can guarantee the two scripts to be produced within 24 hours. I've sent more details to your PMB.

help

 

99

2 days

01-09-2009 15:03 EST

(No Feedback Yet)

Hello, I can code your project in php. Do you require some sort of template for the 2 scripts? Please feel free to ask any questions.

help

 

175

1 day

01-09-2009 17:31 EST

(No Feedback Yet)

I am available to do this work as per your requirements. I would choose to do the work in perl - in double-quick time.

help

 

95

1 day

01-09-2009 17:54 EST

(No Feedback Yet)

Very straight forward. Easy in php/mysql.

help


    Bid on this Project