📄 showgoods.asp
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="xingxing.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {
font-size: 14px;
color: #0000FF;
}
.style2 {font-size: 14px}
-->
</style>
</head>
<body>
<div align="left">
<!--#include file=top.asp-->
</div> <%
goods_id=request.QueryString("goods_id")
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from goods where goods_id="& goods_id
rs.open sql,conn
%>
<table width="801" height="399" border="2">
<tr>
<th width="188" height="166" scope="col"><img src="goodsimg/<%=rs(9)%>" width="169" height="135" align="left"></th>
<th width="545" scope="col"><div align="left">
<table width="100%" height="100%" border="1" bordercolor="#993333" bgcolor="#CCCC66" >
<tr>
<th width="392" height="113" scope="col"><table width="100%" height="100%"border="0" bordercolor="#FF3333">
<tr>
<th width="50%" height="23" scope="col"><div align="left"><%
Set class1=Server.CreateObject("ADODB.Recordset")
sql="select class1 from class1 where class1_id="& rs(2)
class1.open sql,conn
Set class2=Server.CreateObject("ADODB.Recordset")
sql2="select class2 from class2 where class2_id="& rs(3)
class2.open sql2,conn
%>
<font size="-1" color="#FF00FF">所属分类：<%=class1(0)%>-><%=class2(0)%></font></div></th>
<th width="50%" scope="col"><%
class1.close
class2.close
set class1=nothing
set class2=nothing
%></th>
</tr>
<tr>
<th height="61" scope="row"><p align="left">名称：<%=rs(1)%></p>
<p align="left">编号： <%=rs(0)%> </p>
<p align="left">价格：<%=rs(4)%></p>
<p align="left">VIP用户折扣：<%=rs(8)%></p></th>
<th scope="row"><div align="left">
<p>面向地区：<%=rs(6)%></p>
<p>上货时间：<%=rs(11)%></p>
<p>存货量：<%=rs(7)%></p>
</div></th>
</tr>
</table></th>
<th width="131" scope="col"><p><span class="style1"><a href="addcar.asp" class="style1">加入购物车</a></span></p>
<p ><font color="#0000FF"><a href="liuyan.asp" class="style1">我要留言</a></font></p></th>
</tr>
<tr>
<th height="89" ><div align="left">物品信息：<%=rs(5)%></div></th>
<th ></th>
</tr>
</table>
</div>
<%rs.close %>
</th>
<th width="44" scope="col"> </th>
</tr>
<tr>
<th height="85" scope="row"> </th>
<td><p>用户评论：</p>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from messageboard where goods_id="& goods_id &" order by date desc"
rs.open sql,conn,1
%>
<table width="545" height="65" border="1">
<tr>
<th width="79" scope="col">用户名</th>
<th width="328" scope="col">留言内容</th>
<th width="116" scope="col">留言时间</th>
</tr>
<%
do while not rs.eof
%>
<tr>
<th height="29" scope="row">
<%
Set user=Server.CreateObject("ADODB.Recordset")
sql="select username from user where user_id="& rs(3)
user.open sql,conn
%><%=user(0)%><%
user.close
set user=nothing %></th>
<td><%=rs(1) %></td>
<th><%=rs(2) %></th>
</tr>
<%
rs.movenext
loop
%>
</table>
<%rs.close%> <p> </p></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
</body>
</html>
<%closedb%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -