Simple PHP, MySQL Inventory Database coding help needed. Thanks so much!

[Yashua]

I wish to create an inventory database with the following:

1. When an item is checkmarked and the submit button is pressed that item is deducted from the mySQL Inventory portion.

By default only 1 is deducted per item, but if they add to the Quantity they wish to order then the amount listed in the "quantity" would be deducted from mySQL.

 

2. I would love to have a link for the admin to be able to add to the stock.

3. I wish to have this form dynamically show how much there is in stock.

4. I wish to have an ALERT email sent to my email when the stock reaches the minimum default of 2 or less per item and that default can be changed for all items in the form.

 

Example:

When an item is checkmarked it will be ordered and deducted from stock.

If the item is NOT checkmarked, obviously nothing will be ordered and nothing will be deducted.

 

PHP and MySQL Inventory Database Request Example:

______________________________________________________________________________________________________

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

client Function in the Form:\\\\\\\\\\\\\\\\\\Admin Function in the Form:

___________________________________________________________________________________________

Chicken_ [ x] Quantity [ 1 ] In Stock: [ 5 ]___ Admin Add to Stock___ Alert via email when [ 2] or less.

 

Milk____ [  ] Quantity [ 1 ] In Stock: [ 5 ]___ Admin Add to Stock___ Alert via email when [ 2] or less.

 

Orange__ [  ] Quantity [ 1 ] In Stock: [ 5 ]___ Admin Add to Stock___ Alert via email when [ 2] or less.

 

Apple___ [ x] Quantity [ 1 ] In Stock: [ 5 ]___ Admin Add to Stock___ Alert via email when [ 2] or less.

______________________________________________________________________________________________________

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\Click to Add Additional Inventory Items to Database Individually.

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\click to Upload to MySQL from CSV (comma separated files).

______________________________________________________________________________________________________

 

[sUBMIT] (updates inventory dynamically and sends an email)

 

______________________________________________________________________________________________________

Is there a quick way of doing this from some of the code that's already here?

I would really appreciate your help. Thanks a million.

 

[MasterACE14]

This board is really only for help with script problems, and errors. If you want help with a project like this, either work out how your going to do it on paper, and then start coding it yourself. Or see if someone else will be willing to do it for you in this section of the forum: http://www.phpfreaks.com/forums/index.php/board,8.0.html

 

I highly reccommend going to www.hotscripts.com first as they have many PHP scripts their of all kind. 

 

Regards ACE