<body>
<%
Function repl_keyword(str)
repl_keyword=replace(str,keyword,"<font color='#FF3300'>"&keyword&"</font>")
End Function
%>
<%
Dim keyword
keyword=replace(Trim(Request.Form("keyword")),"'","")
SQLStr="SELECT id,username,linkman,com_name,address FROM user_info WHERE username LIKE '%"&keyword&"%' OR linkman LIKE '%"&keyword&"%' OR com_name LIKE '%"&keyword&"%' OR address LIKE '%"&keyword&"%'"
Set RS=Server.CreateObject("ADODB.RecordSet")
RS.Open SQLStr,Conn
If NOT RS.Eof Then
%>
<center>
<p><FONT color=#990000 size="2"><strong>搜索结果</strong></FONT></p>
<table width="100%" border="0" bgcolor="#CCFFFF">
<tr align="center" bgcolor="#33CCFF" class="font14">
<td>用户名称</td>
<td width="25%">公司名称</td>
<td width="25%">公司地址</td>
<td> 联 系 人</td>
<td>操作</td>
</tr>
<%
DO While Not RS.eof
username=repl_keyword(RS("username"))
linkman=repl_keyword(RS("linkman"))
com_name=repl_keyword(RS("com_name"))
address=repl_keyword(RS("address"))
%>
<tr bgcolor="#99FFFF" class="font12">
<td><a href="show.asp?id=<%=RS("id")%>"><%=username%></a></td>
<td><%=com_name%></td>
<td><%=address%></td>
<td><%=linkman%></td>
<td><span class="font12bgc"><a href="edit.asp">修改</a></span> <span class="font12bgc">批准权限</span>
<span class="font12bgc">删除</span></td>
</tr>
<%
RS.MoveNext
If Not RS.eof Then
username=repl_keyword(RS("username"))
linkman=repl_keyword(RS("linkman"))
com_name=repl_keyword(RS("com_name"))
address=repl_keyword(RS("address"))
%>
<tr class="font12">
<td><a href="show.asp?id=<%=RS("id")%>"><%=username%></a></td>
<td><%=com_name%></td>
<td><%=address%></td>
<td><%=linkman%></td>
<td><span class="font12bgc">修改</span> <span class="font12bgc">批准权限</span>
<span class="font12bgc">删除</span></td>
</tr>
<%
End If
If Not RS.eof Then
RS.MoveNext
End If
LOOP
%>
</table>
</center>
<%
End If
RS.Close
Set RS=Nothing
Conn.Close
Set Conn=nothing
%>