【php开源代码栏目提醒】:网学会员在php开源代码频道为大家收集整理了cart.php提供大家参考,希望对大家有所帮助!
<?php if ($index_refer <> 1) { exit; } ?>
<?php include ("checklogin.php"); ?>
<?php
//获取购买商品的件数
if (!empty($_POST['numprod'])) {
$numprod=$_POST['numprod'];
}
//获取购物车的ID号
if (!empty($_POST['basketid'])) {
$basketid=$_POST['basketid'];
}
// 获取当天的日期
$today = getdate();
if (IsAdmin() == true) {
if (!empty($_GET['id']))
{ $customerid = $_GET['id']; }
}
//添加商品到购物车中
if ($action=="add"){
if ($numprod<>0){
$query = "INSERT INTO `basket` ( `ID` , `CUSTOMERID` , `PRODUCTID` , `STATUS` , `ORDERID` , `LINEADDDATE` , `QTY` ) VALUES ( '', '" . $customerid . "', '" . $prod . "', 'BASKET', '' , '" . Date("d-m-Y @ G:i") . "' , '" . $numprod . "')";
$sql = mysql_query($query) or die(mysql_error());
}
}
//更新购物车
if ($action=="update"){
//如果商品的件数修改为0,则删除
if ($numprod==0){
$query = "DELETE FROM basket WHERE ID = " . $basketid;
$sql = mysql_query($query) or die(mysql_error());
}
else {
//修改购物车中的信息
$query = "UPDATE `basket` SET `CUSTOMERID` = " . $customerid . ", `PRODUCTID` = '" . $prod . "', `STATUS` = 'BASKET', `ORDERID` = 0, `LINEADDDATE` = '0000-00-00', `QTY` = " . $numprod . " WHERE `ID` = " . $basketid;
$sql = mysql_query($query) or die(mysql_error());
}
}
//删除购物车中的商品
if ($action=="empty"){
$query = "DELETE FROM basket WHERE CUSTOMERID = " . $customerid;
$sql = mysql_query($query) or die(
mysql_error());
}
// 读取购物车中的商品
$query = "SELECT * FROM basket WHERE (CUSTOMERID = " . $customerid . " AND STATUS = 'BASKET') ORDER BY ID";
$
sql = mysql_query($query) or die(mysql_error());
$count = mysql_num_rows($sql);
//如果购物车为空,则显示购物车没有商品的图标
if ($count == 0) {
PutWindow ($txt['cart1'], $txt['cart2'], "carticon.gif", "50");
}
else {
?>
<table width=100% border=0 bgcolor=<?php echo $tb_bordercolor ?> cellspacing=1 cellpadding=0>
<tr><td align=left bgcolor=<?php echo $tb_title_bgcolor ?>>
<!--显示购物车的图片以及样式的设置-->
<img src=<?php echo $gfx_dir ?>/cart.gif border=0 align=absmiddle>
<font color=<?php echo $tb_title_textcolor ?>><b><?php echo $txt['cart3']; ?></b></font><!--说明-->
</td>
<td align=center bgcolor=<?php echo $tb_title_bgcolor ?>>
<font color=<?php echo $tb_title_textcolor ?>><b><?php echo $txt['cart4']; ?></b></font><!--价格-->
</td>
<td align=center bgcolor=<?php echo $tb_title_bgcolor ?>>
<font color=<?php echo $tb_title_textcolor ?>><b><?php echo $txt['cart5']; ?></b></font><!--数量-->
</td>
</tr>
<tr><td align=left colspan=3>
<table width=100% border=0 cellpadding=3 cellspacing=0>
<?php
$optel = 0;
while ($row = mysql_fetch_row($sql)) {
//根据购物车商品的ID号
查询商品的所有信息
$query = "select * from product where PRODUCTID='" . $row[2] . "'";
$sql_details = mysql_query($query) or die(mysql_error());
//将获取的商品信息保存到$row_details中
while ($row_details = mysql_fetch_row($sql_details)) {
$optel = $optel +1;
if ($optel == 3) { $optel = 1; }
if ($optel == 1) { $kleur = $tb_pricelist_color1; }
if ($optel == 2) { $kleur = $tb_pricelist_color2; }
//
if ($pricelist_format == 0) { $print_description = $row_details[1]; }
if ($pricelist_format == 1) { $print_description = $row_details[3]; }
if ($pricelist_format == 2) { $print_description = $row_details[1]." - ".$row_details[3]; }
if ($max_description != 0) {
$description = stringsplit($print_description, $max_description); //仅显示商品描述的前面多少字符
if (strlen($print_description) != strlen($description[0])) { $description[0] = $description[0] . ".."; }
$print_description = $description[0];
}
?>
<tr><td bgcolor=<?php echo $kleur ?> align=left valign=top>
<a href=index.php?page=details&prod=<?php echo $row_details[0] ?>><?php echo $print_description ?></a>
</td>
<td bgcolor=<?php echo $kleur ?> align=right valign=top>
<b><?php echo $currency_symbol ?></b> <?php
//商品的单价*购买的件数
$subtotaal = $row_details[4] * $row[6];
//计算费锐
if ($no_vat == 0 && $db_prices_including_vat == 0) { $subtotaal = $subtotaal * $vat; }
$printprijs = myNumberFormat($subtotaal, $number_format);
echo $printprijs;
?>
</td>
<td bgcolor=<?php echo $kleur ?> align=center valign=top>
<!--将表单中的数据提交到index.php?page=cart&action=update进行处理-->
<form method=POST action=index.php?page=cart&action=update>
<input type=hidden name=prod value="<?php echo $row_details[1] ?>"><!--商品名称-->
<input type=hidden name=basketid value=<?php echo $row[0] ?>><!--购物车的ID号-->
<!--商品的件数和更新按钮