WEBWMS
/
sku.php

<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	if(!isset($_SESSION)){
		session_start();
	}

	//$sql = "SELECT * FROM sku ORDER BY id DESC ";
	//SELECT  `sku`.*,  `cust`.`custcn`
	//FROM  `sku`  LEFT JOIN `cust` ON `sku`.`custid` = `cust`.`custid`;

	$sql="SELECT  `sku`.*,  `cust`.`custcn` ";
	$sql=$sql."FROM  `sku`  LEFT JOIN `cust` ON `sku`.`custid` = `cust`.`custid`
				ORDER BY `sku`.id DESC; ";

	$result = mysql_query($sql,$dbc);
	$row_Rec = mysql_fetch_assoc($result);
	//echo $row_Rec['id'];

//SELECT * FROM sku
?>
<html>
<head>
<title>产品管理页</title>
<script src="utils.js" type="text/javascript"></script>
<script src="sku.js" type="text/javascript"></script>
<style type="text/css">
<!--
body {
	#background-color: #00FFF1;
	background:url(yh3.gif);
}
table {
	border-collapse : collapse;
	background-color: #FFFFFF;
	font-family: "宋体";
	font-size: 12px;
}
.STYLE2 {
	background-color: #FFFFFF;

}
-->
</style>
</head>
	<body>

<br/><p align="center"><b>产品信息管理<b><p></p><p>

		<div align="center">&nbsp;&nbsp;
			<button type="button" id="addNew">新增</button>&nbsp;&nbsp;
			<input name="researcht" type="text" id="researcht" value="请输入查找内容(可模糊查询)"/>&nbsp;&nbsp;
			<button type="button" id="researchb">查找</button>&nbsp;&nbsp;
			<br/><br/><br/>
			<div id="showArea" class='STYLE2' align="center"></div>
			<div id="alldate">
				<table border="1">
					<tr>
						<td>id</td>
						<td>客户ID</td>
						<td>客户名称</td>
						<td>产品ID</td>
						<td>产品中文描述</td>
						<td>产品英文描述</td>
						<td>海关税则号</td>
						<td>UOM</td>
						<td>净重</td>
						<td>法定单位</td>
						<td>报关方式</td>
						<td>监管条件</td>
						<td>海关项号</td>
						<td>申报要素</td>
						<td>备注</td>
						<td width="100px" align="center">&nbsp;&nbsp;&nbsp;&nbsp;操作&nbsp;&nbsp;&nbsp;&nbsp;</td>
					</tr>
<?php do { ?>
	<tr>
		<td><?php echo $row_Rec['id'];?></td>
		<td><?php echo $row_Rec['custid'];?></td>
		<td><?php echo $row_Rec['custcn'];?></td>
		<td><?php echo $row_Rec['skuid'];?></td>
		<td><?php echo $row_Rec['skucn'];?></td>
		<td><?php echo $row_Rec['skuen'];?></td>
		<td><?php echo $row_Rec['customs'];?></td>
		<td><?php echo $row_Rec['uom'];?></td>
		<td><?php echo $row_Rec['nw'];?></td>
		<td><?php echo $row_Rec['unit'];?></td>
		<td><?php echo $row_Rec['custm'];?></td>
		<td><?php echo $row_Rec['jgtj'];?></td>
		<td><?php echo $row_Rec['custn'];?></td>
		<td><?php echo $row_Rec['sbys'];?></td>
		<td><?php echo $row_Rec['remark'];?></td>
		<td><a href="#" id="<?php echo $row_Rec['id'];?>">MODIFY</a>
			|
			<a href="#" id="<?php echo $row_Rec['id'];?>">DEL</a>

		</td>
	</tr>
<?php } while($row_Rec = mysql_fetch_assoc($result)); ?>
				</table>
			</div>
		</div>
	</body>
</html>
<?php

?>