Simple Flatfile Database w/PHP or Perl Admin Panel

Closed

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.

Skills: Perl, PHP

See more: php sort flat file, simple perl database, perl simple database, simple perl flat file, flat file database creator, php flat file message board, simple flat file database php, simple file database, php to excel export, php project name list, password protected excel, mark fields, php flatfile admin panel, perl flatfile database admin, flat file database perl, php database flatfile, php signup login flatfile, flat file database php delete, flatfile php board, simple perl database file, easy php entry view flat file database, sort flat file database column, admin database flatfile php, php flatfile database class, flatfile

Project ID: #367975

Awarded to:

ShahidMahmood

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

$100 USD in 3 days
(27 Reviews)
5.0

11 freelancers are bidding on average $142 for this job

utpal4job

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

$150 USD in 4 days
(63 Reviews)
5.9
fastphp

I would like on your project.

$95 USD in 1 day
(29 Reviews)
5.6
kallidan

Please see PM for details. Thank you!

$200 USD in 5 days
(7 Reviews)
4.5
gedgey

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

$175 USD in 1 day
(9 Reviews)
4.4
allandmore

Hello, please see PM for details. sduras

$100 USD in 5 days
(6 Reviews)
3.6
agiorlando

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.

$100 USD in 1 day
(4 Reviews)
3.0
virgilmelinte

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.

$99 USD in 2 days
(7 Reviews)
2.9
KJPHPDev

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

$200 USD in 4 days
(2 Reviews)
1.6
seditiosus

Very straight forward. Easy in php/mysql.

$95 USD in 1 day
(1 Review)
0.0
srilankaservices

Please check the PMB

$250 USD in 10 days
(0 Reviews)
1.0