HEEEELP! Order and inventory system

[essiebeee]

Patulong po please! Yung sa ordering system po na magbabawas sa inventory kapag may nagorder adon sa product.

Eto po sa tables.

productTbl
-id
-productName
-prodDesc
-prodPic
-prodPrice

InvenTbl
-id
-productName
-qtyLeft
-qtySold
-sales

salesTbl
-id
-productId
-qty
-date
-sales

PaHelp po! Di ko po alam kung pano magbabawas yung inorder don sa quantity eh.
PHP po. Salamat po!

 

[JackFrost10]

gwa ka ng order form.
ito ung code. palitan mo lng ung mga variable names.

$inventory_ID = $_POST[inventory_ID];
$qty = $_POST['qty'];

$sql = "SELECT * FROM InvenTbl WHERE id = '$inventory_ID'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0){
$row = mysql_fetch_assoc($result);

$qty_left = $row['qtyleft'];
$new_qty = $qty_left - $qty;

$sql = "UPDATE InvenTbl qtyleft = '$new_qty' WHERE id = '$inventory_ID'";
if(mysql_query($sql)){
echo "Record Updated";
}else{
echo "ERROR".mysql_error();
}

}else{
echo "No such ID recorded";
}

 

[essiebeee]

gwa ka ng order form.
ito ung code. palitan mo lng ung mga variable names.

$inventory_ID = $_POST[inventory_ID];
$qty = $_POST['qty'];

$sql = "SELECT * FROM InvenTbl WHERE id = '$inventory_ID'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0){
$row = mysql_fetch_assoc($result);

$qty_left = $row['qtyleft'];
$new_qty = $qty_left - $qty;

$sql = "UPDATE InvenTbl qtyleft = '$new_qty' WHERE id = '$inventory_ID'";
if(mysql_query($sql)){
echo "Record Updated";
}else{
echo "ERROR".mysql_error();
}

}else{
echo "No such ID recorded";
}

Don na po sa mismong order page ilalagay yang code na yan?

 

[JackFrost10]

d sa isang page yan, lagay mo sa action parameter ng form ang link ng page, at dun mo lagay ung code.
http://www.w3schools.com/ <-- refer ka d2 sa PHP.

 

[eugcar]

gawa ka po muna ng form then sundin mo po yung code na ginawa po ni sir jack!

$sql = "SELECT * FROM InvenTbl WHERE id = '$inventory_ID'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0){
$row = mysql_fetch_assoc($result);

$qty_left = $row['qtyleft'];
$new_qty = $qty_left - $qty;

example:
$qty_left (100) - $qty (10)
bali ang magiging total ng $new_qty (90)

$sql = "UPDATE InvenTbl qtyleft = '$new_qty' WHERE id = '$inventory_ID'"; <- then query para sa update at maisave yung new quantity mo po sa InvenTbl .

 

[femur43766]

Sino ba ang programmer dyan within legazpi city area na may ready nang inventory system....

 

[kapitan_pinoy]

maraming order and inventory system dito http://freephpsystems.com/?s=order&x=0&y=0