Removing Items from a shopping cart

[mtgriffiths86]

Hi All,

I am trying to remove all items from my shopping cart but am having problems.

I can remove individual items by using clicking a link which runs this piece of code:

<a href="ShoppingCart.php?action=remove_item&id=<?php echo $row["car_id"]; ?>">Remove</a>
 

My problem is that i want to include a link that when clicked will clear all items and not just specific ones that are chosen by the car_id

remove item code is below:

case "remove_item":
{
    RemoveItem($_GET["id"]);
    ShowCart();
    break;
}
 

Can anyone help

Thanks in advance

Matthew

[Atli]

Hi Matthew.

The easiest way would probably be to get a list of all items in the chart and run them all through your RemoveItem function.
Depending on what that function does exactly, this may not be the most efficient way tho.

If you tell us how the items in the chart are stored we may be able to give a more specific answer.

[mtgriffiths86]

Thank you for your response

I think that the code that you are looking for is this:

[PHP]@mysql_query("i nsert into cart(cookieId, car_id, qty) values('" . GetCartId() . "', $car_id, $qty)");[/PHP]

hope this helps you to help me lol

Thanks again

[Markus]

Could you also show what the 'removeFunction ' is doing, aswell, please?

[mtgriffiths86]

I hope this is correct and what you wanted.

[PHP] // Remove the item from the users cart
RemoveItem($car _id);
}
else
{
mysql_query("up date cart set qty = $qty where cookieId = '" . GetCartId() . "' and car_id = $car_id");
}
}

function RemoveItem($car _id)
{
// 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($d bServer, $dbUser, $dbPass, $dbName);

mysql_query("de lete from cart where cookieId = '" . GetCartId() . "' and car_id = $car_id");
[/PHP]

Thank you

Matthew

[Atli]

Based on that code, you could probably make a function to delete all cart items at once.

It would only require minor changes to the code you posted.
Something like:

function RemoveAllItems()
{
    // Uses an SQL delete statement to remove ALL items 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());
}
 

Before you test this!
Keep in mind that I do not really know the program you are using so this may not be exactly what you need.
Make sure to test this on data you won't miss if something goes wrong and it all gets messed up! :)

[mtgriffiths86]

Thanks for the post.

I have tried creating a new function as stated but have no joy.

This maybe pointless but i am going to include all of the code that i am using. Maybe that would help.

[PHP]

<?php

include("db.php ");

switch($_GET["action"])
{
case "add_item":
{
AddItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "update_ite m":
{
UpdateItem($_GE T["id"], $_GET["qty"]);
ShowCart();
break;
}
case "remove_ite m":
{
RemoveItem($_GE T["id"]);
ShowCart();
break;
}

case "remove_all_ite ms":
{
RemoveAllItems( );
ShowCart();
break;
}

default:
{
ShowCart();
}

}


function RemoveAllItems( )

{
// Uses an SQL delete statement to remove ALL items from

// the users cart
global $dbServer, $dbUser, $dbPass, $dbName;
// Get a connection to the database

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

mysql_query("DE LETE FROM cart WHERE cookieId = '" . GetCartId());

}

function AddItem($car_id , $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($d bServer, $dbUser, $dbPass, $dbName);

// Check if this item already exists in the users cart table
$result = mysql_query("se lect count(*) from cart where cookieId = '" . GetCartId() . "' and car_id = $car_id");
$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("i nsert into cart(cookieId, car_id, qty) values('" . GetCartId() . "', $car_id, $qty)");
}
else
{
// This item already exists in the users cart,
// we will update it instead

UpdateItem($car _id, $qty);
}
}

function UpdateItem($car _id, $qty)
{
// Updates the quantity of an item in the users cart.
// If the qutnaity is zero, then RemoveItem will be
// called instead

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

// Get a connection to the database
$cxn = @ConnectToDb($d bServer, $dbUser, $dbPass, $dbName);

if($qty == 0)
{
// Remove the item from the users cart
RemoveItem($car _id);
}
else
{
mysql_query("up date cart set qty = $qty where cookieId = '" . GetCartId() . "' and car_id = $car_id");
}
}

function RemoveItem($car _id)
{
// 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($d bServer, $dbUser, $dbPass, $dbName);

mysql_query("de lete from cart where cookieId = '" . GetCartId() . "' and car_id = $car_id");
}

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($d bServer, $dbUser, $dbPass, $dbName);

$totalCost = 0;
$result = mysql_query("se lect * from cart inner join car_details on cart.car_id = car_details.car _id where cart.cookieId = '" . GetCartId() . "' order by car_details.Mod el asc");
$sql_num_rows = mysql_num_rows( $result);

?>
<td height="68"><p align="center" class="style1"> <font size="+3"><img src="Banner.jpg "></font></p> </td>
</tr>
<tr BGCOLOR="#0099F F">
<td><div align="center" class="style1">
<a href="Home.php" >Home</a> ----
<a href="Main.php" >Car Search</a>----
<a href="ShoppingC art.php">Shoppi ng Cart</a>
<span class="style4"> ---- </span>Contact</span></div></td>
</tr>
<tr bordercolor="#0 099FF">
<td><p align="center"> <script language="JavaS cript">

function UpdateQty(item)
{
itemId = item.name;
newQty = item.options[item.selectedIn dex].text;

document.locati on.href = 'ShoppingCart.p hp?action=updat e_item&id='+ite mId+'&qty='+new Qty;
}

</script>
<body bgcolor="#fffff f"><form method="get" name="frmCart" class="style2">
<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td width="16%" height="25" bgcolor="#0099F F"><font size="2" color="white"> &nbsp;&nbsp;<b> Qty</b> </font> </td>
<td width="21%" height="25" bgcolor="#0099F F"><font size="2" color="white"> <b>Manufacturer </b> </font> </td>
<td width="16%" height="25" bgcolor="#0099F F"><font size="2" color="white"> <b>Model</b> </font> </td>
<td width="16%" height="25" bgcolor="#0099F F"><font size="2" color="white"> <b>Colour</b> </font> </td>
<td width="18%" height="25" bgcolor="#0099F F"><font size="2" color="white"> <b>Price</b> </font> </td>
<td width="13%" height="25" bgcolor="#0099F F"><font size="2" color="white"> <b>Remove?</b> </font> </td>
</tr>
<?php

while($row = mysql_fetch_arr ay($result))
{
// Increment the total cost of all items
$totalCost += ($row["qty"] * $row["Price"]);
?>
<tr>
<td width="16%" height="25"><fo nt size="2" color="black">
<select name="<?php echo $row["car_id"]; ?>" onChange="Updat eQty(this)">
<?php

for($i = 1; $i <= 5; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}


$qty += $row["qty"]

?>
</select>
</font> </td>
<td width="21%" height="25"><fo nt size="2" color="black"> <?php echo $row["Manufactur er"]; ?> </font> </td>
<td width="16%" height="25"><fo nt size="2" color="black"> <?php echo $row["Model"]; ?></font> </td>
<td width="16%" height="25"><fo nt size="2" color="black"> <?php echo $row["Colour"]; ?></font> </td>
<td width="18%" height="25"><fo nt size="2" color="black"> £<?php echo number_format($ row["Price"], 2, ".", ","); ?> </font> </td>
<td width="13%" height="25"><fo nt size="2" color="black"> <a href="ShoppingC art.php?action= remove_item&id= <?php echo $row["car_id"]; ?>">Remove</a></font> </td>

<?php
}

// Display the total
?>
<tr>
<td colspan="6"><hr size="1" color="#0099FF" noshade> </td>
</tr>
<tr>
<td colspan="2"><fo nt size="2" color="black"> <a href="main.php" >&lt;&lt; Continue Searching</a></font></td>
<td width="16%" colspan="1"><di v align="center"> </div></td>
<td>&nbsp;</td>
<td><font size="2" color="black">< b> Total Cars: <?php echo "$sql_num_r ows" ?></b></font></td>
<td><font size="2" color="black">

<a href="ShoppingC art.php?action= remove_all_item s&id=&gt;1">Emp ty Cart</a></font></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><font size="2" color="black">< b> Total Quantity: <?php echo "$qty" ?></b></font></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><font size="2" color="black">< b>Total: &pound;<?php echo number_format($ totalCost, 2, ".", ","); ?></b></font></td>
</tr>
</table>
</form>
</body>
</html>
<?php
}

?>
[/PHP]

Thanks again

[Atli]

Are you getting any errors when you try the RemoveAllItems function?

I just noticed a small typo in the Query:

mysql_query("DELETE  FROM cart WHERE cookieId = '" . GetCartId());
 

It's missing the closing ' quote after the cart id.

Should be:

mysql_query("DELETE  FROM cart WHERE cookieId = '" . GetCartId() ."'");
 

[Atli]

Also, want to add a small suggestion...

You use the global keyword to import the database variables into your functions scope.

You could declare them as constants instead so you wouldn't have to import them into every function.

For example, this code uses global as you do:

$var = "Hello";
 
function PrintVar() {
  global $var;
  echo $var;
}
 

This prints "Hello" when the function is called.

This may be easier if you plan on using the variable in many functions:

define("VAR", "Hello");
 
function PrintVar() {
  echo VAR;
}
 

You will do exactly the same thing as the first code, but without having to import the variables into the function scope.