📄 list.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="webconfig.asp"-->
<html>
<head>
<title><%=webname%>--商品信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- onMouseOver="window.status='【<%=webname%>】<%=weburl%> 如果您喜欢本站,别忘了把本站介绍给您的好友哦！：）';return true">-->
<%dim dada,dadaurl,xiao1,xiao2,xiao3,xiao1url,xiao2url,xiao3url,tx1,tx1url,tx2,tx2url,tx3,tx3url
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_gg",conn,1,1
dada=trim(rs("458"))
dadaurl=trim(rs("458url"))
xiao1=trim(rs("2541"))
xiao1url=trim(rs("2541url"))
xiao2=trim(rs("2542"))
xiao2url=trim(rs("2542url"))
xiao3=trim(rs("2543"))
xiao3url=trim(rs("2543url"))
tx1=trim(rs("1441"))
tx1url=trim(rs("1441url"))
tx2=trim(rs("1442"))
tx2url=trim(rs("1442url"))
tx3=trim(rs("1443"))
tx3url=trim(rs("1443url"))
rs.close
set rs=nothing
%>
<%dim gg1,gg2,gg3,gg4,gg1url,gg2url,gg3url,gg4url
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_gg",conn,1,1
gg1=trim(rs("1601"))
gg1url=trim(rs("1601url"))
gg2=trim(rs("1602"))
gg2url=trim(rs("1602url"))
gg3=trim(rs("1603"))
gg3url=trim(rs("1603url"))
gg4=trim(rs("1604"))
gg4url=trim(rs("1604url"))
rs.close
set rs=nothing
%>
<!--#include file="webtop.asp"-->
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" class="table-zuoyou">
<tr>
<td width="180" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<!--#include file="searchinfo.asp"-->
<!--#include file="gouwucheinfo.asp"-->
<!--#include file="fenleiinfo.asp"-->
<table width="100%" class="table-shangxia" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="23" bgcolor="f1f1f1"> 友情广告</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td height="65" width="181">
<table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="right"><a href=<%=gg1url%> target="_blank"><img src=<%=gg1%> border="0" width="166" height="55"></a></div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="65" width="181">
<table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="right"><a href=<%=gg2url%> target="_blank"><img src=<%=gg2%> border="0" width="166" height="55"></a></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
</td>
<td width="400" valign="top" bgcolor="#FFFFFF" bordercolor="#FFFFFF" class="table-zuoyou">
<div align="center">
<table width="100%" class="table-shangxia" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="23">
<!--#include file="xinxi.asp"-->
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="4" align="center" class="table-xia">
<tr>
<td colspan="4"><font color="#FF0000"><b>商品信息</b></font></td>
</tr>
</table>
<br>
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from shop_books where bookid="&request("id"),conn,1,3
if rs.recordcount=0 then
%>
<table width="370" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
<td align=center>调用商品错误</td>
</tr>
</table>
<%
else
rs("liulancount")=rs("liulancount")+1
rs.update
'call history
if request.cookies("snsn")("username")<>"" then
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from [user] where username='"&request.cookies("snsn")("username")&"'",conn,1,1
t_userid=rs_s("userid")
rs_s.close
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from shop_his where bookid="&request("id")&" and username='"&request.cookies("snsn")("username")&"' and lx=1",conn,1,3
if rs_s.recordcount>0 then
rs_s("ltime")=now()
rs_s("userid")=t_userid
rs_s.update
rs_s.close
set rs_s=nothing
else
rs_s.close
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from shop_his where username='"&request.cookies("snsn")("username")&"' and lx=1 order by ltime",conn,1,3
if rs_s.recordcount>=4 then
rs_s.delete
rs_s.update
end if
rs_s.addnew
rs_s("username")=request.cookies("snsn")("username")
rs_s("bookid")=request("id")
rs_s("bookname")=rs("bookname")
rs_s("userid")=t_userid
rs_s("lx")=1
rs_s("ltime")=now()
rs_s.update
rs_s.close
set rs_s=nothing
end if
end if
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" width="160">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td>
<div align="center">
<%if rs("zhuang")="" then
response.write "<img src=images/emptybook.gif width=150 border=0>"
else%>
<table width="150" border="0" cellspacing="0" cellpadding="0" height="150">
<tr>
<td background="images/xt.gif">
<div align="center"><a href=list.asp?id=<%=rs("bookid")%> target=_blank><img src="<%=trim(rs("zhuang"))%>" width=115 border=0 height="115" alt="<%=trim(rs("bookname"))%>"></a></div>
</td>
</tr>
</table>
<%end if%>
</div>
</td>
</tr>
<tr>
<td>
<div align="center">市场价：<s><font color="#FF0000"><%=rs("shichangjia")%></font></s></div>
</td>
</tr>
<tr>
<td>
<div align="center">会员价：<%=rs("huiyuanjia")%></div>
</td>
</tr>
<tr>
<td>
<div align="center">VIP 价：<%=rs("Vipjia")%></div>
</td>
</tr>
<tr>
<td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -