📄 serachtel.asp

📁 个人备忘系统一个不错的备忘软件.专供刚学ASP的人学习. 代码简单易懂 mymanage

💻 ASP

字号:

<!--#include file="conn.asp"-->
<%
if session("user")="" or session("group")="" then
response.write("<script>alert('您还没有登陆或登陆超时');window.location.href('index.asp')</script>")
response.end
end if
%>
<%
set rs=server.CreateObject("adodb.recordset")
nam=request.Form("name")
tel=request.Form("tel")
pho=request.Form("pho")
qq=request.Form("QQ")
mail=request.Form("mail")
bir=request.Form("bir")

cmd="select * from tel where 姓名 like '%"&nam&"%' and 手机 like '%"&tel&"%'and 电话 like '%"&pho&"%' and QQ like '%"&qq&"%' and 邮箱 like '%"&mail&"%' and 生日 like '"&bir&"'"
rs.open cmd,conn,1,1
if not rs.eof then
session("name")=rs("姓名")
response.redirect "myfriend.asp"
else
response.write("<script>alert('无相关记录');window.location.href('serachtel.asp')</script>")
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {	font-size: 12px;
	color: #FFFFFF;
}
.style4 {font-size: 12px}
-->
</style>
</head>

<body>
<form name="form1" method="post" action="">
  <table width="700" border="0" align="center" bordercolor="#6699CC" bgcolor="#6699CC">
    <tr bgcolor="#6699CC">
      <th height="3" colspan="4" bgcolor="#6699CC"><div align="left" class="style1">我的通讯录查询</div></th>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td width="96"><div align="center"><span class="style4">姓名</span></div></td>
      <td width="216"><label>
        <input name="name" type="text" id="name">
      </label></td>
      <td width="69"><div align="center"><span class="style4">电话</span></div></td>
      <td width="301"><label>
        <input name="pho" type="text" id="pho">
      </label></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td><div align="center"><span class="style4">手机</span></div></td>
      <td><input name="tel" type="text" id="tel"></td>
      <td><div align="center"><span class="style4">QQ</span></div></td>
      <td><input name="qq" type="text" id="qq"></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td><div align="center">邮箱</div></td>
      <td><label>
        <input name="mail" type="text" id="mail">
      </label></td>
      <td><div align="center">生日</div></td>
      <td><label>
        <input name="bir" type="text" id="bir">
      </label></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td colspan="4"><label>
          <div align="center">
            <input name="Submit" type="submit" class="style4" value="  立即搜索  ">
          </div>
        </label></td>
    </tr>
  </table>
  
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -