Hi
I have a shopping cart where i can add, update and delete products. In this we can update the quantity of each product as and when required. Now I am asked to add a select box to add the required units of that product So the selected units of the product need to remain in the session which is not happening.
Here is the showCart() method:
<?php
function showCart() {
global $db;
$cartItems = $_SESSION[‘cartItems’];
if ($cartItems) {
$output[] = '<form name="scart" action="cart.php?action=update" method="post">';
$output[] = '</tr>';
foreach ($cartItems as $id=>$qty)
{
$cartItems[$id]=$qty;
$sql = "SELECT * FROM sb_products WHERE id = '$id'";
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$output[] = '<tr>';
$output[] = '<td><a href="cart.php?action=delete&id='.$id.'" class="remove">Remove</a></td>';
$output[] = '<td>'.$grade.'</td>';
$output[] = '<td>'.$origin.'</td>';
echo "<br />";
$output[] = '<td><input id="quan" type="text" name="qty'.$id.'" value="'.$qty.'" size="5" maxlength="5" /></td>';
$string = explode(",",$units);
$total_count=count($string);
$output[] ='<td> <select name="punit'.$id.'" class="indexselect">
<option value="">--- Select ---</option>
<option value="Pieces" <?php if($sel=="abc"){ echo "selected"; } ?>abc</option>
<option value="Tons" <?php if($sel=="xyz"){ echo "selected"; } ?>xyz</option>
</select></td>';
} // for ends
$output[] = '<div style="padding:10px 0 0 0;"><input type="submit" value="Update product"></div>';
$output[] = '</form>';
$output[] = '</table>';
}
else {
$output[] = '<p>Your cart is empty.</p>';
}
return join('',$output);
mysql_free_result();
}
?>
And here are the cart methods:
<?php
$cartItems = $_SESSION[‘cartItems’];
$action = $_GET[‘action’];
$chk = $_GET[‘id’];
$cbox = explode(‘,’,$chk);
$sd=$_POST[“punit”.$id];
$q=$_POST[“qty”.$id];
echo “<br />”;
$string1 = implode($sd,“,”);
$cselect = explode(‘,’,$string1);
$tcount= count($cbox);
$ctcount= count($cselect);
for( $r=0;$r<$ctcount; $r++)
{
$sel[$r] = $cselect[$r];
echo $sel[$r]; // gives select value, now I am not able to get the value back in the showCart() method
}
for( $k=0;$k<$tcount; $k++)
{
$to[$k] = $cbox[$k];
switch ($action)
{
case ‘add’:
if(!empty($cartItems))
{
if(!array_key_exists($to[$k],$cartItems))
{
$cartItems[$to[$k]]='1';
}
}
else
{
$cartItems[$to[$k]]='1';
}
break;
case 'delete':
if(!empty($cartItems))
{
if(array_key_exists($to[$k],$cartItems))
{
$cartItems[$to[$k]]='1';
unset($to[$k],$cartItems[$id]);
}
}
break;
case 'update':
foreach ($_POST as $id=>$qty)
{
if(empty($cartItems))
{
if(!array_key_exists($id,$cartItems))
{
//$cartItems[$id]=$qty;
}
}
else
{
$cartItems[$id]=$qty;
}
}
break;
}
} // for ends
?>
I am just not able to get what is going wrong or ho to pass the value in update method back to the showCart method. Please if someone can help me out?