?? productmanage.php
字號:
<?
include "pfuncs.php";
session_start();
//檢查是否是授權的管理者
if(!session_is_registered("manager"))
{
Header("HTTP/1.0 401 Unauthorized");
exit();
}
//如果JOB參數為delete，執行刪除的操作
if($job=='delete')
{
$connect=mysql_connect("127.0.0.1","root","root");
mysql_select_db('ebusiness');
$cmd='delete from Product where ProductID='.$id;
if($result=mysql_query($cmd));
$message='成功刪除！';
mysql_close($connect);
}
?>
<html>
<head>
<title>商品管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.css1{font-family:"宋體"; font-size:9pt; font-style: normal; line-height:normal;
font-weight:normal; color:#000000}
-->
</style>
</head>
<body bgcolor="#ffffff">
<table widht="760" border="0" cellspacing="0" cellpadding="0" class="css1">
<tr>
<td width="100"><img src="pic/logo.gif" width="100" height="60"></td>
<td width="468"><img src="pic/banner.gif" width="469" height="60"
border="0"></td>
<td width="192">&nasp;</td>
</tr>
<tr>
<td colspan="2" bgcolor="#66ccff">你現在的位置是：商品管理模式！</td>
<td width="192"> </td>
</tr>
<tr>
<td colspan="3" height="24">下表列出了商品Product數據庫中的商品
<?
echo $message;
//檢查需要的信息是否已輸入
$startpage=$startpage?$startpage:1;
$productcount=getrownumber();
$pagesize=10;
if($startpage>$productcount/10)
{
$pagesize=thelastnumber($productcount);
}
//得到返回值
$msgs=GetMessages($startpage*10-10,$pagesize);
?>
</td>
</tr>
<tr>
<td colspan="3" height="13">
<table width="700" border="1" cellspacing="2" cellpadding="0" class="css1"
bordercolorlight="#ccccff" bordercolordark="#6666ff">
<tr align="center">
<td width="95" height="12">商品名</td>
<td width="94" height="12">編號</td>
<td width="96" height="12">價格</td>
<td width="95" height="12">顏色</td>
<td width="95" height="12">規格</td>
<td width="95" height="12">詳細</td>
<td width="98" height="12">刪除</td>
</tr>
</tr>
<?
//按格式輸出
for($count=1;$count<=$msgs[0];$count++)
{
echo'<tr align="center">';
echo'<td width="95">'.$msgs[$count]->ProductName.'</td>';
echo'<td width="94">'.$msgs[$count]->ProductID.'</td>';
echo'<td width="96">'.$msgs[$count]->Price.'</td>';
echo'<td width="95">'.$msgs[$count]->Color.'</td>';
echo'<td width="95">'.$msgs[$count]->Size.'</td>';
echo'<td width="95"><a href="psdetail.php?id='.$msgs[$count]->ProductID.'" target="blank">詳細</a></td>';
echo'<td width="98"><a href="productmanage.php?job=delete&id='.$msgs[$count]->ProductID.'">刪除</a></td>';
echo'</tr>';
}
?>
</table>
</td>
</tr>
<tr>
<td colspan="3" height="13">
<?
//輸出頁面的選擇超鏈接
if($productcount>10)
{
echo'<p>';
for($i=1;$i<=$productcount/10+1;$i++)
{
echo' <a href=productmanage.php?starpage=';
echo $i;
echo '>';
echo $i;
echo '</a>';
}
echo'</p>';
}
?>
</td>
</tr>
<tr>
<td colspan="3" height="13"><a href="addproduct.php">添加薪商品</a></td>
</tr>
<tr>
<td colspan="3" bgcolor="#0000ff"> </td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -