php code for inventory system in updating item quantity

cotton · 03-11-2007, 09:09 PM

recently,im developing an inventory system. the problem is i still dont know how to automatically update the quantity in the stock after the user take the items and how to add the item to the cart as in a shopping cart system. pls help..im using easyphp and i do not use class and function in my system.help me pls...

this is the sample of my code:
<table width="80%" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td width="18%" bgcolor="#E0E2EB"><div align="left">Description : </div></td>
<td width="82%"><? echo $row['description']; ?></td>
</tr>
<tr>
<td bgcolor="#E0E2EB"><div align="left">Item Code : </div></td>
<td><? echo $row['item_code']; ?></td>
</tr>
<tr>
<td bgcolor="#E0E2EB"><div align="left">Category : </div></td>
<td><? echo $row['category']; ?></td>
</tr>
<tr>
<td bgcolor="#E0E2EB"><div align="left">Current quantity : </div></td>
<td><? echo $row['quantity']; ?></td>
????: NamePros.com http://www.namepros.com/code/303871-php-code-inventory-system-updating-item.html
</tr>
<tr>

<td bgcolor="#E0E2EB">Required quantity : </td>
<td><input type="text" name="quantity" value="<? echo $row['quantity']; ?>">
<input type="hidden" name="id" value="<? echo $row['quantity']; ?>"></td>

</tr>

</table>

thnx in advance..

i stored the cart in the database..

Anyone..help me pls..i need the code so badly.

AzN · 03-11-2007, 09:34 PM

You can add upon checkout.
Here's just a sample of what you want to use...

Code:

$item = $_GET['item']

$result = mysql_query("SELECT * FROM inventory
 WHERE item='$item'") or die(mysql_error());  

$row = mysql_fetch_array( $result );

$count = $row['count'] - 1;

$result = mysql_query("UPDATE inventory SET count='$count' WHERE item='$item'") 
or die(mysql_error());

cotton · 03-12-2007, 01:59 AM

thank u very much!! i will try that on..

cotton · 03-12-2007, 08:54 PM

how to show the item in the cart?

cef · 03-13-2007, 11:45 PM

Ack! Never trust user input (e.g., $_POST and $_GET variables). The above code is open to a sql injection.

Replace

PHP Code:

  $item = $_GET['item'];

with

PHP Code:

  $item = mysql_real_escape_string($_GET['item']);

Also, you might want to check if the item actually exists, and if you have any in stock:

PHP Code:

  $row = mysql_fetch_array( $result );

 
if ($row === false)

{

        echo 'this item does not exist!';

        return; // or whatever you need to do

}

else

{

        if ($row['count']  == 0)

        {

             echo 'sorry, none in stock.';

             return; // or whatever you need to do

        }

 
        // if you got here you have stock on hand, so continue

????: NamePros.com http://www.namepros.com/showthread.php?t=303871
        $count = $row['count'] - 1;

        // etc...

}

Just a rough draft, but you get the idea.

03-11-2007, 09:09 PM	THREAD STARTER #1 (permalink)
cotton New Member Join Date: Jan 2007 Posts: 17	php code for inventory system in updating item quantity recently,im developing an inventory system. the problem is i still dont know how to automatically update the quantity in the stock after the user take the items and how to add the item to the cart as in a shopping cart system. pls help..im using easyphp and i do not use class and function in my system.help me pls... this is the sample of my code: <table width="80%" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#CCCCCC"> <tr> <td width="18%" bgcolor="#E0E2EB"><div align="left">Description : </div></td> <td width="82%"><? echo $row['description']; ?></td> </tr> <tr> <td bgcolor="#E0E2EB"><div align="left">Item Code : </div></td> <td><? echo $row['item_code']; ?></td> </tr> <tr> <td bgcolor="#E0E2EB"><div align="left">Category : </div></td> <td><? echo $row['category']; ?></td> </tr> <tr> <td bgcolor="#E0E2EB"><div align="left">Current quantity : </div></td> <td><? echo $row['quantity']; ?></td> ????: NamePros.com http://www.namepros.com/code/303871-php-code-inventory-system-updating-item.html </tr> <tr> <td bgcolor="#E0E2EB">Required quantity : </td> <td><input type="text" name="quantity" value="<? echo $row['quantity']; ?>"> <input type="hidden" name="id" value="<? echo $row['quantity']; ?>"></td> </tr> </table> thnx in advance.. i stored the cart in the database.. Anyone..help me pls..i need the code so badly.

03-13-2007, 11:45 PM	#5 (permalink)
cef NamePros Regular Join Date: May 2004 Location: NYC Posts: 236	Ack! Never trust user input (e.g., $_POST and $_GET variables). The above code is open to a sql injection. Replace PHP Code: `$item = $_GET['item'];` with PHP Code: `$item = mysql_real_escape_string($_GET['item']);` Also, you might want to check if the item actually exists, and if you have any in stock: PHP Code: $row = mysql_fetch_array( $result ); if ($row === false) { echo 'this item does not exist!'; return; // or whatever you need to do } else { if ($row['count'] == 0) { echo 'sorry, none in stock.'; return; // or whatever you need to do } // if you got here you have stock on hand, so continue ????: NamePros.com http://www.namepros.com/showthread.php?t=303871 $count = $row['count'] - 1; // etc... } Just a rough draft, but you get the idea.

03-12-2007, 01:59 AM	THREAD STARTER #3 (permalink)
cotton New Member Join Date: Jan 2007 Posts: 17	thank u very much!! i will try that on..

03-12-2007, 08:54 PM	THREAD STARTER #4 (permalink)
cotton New Member Join Date: Jan 2007 Posts: 17	how to show the item in the cart?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)