Update quantity format for simple shopping cart.

masalastican · August 10, 2007

I have a shopping cart that I'm using in my website and it uses a drop down menu to select the quantity. For what I'm doing this will not work and I need this cart to update quantities by means of a text box. My code looks like this:

<?php

include("db.php");

switch($_GET["action"])

{

case "add_item":

{

AddItem($_GET["id"], $_GET["qty"]);

ShowCart();

break;

}

case "update_item":

{

UpdateItem($_GET["id"], $_GET["qty"]);

ShowCart();

break;

}

case "remove_item":

{

RemoveItem($_GET["id"]);

ShowCart();

break;

}

default:

{

ShowCart();

}

function AddItem($itemId, $qty)

{

// Will check whether or not this item

// already exists in the cart table.

// If it does, the UpdateItem function

// will be called instead

global $dbServer, $dbUser, $dbPass, $dbName;

// Get a connection to the database

$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);

// Check if this item already exists in the users cart table

$result = mysql_query("select count(*) from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");

$row = mysql_fetch_row($result);

$numRows = $row[0];

if($numRows == 0)

{

// This item doesn't exist in the users cart,

// we will add it with an insert query

@mysql_query("insert into cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");

}

else

{

// This item already exists in the users cart,

// we will update it instead

UpdateItem($itemId, $qty);

}

function UpdateItem($itemId, $qty)

{

// Updates the quantity of an item in the users cart.

// If the quantity is zero, then RemoveItem will be

// called instead

global $dbServer, $dbUser, $dbPass, $dbName;

// Get a connection to the database

$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);

if($qty == 0)

{

// Remove the item from the users cart

RemoveItem($itemId);

}

else

{

mysql_query("update cart set qty = $qty where cookieId = '" . GetCartId() . "' and itemId = $itemId");

}

function RemoveItem($itemId)

{

// Uses an SQL delete statement to remove an item from

// the users cart

global $dbServer, $dbUser, $dbPass, $dbName;

// Get a connection to the database

$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);

mysql_query("delete from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");

}

function ShowCart()

{

// Gets each item from the cart table and display them in

// a tabulated format, as well as a final total for the cart

global $dbServer, $dbUser, $dbPass, $dbName;

// Get a connection to the database

$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);

$totalCost = 0;

$result = mysql_query("select * from cart inner join inventory on cart.itemId = inventory.itemId where cart.cookieId = '" . GetCartId() . "' order by inventory.itemDesc asc");

?>

<html>

<head>

<title> Your Shopping Cart </title>

function UpdateQty(item)

{

itemId = item.name;

newQty = item.options[item.selectedIndex].text;

document.location.href = 'cart.php?action=update_item&id='+itemId+'&qty='+newQty;

}

</script>

</head>

<h1>Your Shopping Cart</h1>

<tr>

</font>

</td>

<font face="engravers MT" size="1"

color="black">

</font>

</td>

<font face="engravers MT" size="1"

color="black">

<b>Description</b>

</font>

</td>

<font face="engravers MT" size="1"

color="black">

<b>Price Each</b>

</font>

</td>

</font>

</td>

</tr>

<?php

while($row = mysql_fetch_array($result))

{

// Increment the total cost of all items

$totalCost += ($row["qty"] * $row["itemPrice"]);

?>

<tr>

<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">

<?php

for($i = 0; $i <= 500; $i++)

{

echo "<option ";

if($row["qty"] == $i)

{

echo " SELECTED ";

}

echo ">" . $i . "</option>";

}

?>

</select>

</font>

</td>

<?php echo $row["itemSKU"]; ?>

</font>

</td>

<?php echo $row["itemDesc"]; ?>

</font>

</td>

$<?php echo number_format($row["itemPrice"], 2, ".", ","); ?>

</font>

</td>

<b><center><a href="cart.php?action==update_item&id='+itemId+'&qty='+newQty;?>">Update Cart</a><center><b>

</font>

</td>

</tr>

<?php

}

// Display the total

?>

<tr>

</td>

</tr>

<tr>

</font>

</td>

<b>Total: $<?php echo number_format($totalCost, 2, ".", ","); ?></b>

</font>

</td>

</tr>

</table>

</form>

<br>

<font face="verdana" size="1"

color="black">

<center>If your cart does not contain all of your items please click the refresh button at the top of the browser window.</center>

</font>

</body>

</html>

<?php

}

?>

[code=php:0]

If anyone can help I'd greatly appreciate it!

teng84 · August 10, 2007

it not right to display all your code just choose the line which you think has a problem

one more i always see people doing this

@@@@@@@ I dont know whats on their mind doing something like that why dont they cure real problem instead of doing that crazy stuff

masalastican · August 11, 2007

I posted the whole code because I'm not sure what in this code needs to be referenced etc. by a text box in order for the text box to be able to submit information... I'm pretty clueless on this whole thing. I'm sorry for all the code but I wanted to be thorough...

masalastican · August 13, 2007

I still need help on this!

Sign In

Update quantity format for simple shopping cart.

Recommended Posts

masalastican

Link to comment

Share on other sites

teng84

Link to comment

Share on other sites

masalastican

Link to comment

Share on other sites

masalastican

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information