Jump to content

update cart

AoNo

By AoNo
in PHP Coding Help

 Share

Recommended Posts

AoNo Newbie

AoNo

Posted
Posted

everything seems to b working correctly...except 'update cart'

where if i click on update cart button it redirects me to d previous page...instead of calculating the input..

i m not able 2 figure out what d problem is..

 

 

here's d cart.php:

 

 

<?php

require_once 'library/config.php';

require_once 'library/cart-functions.php';

 

$action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : 'view';

 

switch ($action) {

case 'add' :

addToCart();

break;

case 'update' :

updateCart();

break;

case 'delete' :

deleteFromCart();

break;

case 'view' :

}

 

$cartContent = getCartContent();

$numItem = count($cartContent);

 

$pageTitle = 'Shopping Cart';

require_once 'include/header.php';

 

// show the error message ( if we have any )

displayError();

 

if ($numItem > 0 ) {

?>

<form action="<?php echo $_SERVER['PHP_SELF'] .'?action=update'; ?>" method="POST" name="frmCart" id="frmCart">

<table width="780" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">

<tr class="entryTableHeader">

<td colspan="2" align="center">Item</td>

<td align="center">Unit Price</td>

<td width="75" align="center">Quantity</td>

<td align="center">Total</td>

<td width="75" align="center"> </td>

</tr>

<?php

$subTotal = 0;

for ($i = 0; $i < $numItem; $i++) {

extract($cartContent[$i]);

$productUrl = "index.php?c=$cat_id&p=$pd_id";

$subTotal += $pd_price * $ct_qty;

?>

<tr class="content">

<td width="80" align="center"><a href="<?php echo $productUrl; ?>"><img src="<?php echo $pd_thumbnail; ?>" border="0"></a></td>

<td><a href="<?php echo $productUrl; ?>"><?php echo $pd_name; ?></a></td>

<td align="right"><?php echo displayAmount($pd_price); ?></td>

<td width="75"><input name="txtQty[]" type="text" id="txtQty[]" size="5" value="<?php echo $ct_qty; ?>" class="box" onKeyUp="checkNumber(this);">

<input name="hidCartId[]" type="hidden" value="<?php echo $ct_id; ?>">

<input name="hidProductId[]" type="hidden" value="<?php echo $pd_id; ?>">

</td>

<td align="right"><?php echo displayAmount($pd_price * $ct_qty); ?></td>

<td width="75" align="center"> <input name="btnDelete" type="button" id="btnDelete" value="Delete" onClick="window.location.href='<?php echo $_SERVER['PHP_SELF'] . "?action=delete&cid=$ct_id"; ?>';" class="box">

</td>

</tr>

<?php

}

?>

<tr class="content">

<td colspan="4" align="right">Sub-total</td>

<td align="right"><?php echo displayAmount($subTotal); ?></td>

<td width="75" align="center"> </td>

</tr>

<tr class="content">

<td colspan="4" align="right">Shipping </td>

<td align="right"><?php echo displayAmount($shopConfig['shippingCost']); ?></td>

<td width="75" align="center"> </td>

</tr>

<tr class="content">

<td colspan="4" align="right">Total </td>

<td align="right"><?php echo displayAmount($subTotal + $shopConfig['shippingCost']); ?></td>

<td width="75" align="center"> </td>

</tr>

<tr class="content">

<td colspan="5" align="right"> </td>

<td width="75" align="center">

<input name="btnUpdate" type="submit" id="btnUpdate" value="Update Cart" class="box"></td>

</tr>

</table>

</form>

<?php

} else {

 

?>

<p> </p><table width="550" border="0" align="center" cellpadding="10" cellspacing="0">

<tr>

<td><p align="center">You shopping cart is empty</p>

<p>If you find you are unable to add anything to your cart, please ensure that

your internet browser has cookies enabled and that any other security software

is not blocking your shopping session.</p></td>

</tr>

</table>

<?php

}

 

$shoppingReturnUrl = isset($_SESSION['shop_return_url']) ? $_SESSION['shop_return_url'] : 'index.php';

?>

<table width="550" border="0" align="center" cellpadding="10" cellspacing="0">

<tr align="center">

<td><input name="btnContinue" type="button" id="btnContinue" value="<< Continue Shopping" onClick="window.location.href='<?php echo $shoppingReturnUrl; ?>';" class="box"></td>

<?php

if ($numItem > 0) {

?>

<td><input name="btnCheckout" type="button" id="btnCheckout" value="Proceed To Checkout >>" onClick="window.location.href='checkout.php?step=1';" class="box"></td>

<?php

}

?>

</tr>

</table>

<?php

require_once 'include/footer.php';

?>

 

 

and here is update cart function:

 

 

function updateCart()

{

$cartId = $_POST['hidCartId'];

$productId = $_POST['hidProductId'];

$itemQty = $_POST['txtQty'];

$numItem = count($itemQty);

$numDeleted = 0;

$notice = '';

 

for ($i = 0; $i < $numItem; $i++) {

$newQty = (int)$itemQty[$i];

if ($newQty < 1) {

// remove this item from shopping cart

deleteFromCart($cartId[$i]);

$numDeleted += 1;

} else {

// check current stock

$sql = "SELECT pd_name, pd_qty

FROM tbl_product

WHERE pd_id = {$productId[$i]}";

$result = dbQuery($sql);

$row = dbFetchAssoc($result);

 

if ($newQty > $row['pd_qty']) {

// we only have this much in stock

$newQty = $row['pd_qty'];

 

// if the customer put more than

// we have in stock, give a notice

if ($row['pd_qty'] > 0) {

setError('The quantity you have requested is more than we currently have in stock. The number available is indicated in the "Quantity" box. ');

} else {

// the product is no longer in stock

setError('Sorry, but the product you want (' . $row['pd_name'] . ') is no longer in stock');

 

// remove this item from shopping cart

deleteFromCart($cartId[$i]);

$numDeleted += 1;

}

}

 

// update product quantity

$sql = "UPDATE tbl_cart

SET ct_qty = $newQty

WHERE ct_id = {$cartId[$i]}";

 

dbQuery($sql);

}

}

 

 

if ($numDeleted == $numItem) {

// if all item deleted return to the last page that

// the customer visited before going to shopping cart

header("Location: $returnUrl" . $_SESSION['shop_return_url']);

} else {

header('Location: cart.php');

}

 

 

exit;

}

 

Link to comment
https://forums.phpfreaks.com/topic/256364-update-cart/
Share on other sites
AoNo Newbie

AoNo

Posted
  • Author
Posted

[pre]everything seems to b working correctly...except 'update cart'

where if i click on update cart button it redirects me to d previous page...instead of calculating the input..

i m not able 2 figure out what d problem is..

 

 

here's d cart.php:

 


<?php
require_once 'library/config.php';
require_once 'library/cart-functions.php';

$action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : 'view';

switch ($action) {
case 'add' :
addToCart();
break;
case 'update' :
updateCart();
break;
case 'delete' :
deleteFromCart();
break;
case 'view' :
}

$cartContent = getCartContent();
$numItem = count($cartContent);

$pageTitle = 'Shopping Cart';
require_once 'include/header.php';

// show the error message ( if we have any )
displayError();

if ($numItem > 0 ) {
?>
<form action="<?php echo $_SERVER['PHP_SELF'] .'?action=update'; ?>" method="POST" name="frmCart" id="frmCart">
<table width="780" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
<tr class="entryTableHeader">
<td colspan="2" align="center">Item</td>
<td align="center">Unit Price</td>
<td width="75" align="center">Quantity</td>
<td align="center">Total</td>
<td width="75" align="center"> </td>
</tr>
<?php
$subTotal = 0;
for ($i = 0; $i < $numItem; $i++) {
extract($cartContent[$i]);
$productUrl = "index.php?c=$cat_id&p=$pd_id";
$subTotal += $pd_price * $ct_qty;
?>
<tr class="content">
<td width="80" align="center"><a href="<?php echo $productUrl; ?>"><img src="<?php echo $pd_thumbnail; ?>" border="0"></a></td>
<td><a href="<?php echo $productUrl; ?>"><?php echo $pd_name; ?></a></td>
<td align="right"><?php echo displayAmount($pd_price); ?></td>
<td width="75"><input name="txtQty[]" type="text" id="txtQty[]" size="5" value="<?php echo $ct_qty; ?>" class="box" onKeyUp="checkNumber(this);">
<input name="hidCartId[]" type="hidden" value="<?php echo $ct_id; ?>">
<input name="hidProductId[]" type="hidden" value="<?php echo $pd_id; ?>">
</td>
<td align="right"><?php echo displayAmount($pd_price * $ct_qty); ?></td>
<td width="75" align="center"> <input name="btnDelete" type="button" id="btnDelete" value="Delete" onClick="window.location.href='<?php echo $_SERVER['PHP_SELF'] . "?action=delete&cid=$ct_id"; ?>';" class="box">
</td>
</tr>
<?php
}
?>
<tr class="content">
<td colspan="4" align="right">Sub-total</td>
<td align="right"><?php echo displayAmount($subTotal); ?></td>
<td width="75" align="center"> </td>
</tr>
<tr class="content">
<td colspan="4" align="right">Shipping </td>
<td align="right"><?php echo displayAmount($shopConfig['shippingCost']); ?></td>
<td width="75" align="center"> </td>
</tr>
<tr class="content">
<td colspan="4" align="right">Total </td>
<td align="right"><?php echo displayAmount($subTotal + $shopConfig['shippingCost']); ?></td>
<td width="75" align="center"> </td>
</tr>
<tr class="content">
<td colspan="5" align="right"> </td>
<td width="75" align="center">
<input name="btnUpdate" type="submit" id="btnUpdate" value="Update Cart" class="box"></td>
</tr>
</table>
</form>
<?php
} else {

?>
<p> </p><table width="550" border="0" align="center" cellpadding="10" cellspacing="0">
<tr>
<td><p align="center">You shopping cart is empty</p>
<p>If you find you are unable to add anything to your cart, please ensure that
your internet browser has cookies enabled and that any other security software
is not blocking your shopping session.</p></td>
</tr>
</table>
<?php
}

$shoppingReturnUrl = isset($_SESSION['shop_return_url']) ? $_SESSION['shop_return_url'] : 'index.php';
?>
<table width="550" border="0" align="center" cellpadding="10" cellspacing="0">
<tr align="center">
<td><input name="btnContinue" type="button" id="btnContinue" value="<< Continue Shopping" onClick="window.location.href='<?php echo $shoppingReturnUrl; ?>';" class="box"></td>
<?php
if ($numItem > 0) {
?>
<td><input name="btnCheckout" type="button" id="btnCheckout" value="Proceed To Checkout >>" onClick="window.location.href='checkout.php?step=1';" class="box"></td>
<?php
}
?>
</tr>
</table>
<?php
require_once 'include/footer.php';
?>


and here is update cart function:


function updateCart()
{
$cartId = $_POST['hidCartId'];
$productId = $_POST['hidProductId'];
$itemQty = $_POST['txtQty'];
$numItem = count($itemQty);
$numDeleted = 0;
$notice = '';

for ($i = 0; $i < $numItem; $i++) {
$newQty = (int)$itemQty[$i];
if ($newQty < 1) {
// remove this item from shopping cart
deleteFromCart($cartId[$i]);
$numDeleted += 1;
} else {
// check current stock
$sql = "SELECT pd_name, pd_qty
FROM tbl_product
WHERE pd_id = {$productId[$i]}";
$result = dbQuery($sql);
$row = dbFetchAssoc($result);

if ($newQty > $row['pd_qty']) {
// we only have this much in stock
$newQty = $row['pd_qty'];

// if the customer put more than
// we have in stock, give a notice
if ($row['pd_qty'] > 0) {
setError('The quantity you have requested is more than we currently have in stock. The number available is indicated in the "Quantity" box. ');
} else {
// the product is no longer in stock
setError('Sorry, but the product you want (' . $row['pd_name'] . ') is no longer in stock');

// remove this item from shopping cart
deleteFromCart($cartId[$i]);
$numDeleted += 1;
}
}

// update product quantity
$sql = "UPDATE tbl_cart
SET ct_qty = $newQty
WHERE ct_id = {$cartId[$i]}";

dbQuery($sql);
}
}


if ($numDeleted == $numItem) {
// if all item deleted return to the last page that
// the customer visited before going to shopping cart
header("Location: $returnUrl" . $_SESSION['shop_return_url']);
} else {
header('Location: cart.php');
}


exit;
}
[m][/m]

Link to comment
https://forums.phpfreaks.com/topic/256364-update-cart/#findComment-1314386
Share on other sites
AoNo Newbie

AoNo

Posted
  • Author
Posted

 

everything seems to b working correctly...except 'update cart'

where if i click on update cart button it redirects me to d previous page...instead of calculating the input..

i m not able 2 figure out what d problem is..

 

 

here's d cart.php:

 


<?php
require_once 'library/config.php';
require_once 'library/cart-functions.php';

$action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : 'view';

switch ($action) {
case 'add' :
addToCart();
break;
case 'update' :
updateCart();
break;
case 'delete' :
deleteFromCart();
break;
case 'view' :
}

$cartContent = getCartContent();
$numItem = count($cartContent);

$pageTitle = 'Shopping Cart';
require_once 'include/header.php';

// show the error message ( if we have any )
displayError();

if ($numItem > 0 ) {
?>
<form action="<?php echo $_SERVER['PHP_SELF'] .'?action=update'; ?>" method="POST" name="frmCart" id="frmCart">
<table width="780" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
<tr class="entryTableHeader">
<td colspan="2" align="center">Item</td>
<td align="center">Unit Price</td>
<td width="75" align="center">Quantity</td>
<td align="center">Total</td>
<td width="75" align="center"> </td>
</tr>
<?php
$subTotal = 0;
for ($i = 0; $i < $numItem; $i++) {
extract($cartContent[$i]);
$productUrl = "index.php?c=$cat_id&p=$pd_id";
$subTotal += $pd_price * $ct_qty;
?>
<tr class="content">
<td width="80" align="center"><a href="<?php echo $productUrl; ?>"><img src="<?php echo $pd_thumbnail; ?>" border="0"></a></td>
<td><a href="<?php echo $productUrl; ?>"><?php echo $pd_name; ?></a></td>
<td align="right"><?php echo displayAmount($pd_price); ?></td>
<td width="75"><input name="txtQty[]" type="text" id="txtQty[]" size="5" value="<?php echo $ct_qty; ?>" class="box" onKeyUp="checkNumber(this);">
<input name="hidCartId[]" type="hidden" value="<?php echo $ct_id; ?>">
<input name="hidProductId[]" type="hidden" value="<?php echo $pd_id; ?>">
</td>
<td align="right"><?php echo displayAmount($pd_price * $ct_qty); ?></td>
<td width="75" align="center"> <input name="btnDelete" type="button" id="btnDelete" value="Delete" onClick="window.location.href='<?php echo $_SERVER['PHP_SELF'] . "?action=delete&cid=$ct_id"; ?>';" class="box">
</td>
</tr>
<?php
}
?>
<tr class="content">
<td colspan="4" align="right">Sub-total</td>
<td align="right"><?php echo displayAmount($subTotal); ?></td>
<td width="75" align="center"> </td>
</tr>
<tr class="content">
<td colspan="4" align="right">Shipping </td>
<td align="right"><?php echo displayAmount($shopConfig['shippingCost']); ?></td>
<td width="75" align="center"> </td>
</tr>
<tr class="content">
<td colspan="4" align="right">Total </td>
<td align="right"><?php echo displayAmount($subTotal + $shopConfig['shippingCost']); ?></td>
<td width="75" align="center"> </td>
</tr>
<tr class="content">
<td colspan="5" align="right"> </td>
<td width="75" align="center">
<input name="btnUpdate" type="submit" id="btnUpdate" value="Update Cart" class="box"></td>
</tr>
</table>
</form>
<?php
} else {

?>
<p> </p><table width="550" border="0" align="center" cellpadding="10" cellspacing="0">
<tr>
<td><p align="center">You shopping cart is empty</p>
<p>If you find you are unable to add anything to your cart, please ensure that
your internet browser has cookies enabled and that any other security software
is not blocking your shopping session.</p></td>
</tr>
</table>
<?php
}

$shoppingReturnUrl = isset($_SESSION['shop_return_url']) ? $_SESSION['shop_return_url'] : 'index.php';
?>
<table width="550" border="0" align="center" cellpadding="10" cellspacing="0">
<tr align="center">
<td><input name="btnContinue" type="button" id="btnContinue" value="<< Continue Shopping" onClick="window.location.href='<?php echo $shoppingReturnUrl; ?>';" class="box"></td>
<?php
if ($numItem > 0) {
?>
<td><input name="btnCheckout" type="button" id="btnCheckout" value="Proceed To Checkout >>" onClick="window.location.href='checkout.php?step=1';" class="box"></td>
<?php
}
?>
</tr>
</table>
<?php
require_once 'include/footer.php';
?>


and here is update cart function:


function updateCart()
{
$cartId = $_POST['hidCartId'];
$productId = $_POST['hidProductId'];
$itemQty = $_POST['txtQty'];
$numItem = count($itemQty);
$numDeleted = 0;
$notice = '';

for ($i = 0; $i < $numItem; $i++) {
$newQty = (int)$itemQty[$i];
if ($newQty < 1) {
// remove this item from shopping cart
deleteFromCart($cartId[$i]);
$numDeleted += 1;
} else {
// check current stock
$sql = "SELECT pd_name, pd_qty
FROM tbl_product
WHERE pd_id = {$productId[$i]}";
$result = dbQuery($sql);
$row = dbFetchAssoc($result);

if ($newQty > $row['pd_qty']) {
// we only have this much in stock
$newQty = $row['pd_qty'];

// if the customer put more than
// we have in stock, give a notice
if ($row['pd_qty'] > 0) {
setError('The quantity you have requested is more than we currently have in stock. The number available is indicated in the "Quantity" box. ');
} else {
// the product is no longer in stock
setError('Sorry, but the product you want (' . $row['pd_name'] . ') is no longer in stock');

// remove this item from shopping cart
deleteFromCart($cartId[$i]);
$numDeleted += 1;
}
}

// update product quantity
$sql = "UPDATE tbl_cart
SET ct_qty = $newQty
WHERE ct_id = {$cartId[$i]}";

dbQuery($sql);
}
}


if ($numDeleted == $numItem) {
// if all item deleted return to the last page that
// the customer visited before going to shopping cart
header("Location: $returnUrl" . $_SESSION['shop_return_url']);
} else {
header('Location: cart.php');
}


exit;
}

 

Link to comment
https://forums.phpfreaks.com/topic/256364-update-cart/#findComment-1314387
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.