Page 1 of 1

php shopping cart update and delete

Posted: Wed Sep 24, 2008 3:25 am
by rajanikant.shukla
<?php // Manual de PHP de WebEstilo.com
session_start();
session_register('items');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>PRINCE OPTICAL WORKS</title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #333333;
}
.style1 {
color: #FFFFFF;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style4 {color: #991111}
.style7 {font-size: 14px}
.style9 {font-size: 16px; }
.style11 {font-size: 16px; font-weight: bold; }
.style12 {color: #000000}
.style13 {font-size: 14px; color: #000000; }
.style14 {color: #991111; font-size: 14px; }
-->
</style>
</head>

<body><?
include("manager/database.php");

?>
<table width="800" align="center" cellpadding="0" cellspacing="0" bgcolor="#D7D08C">
<tr>
<td align="left" valign="top"><table width="746" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<th width="746" align="left" valign="top" scope="col"><table width="719" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="52" bgcolor="#D7D08C" scope="col"></th>
<th width="564" align="left" valign="top" scope="col"><img src="images/header.jpg" width="564" height="73" /></th>
<th width="103" bgcolor="#D7D08C" scope="col"></th>
</tr>
<tr>
<th colspan="3" bgcolor="#D7D08C" scope="col"></th>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="11" bgcolor="#D7D08C" scope="col">&nbsp;</th>
<th width="98%" scope="col"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="2%" align="left" valign="top" scope="col"><img src="images/leftmenu-bg.jpg" width="14" height="33" /></th>
<th width="96%" align="left" valign="top" background="images/centermenu-bg.jpg" scope="col"><table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="3%" scope="col">&nbsp;</th>
<th width="24%" align="left" valign="middle" scope="col"><img src="images/we-care.jpg" width="162" height="25" /></th>
<th width="3%" scope="col">&nbsp;</th>
<td width="70%" align="left" valign="middle" scope="col"><span class="style1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="menu"><a href="index.html">home</a>&nbsp; |&nbsp; <a href="aboutus.html">about us</a> &nbsp;|&nbsp; <a href="products.php">products&nbsp;</a> |&nbsp; <a href="enquiry.html">enquiry</a> &nbsp;|&nbsp; <a href="order.html">order</a>&nbsp; | &nbsp;<a href="contactus.html">contact us</a></span></td>
</tr>
</table></th>
<th width="2%" align="right" valign="top" scope="col"><img src="images/rightmenu-bg.jpg" width="14" height="33" /></th>
</tr>
</table></th>
<th width="11" bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td width="11" align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th width="705" height="20" align="left" valign="top" bgcolor="#D7D08C" scope="col">&nbsp;</th>
<th width="28" bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th height="30" align="center" valign="top" bgcolor="#D7D08C" class="prince" scope="col">Your Cart </th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th height="30" align="center" valign="top" bgcolor="#D7D08C" class="prince style4" scope="col">
<form method="post" name="cart" action="<? $_SERVER['PHP_SELF']?>">
[color=#800000]<? if(!$_POST['update'])[/color] {$id=$_GET['id'];
}
?>

<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#991111">
<tr>
<td width="22%" bordercolor="#991111"><span class="style7">id</span></td>
<td width="25%" class="style9">Price</td>
<td width="25%"><span class="style11">Quantity</span></td>
<td width="28%"><span class="style9">Total amount </span></td>
</tr>
<? if($_POST['update'])
{
$items=$_SESSION['items'];
foreach($_POST['qty'] as $k=>$v)
{
$_SESSION['items'][$k]=$v;

}
}
else{
$qty=$_POST['qty'];
$items=$_SESSION['items'];

if ($qty){
if (!isset($items)){
$items[$id]=$qty;
}else{
foreach($items as $k => $v){
if ($id==$k){
$items[$k]+=$qty;
$count=1;
}
}

if (!$count) $items[$id]=$qty;
}
}
$_SESSION['items']=$items; }
if (isset($items)){
foreach($items as $k=> $v){
$rate=mysql_query("select * from product where iid='$k'",$db);
while($rate1=mysql_fetch_array($rate))
{
$rt=$rate1['rate'];

?>
<tr>
<td><? echo $k;?></td>
<td class="style13">Rs.<? echo $rt;?></td>
<td><span class="style12">
<label>
<input name="qty[<? $k?>]" type="text" id="qty" value="<? echo $v;?>" size="10" />
</label>
</span></td>
<td><span class="style12"><span class="style7">Rs.</span><? echo $t=($rt*$v);?></span></td>
</tr> <? } }?>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td class="style14">Total Amount is Rs.<? echo $t=+$t;?></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><span class="style7">
<? $p=mysql_query("select * from product where iid='$k'",$db);
while($p1=mysql_fetch_array($p))
{?><a href="productdetails.php?id=<? echo $p1['psid']?>">Add more items </a><? }?></span></td>
<td><label>
<input name="update" type="submit" id="update" value="Update" />
</label></td>
<td class="style14">&nbsp;</td>
</tr><?
}
?>
</table>
</form></th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>

<th height="30" align="center" valign="top" bgcolor="#D7D08C" class="prince style4" scope="col"></th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th height="30" align="left" valign="top" bgcolor="#D7D08C" scope="col">&nbsp;</th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td colspan="3" align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
</tr>
<tr>
<td height="22" colspan="3" align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th height="22" align="left" valign="top" bgcolor="#D7D08C" class="planetext2" scope="col">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th height="22" align="left" valign="top" bgcolor="#D7D08C" scope="col">&nbsp;</th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th align="center" valign="top" bgcolor="#D7D08C" scope="col"><table width="100%" border="0" cellspacing="5" cellpadding="5">
<tr>
<th align="center" valign="top" scope="col"><img src="images/ask-quote.jpg" width="416" height="58" border="0" usemap="#Map" /></th>
</tr>
</table>
<map name="Map" id="Map">
<area shape="rect" coords="123,17,251,41" href="#" />
</map> </th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th align="center" valign="top" bgcolor="#D7D08C" class="phtext" scope="col"><strong>Telefax :- +91-11- 2385 1413, 2385 1516<br />
Mob :- +91- 9312 65 3815<br />
Email id :- info@pow.net.in , pow@vsnl.net</strong></th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
<tr>
<th align="left" valign="bottom" bgcolor="#D7D08C" scope="col">&nbsp;</th>
<th align="center" valign="middle" bgcolor="#D7D08C" scope="col"></th>
<th align="right" valign="top" bgcolor="#D7D08C" scope="col"></th>
</tr>
<tr>
<th colspan="3" align="left" valign="bottom" bgcolor="#D7D08C" scope="col"><div align="center"><img src="images/line.jpg" width="600" height="4" /></div></th>
</tr>
<tr>
<th colspan="3" align="center" valign="bottom" bgcolor="#D7D08C" scope="col"><span class="bottommenu">&nbsp;<a href="home.html">home</a> | <a href="aboutus.html">about us</a> | <a href="products.html">products </a>| <a href="contactus.html">contact us</a> | <a href="enquiry.html">enquiry</a> | <a href="#">email</a></span></th>
</tr>
<tr>
<th colspan="3" align="left" valign="bottom" bgcolor="#D7D08C" scope="col"><div align="center"><img src="images/line.jpg" width="600" height="4" /></div></th>
</tr>
<tr>
<th align="left" valign="bottom" bgcolor="#D7D08C" scope="col"></th>
<th align="center" valign="middle" bgcolor="#D7D08C" scope="col"></th>
<th align="right" valign="top" bgcolor="#D7D08C" scope="col"></th>
</tr>
<tr>
<th height="18" colspan="3" align="center" valign="bottom" bgcolor="#D7D08C" class="bottomtext" scope="col"><br />
copyright &copy; 2008 PRINCE OPTICAL WORKS. All rights reserved <br />
Site Devloped By :- <a href="http://www.sriramtrade.com">SRIRAM SOFT TRADE SOLUTIONS<br />
</a></th>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#D7D08C" scope="col"></td>
<th align="left" valign="top" bgcolor="#D7D08C" scope="col">&nbsp;</th>
<th bgcolor="#D7D08C" scope="col">&nbsp;</th>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table></th>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
in this i have written code to update shopping cart but not working.can anyone help me? in this code when i m adding new items it is ok but when i want to apdate quantity of added items it is not working. update script is in bold font

Re: php shopping cart update and delete

Posted: Wed Sep 24, 2008 4:00 am
by pcoder
Your problem is not clear. And tell us in more detail so that it will be easy to solve it.