www.gusucode.com > 123phpshop电商系统 v1.2源码程序 > code/product.php
<?php
/**
* 123PHPSHOP
* ============================================================================
* 版权所有 2015 上海序程信息科技有限公司，并保留所有权利。
* 网站地址: http://www.123PHPSHOP.com；
* ----------------------------------------------------------------------------
* 这是一个免费的软件。您可以在商业目的和非商业目的地前提下对程序除本声明之外的
* 代码进行修改和使用；您可以对程序代码以任何形式任何目的的再发布，但一定请保留
* 本声明和上海序程信息科技有限公司的联系方式！本软件中使用到的第三方代码版权属
* 于原公司所有。上海序程信息科技有限公司拥有对本声明和123PHPSHOP软件使用的最终
* 解释权！
* ============================================================================
* 作者: 123PHPSHOP团队
* 手机: 13391334121
* 邮箱: service@123phpshop.com
*/
?>
<?php require_once('Connections/localhost.php'); ?>
<?php require_once('Connections/lib/product.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$colname_product = "-1";
if (isset($_GET['id'])) {
$colname_product = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_localhost, $localhost);
$query_product = sprintf("SELECT * FROM product WHERE id = %s and is_delete=0 and is_on_sheft=1", $colname_product);
$product = mysql_query($query_product, $localhost) or die(mysql_error());
$row_product = mysql_fetch_assoc($product);
$totalRows_product = mysql_num_rows($product);
if($totalRows_product==0){
$remove_succeed_url="/";
header("Location: " . $remove_succeed_url );
}
$colname_product_images = "-1";
if (isset($_GET['id'])) {
$colname_product_images = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_localhost, $localhost);
$query_product_images = sprintf("SELECT * FROM product_images WHERE product_id = %s", $colname_product_images);
$product_images = mysql_query($query_product_images, $localhost) or die(mysql_error());
$row_product_images = mysql_fetch_assoc($product_images);
$totalRows_product_images = mysql_num_rows($product_images);
$colname_product_image_small = "-1";
if (isset($_GET['id'])) {
$colname_product_image_small = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_localhost, $localhost);
$query_product_image_small = sprintf("SELECT * FROM product_images WHERE product_id = %s", $colname_product_image_small);
$product_image_small = mysql_query($query_product_image_small, $localhost) or die(mysql_error());
$row_product_image_small = mysql_fetch_assoc($product_image_small);
$totalRows_product_image_small = mysql_num_rows($product_image_small);
mysql_select_db($database_localhost, $localhost);
$query_product_catalog = "SELECT id,name FROM `catalog` WHERE id = ".$row_product['catalog_id'];
$product_catalog = mysql_query($query_product_catalog, $localhost) or die(mysql_error());
$row_product_catalog = mysql_fetch_assoc($product_catalog);
$totalRows_product_catalog = mysql_num_rows($product_catalog);
?>
<!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=utf-8" />
<title><?php echo $row_product['name']; ?>|<?php echo $row_product['ad_text']; ?></title>
<style type="text/css">
body{
font-family:'microsoft yahei';
font-weight:normal;
}
table{
border-collapse:collapse;
}
body {
font-size:15px;
}
.all_cata_box {
color: #FFFFFF;
font-weight: bold;
margin-left:10px;
}
#to_all_cata_link{
text-decoration:none;
color:#ffffff;
}
.product_title {
font-size: 16px;
font-weight: bold;
line-height:1.5em;
}
.ad_text {
font-size: 14px;
color: #FF0000;
font-weight:normal;
line-height:20px;
}
.STYLE7 {color: #FF0000}
.intro_cons_comment {font-size: 14px;text-decoration:none;color:#666666;line-height:30px;font-weight:normal;}
.STYLE9 {
font-size: 18px;
font-weight: bold;
}
</style>
</head>
<body style="margin:0px;">
<?php include_once('widget/top_full_nav.php'); ?>
<?php include_once('widget/logo_search_cart.php'); ?>
<form id="add_to_cart" name="add_to_cart" method="post" action="cart.php">
<table width="1210" border="0" align="center" cellpadding="0" cellspacing="0" style="margin:0px auto;">
<tr valign="middle">
<td width="210" align="center" bgcolor="#B1191A"><a id="to_all_cata_link" href="/catalogs.php">
<div align="left"><span class="all_cata_box">全部分类</span></div></a></td>
<td height="44" bgcolor="#FFFFFF">  首页</td>
</tr>
</table>
<hr align="center" style="border:1px solid #B1191A;margin:0px;" width="100%" noshade="noshade" />
<div style="background-color: #f2f2f2;margin-top:0px;border-bottom:1px solid #f2f2f2;">
<table width="1210" height="45" border="0" align="center" style="margin:0px auto;" >
<tr>
<td><span class="STYLE9"><?php echo $row_product_catalog['name']; ?></span> > <?php echo $row_product['name']; ?></td>
</tr>
</table>
<table width="1210" height="425" border="0" align="center" bgcolor="#FFFFFF" style="margin:0px auto;" >
<tr>
<td width="31%" rowspan="7" align="center" valign="top" scope="row">
<?php include_once('widget/product_image_slide/index.php'); ?>
</td>
<td valign="top">
<div align="left">
<p class=""> </p>
<p class="product_title"><?php echo $row_product['name']; ?></p>
<p class="ad_text"><?php echo $row_product['ad_text']; ?></p>
</div>
<table width="98%">
<tr>
<td width="18%" height="40" bgcolor="#f7f7f7" scope="row"><blockquote>
<p style="margin-left:12px;"> 本店价:</p>
</blockquote></td>
<td width="43%" height="40" bgcolor="#f7f7f7" scope="row"><div align="left"><span class="STYLE7"><strong id="jd-price">￥</strong><?php echo $row_product['price']; ?></span> </div></td>
<td width="39%" bgcolor="#f7f7f7" scope="row"><div align="right"></div></td>
</tr>
<tr>
<td height="38" scope="row"><blockquote>
<p style="margin-left:12px;">市场价：</p>
</blockquote></td>
<td height="38" colspan="2" scope="row"><div align="left"><s><strong id="jd-price">￥</strong><?php echo $row_product['market_price']; ?></s></div></td>
</tr>
<tr>
<td height="38" scope="row" style="padding-left:12px;">库存:</td>
<td height="38" colspan="2" scope="row"><?php echo $row_product['store_num']; ?></td>
</tr>
<tr>
<td height="38" scope="row" style="padding-left:12px;">上架时间:</td>
<td height="38" colspan="2" scope="row"><?php echo $row_product['on_sheft_time']; ?></td>
</tr>
<tr>
<td height="38" scope="row" style="padding-left:12px;">创建时间:</td>
<td height="38" colspan="2" scope="row"><?php echo $row_product['create_time']; ?></td>
</tr>
<tr>
<td scope="row" style="padding-left:12px;"> 数量:</td>
<td colspan="2" scope="row"><label>
</label>
<div align="left" style="height:32px;">
<button id="up_quantity" onClick="return change_quantity(1)" style="width:32px;height:32px;line-height:30px;font-size:20px;float:left;border:0px;background-color:#e4393c;color:#FFFFFF;">+</button>
<input readOnly="true" name="quantity" type="text" id="quantity" value="1" size="6" style="font-size:20px;height:30px;line-height:29px;text-align:center;float:left;border:1px solid #e4393c;;"/>
<button id="down_quantity" onClick="return change_quantity(-1)" style="line-height:30px;font-size:20px;width:32px;height:32px;float:left;border:0px;background-color:#e4393c;color:#FFFFFF;">-</button>
</div>
<label>
<div align="left">
<input type="hidden" name="product_id" />
<input name="product_name" type="hidden" id="product_name" value="<?php echo $row_product['name']; ?>" />
<input name="product_image" type="hidden" id="product_image" value="<?php echo $row_product_images['image_files']; ?>" />
<input name="ad_text" type="hidden" id="ad_text" value="<?php echo $row_product['ad_text']; ?>" />
<input name="product_price" type="hidden" id="product_price" value="<?php echo $row_product['price']; ?>" />
<input name="product_id" type="hidden" id="product_id" value="<?php echo $row_product['id']; ?>" />
</div> </label></td>
</tr>
<tr>
<th height="231" colspan="3" align="left" scope="row"><label>
<?php if($row_product['store_num']>0){ ?>
<input style="margin-left:12px;cursor:pointer;border:1px solid #e4393c;color:#FFFFFF;font-weight:bold;border-radius:5px;height:38px;width:137px;background-color:#e4393c;border：1px solid #e4393c;" type="submit" name="Submit2" value="加入购物车" />
<?php }else{ ?>
<button disabled style="margin-left:12px;cursor:pointer;height:38px;width:137px;background-color:#FFFFFF;" />库存不足</button>
<?php }?>
</label></th>
</tr>
</table>
</td>
</tr>
</table>
</form>
</div>
<table width="1210" border="0" align="center" style="margin:0px auto;">
<tr>
<td width="210" valign="top">
<?php include_once('widget/view_buy.php'); ?>
</td>
<td valign="top" align="center">
<table width="990" height="30" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#fff" style="border-collapse:collapse;border:1px solid #DEDFDE;border-top:2px solid #999999;margin:20px 0px;;" valign="top">
<tr>
<th width="77" height="33" scope="col"><span class="intro_cons_comment">商品介绍</span></th>
<th width="77" height="33" scope="col"><a href="#consult" class="intro_cons_comment">咨询</a></th>
<th width="77" height="33" scope="col"><a href="#comment" class="intro_cons_comment">评价</a> </th>
<td height="33"><span class="STYLE8"></span></td>
</tr>
</table><table width="990" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#DEDFDE" bgcolor="#FFFFFF" style="margin:0px auto;" >
<tr>
<th bordercolor="#DEDFDE" scope="col"><?php echo $row_product['intro']; ?></th>
</tr>
</table>
<?php include('widget/product/product_comment.php'); ?>
<?php include('widget/product/product_consult.php'); ?>
</td>
</tr>
</table>
<script language="JavaScript" type="text/javascript" src="/js/image_slide/js/jquery-1.8.3.min.js"></script>
<script src="/js/product_image_slide/js/pic_tab.js"></script>
<script>
jq('#demo1').banqh({
box:"#demo1",//总框架
pic:"#ban_pic1",//大图框架
pnum:"#ban_num1",//小图框架
prev_btn:"#prev_btn1",//小图左箭头
next_btn:"#next_btn1",//小图右箭头
pop_prev:"#prev2",//弹出框左箭头
pop_next:"#next2",//弹出框右箭头
prev:"#prev1",//大图左箭头
next:"#next1",//大图右箭头
pop_div:"#demo2",//弹出框框架
pop_pic:"#ban_pic2",//弹出框图片框架
pop_xx:".pop_up_xx",//关闭弹出框按钮
mhc:".mhc",//朦灰层
autoplay:true,//是否自动播放
interTime:5000,//图片自动切换间隔
delayTime:400,//切换一张图片时间
pop_delayTime:400,//弹出框切换一张图片时间
order:0,//当前显示的图片（从0开始）
picdire:true,//大图滚动方向（true为水平方向滚动）
mindire:true,//小图滚动方向（true为水平方向滚动）
min_picnum:5,//小图显示数量
pop_up:true//大图是否有弹出框
})
var change_quantity=function(quantity){
var now_quantity=jq("#quantity").val();
// 获取box中的产品数量的值。如果产品数量为1，但是需要减去一个话，那么告知需要最少要有一件产品
if(now_quantity==1 && quantity==-1){
alert("至少需要留1件商品哦");return false;
}
var final_result=parseInt(jq("#quantity").val())+parseInt(quantity);
jq("#quantity").val(final_result);
return false;
}
</script>
<?php include('/widget/footer.php'); ?>
</body>
</html>
<?php
add_view_history($colname_product);
?>