Updating shopping cart quantities? Please help.

dmolanphy

Hello all!

Kinda new to PHP and I'm stuck on a small problem. I am trying to creat a shopping cart, and so far everything is working, except for updating multiple quantities at one time. For example...you add 4 different items to the shopping cart, but you decide you want to change the quantities! Well, I have added an INPUT field to update each of these quantities, but I want all the quantities to be updated when you click on a small UPDATE CART button at the bottom of the entire cart.

Here is the code to VIEW the things on the cart:

<?php
	@$num = mysql_num_rows($result);
	$total = 0.00;
	if ($num > 0)
	{
 		while ($row = mysql_fetch_array($result))
		{
			extract ($row);
			$total = $total + ($cartQty * $productPrice);			
			echo "
			<TR>\n
			<TD HEIGHT='20' BGCOLOR='#FFFFFF'><INPUT TYPE='Text' SIZE='3' VALUE='$cartQty' NAME='newCartQty'></TD>\n
			<TD HEIGHT='20' BGCOLOR='#FFFFFF'><FONT CLASS='bodyCopy'>&nbsp;$productCode</FONT></TD>\n
			<TD HEIGHT='20' BGCOLOR='#FFFFFF'><FONT CLASS='bodyCopy'>&nbsp;$productName</FONT></TD>\n
			<TD HEIGHT='20' BGCOLOR='#FFFFFF' ALIGN='Right'><FONT CLASS='bodyCopyIndentR'>$productPrice</FONT></TD>\n
			</TR>";
		}
	}

?>

When you click submit on this form, this page passes the variables with GET to a script called updateCart.php. This is the script I have no clue how to code.

The above code pulls all its information from a MySQL table that looks like this:

cartID (primary Key) <----random cookie number
productID (primary Key) <----unique id for each product
cartQty <--- current quantity
dateAdded <--- the date the product was added to the cart

ANY help will be greatly appreciated!!!

Thank you,

dalecosp

I'm a firm believer in doing carts in the $SESSION space, not the database. Then, in your case, your 'update' script is simply

$_SESSION['cartQty']=$_GET['cartQty'];

HTH,

dmolanphy

dalecosp:

Thanks for your reply. I am not very familiar with sessions, but I do start a session when a user logs in. When they add something to the cart, I also set a cookie (by the way, the only reason why I got this far is because many people have helped me with this), so...I'm not quite sure how to make your suggestion apply to my cart? I apologize for my ignorance, but I have been self-taught in the ways of PHP and programming altogether, so this is all still very new to me.

Thanks.

kevinsequeira

this may not be related but you might want to take a look at this link http://www.phpshop.org/

reg
kevin

dmolanphy

Kevin:

Thank you! I have tried messing with these kinds of scripts before and they work well. But I was hoping to learn how to do it myself, so i could understand how these scripts work a little better.

I am working on a "test" project, in which I am trying to cover all my bases and learn PHP that way. (Kind of a hands-on thing). But I certainly appreciate your help with the link. I have added it to my bookmarks for any future sites that I may have to do.