📄 fullmessage.php
字号:
<?
session_start();
//检查是否是授权的管理
if(!session_is_registered("manager"))
{
Header("HTTP/1.0 401 Unauthorized");
exit();
}
//连接数据库，取得相应订单号对应的全部信息
$connect=mysql_connect("127.0.0.1","root","root");
mysql_select_db("ebusiness");
//如果JOB参数的值为delete的话，执行删除的操作
if($job="delete")
{
$query="delete form EOrder where OrderID=".$OrderID;
if(mysql_query($query))
{
header("Location:ordermanage.php");
exit();
}
}
//如果JOB参数的值为update的话，执行更新操作
if($job="update")
{
$query="update EOrder set IsSent='".$issent."'where OrderID=".$OrderID;
mysql_query($query);
}
$query="select * from EOrder where OrderID=".$OrderID;
$result=mysql_query($query);
$count=1;
$message[0]=0;
while($obj=mysql_fetch_object($result))
{
$message[$count]=$obj;
$message[0]++;
$count++;
}
mysql_close($connect);
//下面是输出HTML：
?>
<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 width="760" border="0" cellspacing="0" cellpadding="0" class="css1">
<tr>
<td width="100" height="59"><img src="pic/logo.gif" width="100" height="60"></td>
<td width="468" height="59"><img src="pic/banner.gif" width="468" border="0"></td>
<td width="192" height="59"> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#66ccff">您现在的位置：订单详细信息</td>
<td width="192"> </td>
</tr>
<tr>
<td colspan="3" height="13">
</tr>
<center>
<form method="post" action="">
<?
echo'<p>订单号：'.$message[1]->OrderID.'</p>';
if($message[1]->UserID==0)
{
$user="非注册用户";
}
else
{
$user="注册用户";
}
echo'<p>用户ID：'.$message[1]->UserID.'('.$user.')</p>';
echo'<p>联系电话：'.$message[1]->Tel.'</p>';
echo'<p>创建时间：'.$message[1]->OrderDate.'</p>';
echo'<p><a href=fullmessage.php?job=delete&OrderID='.$mesage[1]->OrderID.'>删除本订单</a></p>';
echo'<p>是否发货：';
if($message[1]->IsSent=="n")
{
echo'<select name="issent" size="1">
<option value="y">是</option>
<option value="n" selected>否</option>
</select>';
else
echo'<select name="issent" size="1">
<option value="y" selected>是</option>
<option value="n">否</option>
</select>';
echo'</p>
<table width="700" border="1" cellspacing="2" cellpadding="0" class="css1"
bordercolorlight="#ccccff" bordercolordark="#6666ff">
<tr align="center">
<td width="140">商品名</td>
<td width="140">商品ID</td>
<td width="140">单价</td>
<td width="140">数量</td>
<td width="140">总计</td>
</tr>';
$total=0;
for($i=1;$i<=$message[0];$i++)
{
echo'<tr align="center">';
echo'<td width="140">'.$message[$i]->ProductName.'</td>';
echo'<td width="140">'.$message[$i]->ProductID.'</td>';
echo'<td width="140">'.$message[$i]->Price.'</td>';
echo'<td width="140">'.$message[$i]->Quantity.'</td>';
echo'<td width="140">'.$message[$i]->Sun.'</td>';
$total+=$message[$i]->Sum;
echo'</tr>';
}
echo'</table>';
echo'<p>总计：'.$total.'元'；
echo'<input type="hidden" name="job" value="update">';
echo'<input type="hidden" name="OrderID" value="'.$message[1]->OrderID.'">';
echo'<input type="submit" name="Submit" value="更新">'；
echo'</form>';
?>
</center>
</td>
</tr>
<tr>
<td colspan="3" bgcolor="#0000ff"> </td>
<tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -