SALES SELECTION:
Enter product name:
Enter quantity:
STOCK SECTION
PRODUCT NAME:
STOCK
TOOTHBRUSH
56
DEO
34
SOAP
67
APP PRODUCTS IN STOCK:
Enter product name:
Enter quantity:
Create 4 pages as sales.php,stock.php,purchase.php and home.php
sales.php
It has 3 form elements to Enter product name,quantity and a submit button sale.
On cliking sale the stock should be updated in the database(i.e deucted and the new value should be updated).
The form elements should be posted in the same page with post method.
stock.php
it displays the stock available in the database in the form of a table.
purchase.php
It has 3 form elements to Enter the product name,quantity and a submit button ADD.
On clicking add, if the product exists it will update by adding new stock.
If doesnt exist,it will add a new record in the database table for that product.(Should be posted in the same page by post method)
home.php
It has links to purchase stock and add stock section
All pages should have back link to home.php
Create the database name stock_manage and table as stocks