📄 lyb.asp
字号:
<!--#include file="conn1.asp"-->
<%
if request.QueryString("action")="save" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from book",conn,1,3
rs.addnew
rs("name")=trim(request("name"))
rs("content")=trim(request("content"))
if request("qq")<>"" then
rs("qq")=request("qq")
end if
rs("mail")=trim(request("mail"))
if request("sex")<>"" then
rs("sex")=request("sex")
else
rs("sex")=0
end if
rs("adddate")=now()
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript>alert('添加成功！');window.location.href='lyb.asp';</script>"
response.End
end if
%>
<html><head><title>杰拍网-留言板</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="image/css.css" rel="stylesheet" type="text/css">
</head>
<script language="javascript">
<!--
function checkdata()
{
if (document.form1.name.value=="")
{
alert("对不起，请输入尊姓大名！")
document.form1.name.focus()
return false
}
if (document.form1.Content.value.length==0)
{
alert("对不起，请输入留言内容！")
//document.form1.content.focus()
return false
}
}
function MM_goToURL() { //v3.0
var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<script language="JavaScript">
<!-- Hide from older browsers...
//Function to format text in the text box
function FormatText(command, option){
frames.message.document.execCommand(command, true, option);
frames.message.focus();
}
//Function to add image
function AddImage(){
imagePath = prompt('请输入图片地址', 'http://');
if ((imagePath != null) && (imagePath != "")){
frames.message.document.execCommand('InsertImage', false, imagePath);
frames.message.focus();
}
frames.message.focus();
}
//Function to clear form
function ResetForm(){
if (window.confirm('确认要清空对话框内容?')){
frames.message.document.body.innerHTML = '';
return true;
}
return false;
}
//Function to open pop up window
function openWin(theURL,winName,features) {
window.open(theURL,winName,features);
}
function setMode(newMode)
{
bTextMode = newMode;
var cont;
if (bTextMode) {
cleanHtml();
cleanHtml();
cont=message.document.body.innerHTML;
message.document.body.innerText=cont;
} else {
cont=message.document.body.innerText;
message.document.body.innerHTML=cont;
}
message.focus();
}
function cleanHtml()
{
var fonts = message.document.body.all.tags("FONT");
var curr;
for (var i = fonts.length - 1; i >= 0; i--) {
curr = fonts[i];
if (curr.style.backgroundColor == "#ffffff") curr.outerHTML = curr.innerHTML;
}
}
// -->
</script>
<script language="JavaScript">
function help()
{
var helpmess;
helpmess="---------------填写帮助---------------\r\n\r\n"+
"1.请不要发表有危险性的脚本。\r\n\r\n"+
"2.如果要书写源代码，请选中\r\n\r\n"+
" 查看HTML源代码书写.\r\n\r\n"+
"3.需要你自己运行,才能看效果.\r\n\r\n"+
"4.如果书写js，尽量不要在这儿书写.\r\n\r\n";
alert(helpmess);
}
</script>
<body leftmargin="0" topmargin="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(startColorStr='#AEE7B2', endColorStr='#FFFFFF', gradientType='0')">
<table width="100%" border="0" cellspacing="0">
<tr>
<td height="287" align="center" valign="top"><table width="100%" border="0">
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="760" height="90">
<param name="movie" value="image/menu.swf" />
<param name="quality" value="high" />
<param name="wmode" value="transparent" />
<embed src="image/menu.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="760" height="90"></embed>
</object></td>
</tr>
<tr>
<td align="center">
<form name="form1" method="post" action="lyb.asp?action=save" onSubmit="return checkdata()" onReset="return ResetForm();">
<table width="500" border="0">
<tr>
<td width="63" align="center">昵 称:</td>
<td width="128" align="center">
<input name="name" type="text" size="15"></td>
<td width="63" align="right" valign="top">留言内容:</td>
<td width="228" rowspan="5" align="right" valign="top">
<textarea name="content" cols="30" rows="7"></textarea></td>
</tr>
<tr>
<td align="center">性 别:</td>
<td align="center"><input name="sex" type="radio" value="0" checked>
男
<input type="radio" name="sex" value="1">
女 </td>
<td width="63" valign="top"> </td>
</tr>
<tr>
<td align="center">Q Q:</td>
<td align="center"><input name="qq" type="text" size="15"></td>
<td width="63" valign="top"> </td>
</tr>
<tr>
<td align="center">E-Mail:</td>
<td align="center"><input name="mail" type="text" size="15"></td>
<td width="63" valign="top"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td width="63" valign="top"> </td>
</tr>
<tr>
<td> </td>
<td colspan="3"><input class="go-wenbenkuang" type="submit" name="Submit" value="提交发表" onClick="document.form1.Content.value = frames.message.document.body.innerHTML;">
<input onClick="ClearReset()" class="go-wenbenkuang" type=reset name="Clear" value="重新填写"></td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
</table>
</form></td>
</tr>
</table>
<table width="760" border="0">
<tr>
<td>留言列表</td>
</tr>
<tr>
<td valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="table-2">
<tr>
<td width="10" height="292"> </td>
<td width="539" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" align="center" valign="middle">个人照片</td>
<td align="center">信息内容</td>
</tr>
</table><%set rs=server.createobject("adodb.recordset")
rs.open "select * from book order by adddate desc",conn,1,1
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.PageSize =10 '每页记录条数
iCount=rs.RecordCount '记录总数
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
For i=1 To x
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="15%" rowspan="2" align="center" valign="middle">
<table width="100%" border="0">
<tr>
<td align="center">
<%if rs("sex")=1 then %>
<img src="image/nv.GIF" width="75" height="75">
<%else%>
<img src="image/nan.GIF" width="75" height="75">
<%end if%>
</td>
</tr>
<tr>
<td align="center">昵 称:<%=rs("name")%></td>
</tr>
<tr>
<td align="center">
<%if rs("qq")<>"" then
response.write "Q Q:"&rs("qq")
end if%></td>
</tr>
</table> </td>
</tr>
<tr>
<td align="left" valign="top">
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%" valign="top"> </td>
<td width="96%" valign="top"><%response.write trim(rs("content"))%></td>
</tr>
</table></td>
</tr>
</table>
<%rs.movenext
next
call PageControl(iCount,maxpage,page,"border=0 align=center","<p align=center>")
end if
rs.close
set rs=nothing
Sub PageControl(iCount,pagecount,page,table_style,font_style)
'生成上一页下一页链接
Dim query, a, x, temp
action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME")
query = Split(Request.ServerVariables("QUERY_STRING"), "&")
For Each x In query
a = Split(x, "=")
If StrComp(a(0), "page", vbTextCompare) <> 0 Then
temp = temp & a(0) & "=" & a(1) & "&"
End If
Next
Response.Write("<table width=100% border=0 cellpadding=0 cellspacing=0>" & vbCrLf )
Response.Write("<form method=get onsubmit=""document.location = '" & action & "?" & temp & "Page='+ this.page.value;return false;""><TR >" & vbCrLf )
Response.Write("<TD align=center height=35>" & vbCrLf )
Response.Write(font_style & vbCrLf )
if page<=1 then
Response.Write ("首 页 " & vbCrLf)
Response.Write ("上一页 " & vbCrLf)
else
Response.Write("<A HREF=" & action & "?" & temp & "Page=1>首 页</A> " & vbCrLf)
Response.Write("<A HREF=" & action & "?" & temp & "Page=" & (Page-1) & ">上一页</A> " & vbCrLf)
end if
if page>=pagecount then
Response.Write ("下一页 " & vbCrLf)
Response.Write ("尾 页 " & vbCrLf)
else
Response.Write("<A HREF=" & action & "?" & temp & "Page=" & (Page+1) & ">下一页</A> " & vbCrLf)
Response.Write("<A HREF=" & action & "?" & temp & "Page=" & pagecount & ">尾 页</A> " & vbCrLf)
end if
Response.Write(" 页次：" & page & "/" & pageCount & "页" & vbCrLf)
Response.Write(" 共有" & iCount & "条留言" & vbCrLf)
Response.Write(" 转到" & "<INPUT TYEP=TEXT NAME=page SIZE=2 Maxlength=5 VALUE=" & page & ">" & "页" & vbCrLf & "<INPUT CLASS=go-wenbenkuang type=submit value=GO>")
Response.Write("</TD>" & vbCrLf )
Response.Write("</TR></form>" & vbCrLf )
Response.Write("</table>" & vbCrLf )
End Sub
%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -