论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-04-23 10:34 |只看该作者 |倒序浏览

<html>;
<p>; </p>;
<div align="center">;
<center>;
<table border="1" width="50%" bordercolor="#008000"
cellspacing="0" cellpadding="0" height="100">;
<tr>;
<td width="100%" height="100" valign="top">;
<p align="center" class="1">;IP查询</P>;
<form action="search_ip_address.php?mode=doit" method="post">;
<table border="0" width="100%" cellspacing="0" cellpadding="0">;
<tr>;
<td width="50%" align="right">;用户住址</td>;
<td width="50%">;<input type="text" name="address" size="20">;</td>;
</tr>;
<tr>;
<td width="50%" align="center" colspan="2">;
<input type="submit" value="查询" name="B1">;</td>;
</tr
</td>;
</tr>;
  </table>;
  </center>;
</div>;
<?
$sql="select * from scau_home where address='$address'";
$result=mysql_query($sql);
?>;

这是一段根据用户住址查询用户资料PHP程序的表单及数据库查询部分代码，现在希望实现对用户住址的模糊查询，应该如何修改呢？请高手指教。

文库|博客

dualface

丰衣足食

论坛徽章:: 0

2楼 [报告]

发表于 2004-04-23 10:55 |只看该作者

如何用PHP对输入的关键字进行模糊查询？（内附源代码）

address like '$addess'

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

gzywll

白手起家

论坛徽章:: 0

3楼 [报告]

发表于 2004-04-23 11:36 |只看该作者

如何用PHP对输入的关键字进行模糊查询？（内附源代码）

修改如下：但还是不行
<html>;
<p>;&&</p>;
<tr>;
<td>;&&ÉíËÞÉá°&ÒÔÏÂ&&Ê½²éÑ&:&&Î÷106</td>;
<p>; </p>;
<td>;áÔÉ½Ç&°&ÒÔÏÂ&&Ê½²éÑ&:11&°101</td>;
<p>; </p>;
<td>;ÁùÒ&Ç&°&ÒÔÏÂ&&Ê½²éÑ&:ÁùÒ&14&°501</td>;
<p>; </p>;
<td>;ÅàÑ&Â&°&ÒÔÏÂ&&Ê½²éÑ&:ÅàÑ&Â&106</td>;
<p>; </p>;
<td>;²èÉ½Ç&°&ÒÔÏÂ&&Ê½²éÑ&:²èÉ½16&°703</td>;
</tr>;
<div align="center">;
<center>;
<table border="1" width="50%" bordercolor="#008000"
cellspacing="0" cellpadding="0" height="100">;
<tr>;
<td width="100%" height="100" valign="top">;
<p align="center" class="1">;IP²éÑ&</P>;
<form action="search_ip_address.php?mode=doit" method="post">;
<table border="0" width="100%" cellspacing="0" cellpadding="0">;
<tr>;
<td width="50%" align="right">;ÓÃ&§×&Ö·</td>;
<td width="50%">;<input type="text" name="address" size="20">;</td>;
</tr>;
<tr>;
<td width="50%" align="center" colspan="2">;
<input type="submit" value="²éÑ&" name="B1">;</td>;
</tr
</td>;
</tr>;
  </table>;
  </center>;
</div>;
<?
$sql="select * from scau_home where address like '$address'";$result=mysql_query($sql);
?>;
<table width="100%" border="1">;
<tr>;
<td>;ÓÃ&§Ã&</td>;
<td>;²&ÃÅ</td>;
<td>;&ØÖ·</td>;
<td>;¹Ì&¨&&&°</td>;
<td>;ÊÖ&ú</td>;
<td>;IP</td>;
<td>;×ÓÍ&ÑÚÂ&</td>;
<td>;Í&¹Ø</td>;
<td>;&&&§ÈÕÆÚ</td>;
<td>;ÓÃ&§ID</td>;
</tr>;
<?
while($arr=mysql_fetch_array($result)){
?>;
<tr>;
  <td>;<?echo $arr["username"];?>;&</td>;
  <td>;<?echo $arr["department"];?>;&</td>;<td>;<?echo $arr["address"];?>;&</td>;
  <td>;<?echo $arr["phone_local"];?>;&</td>;
  <td>;<?echo $arr["phone"];?>;&</td>;
  <td>;<?echo $arr["ip"];?>;&</td>;
  <td>;<?echo $arr["subnet"];?>;&</td>;
  <td>;<?echo $arr["gateway"];?>;&</td>;
  <td>;<?echo $arr["date"];?>;&</td>;
  <td>;<?echo $arr["user_id"];?>;&</td>;
</tr>;
<?
}
?>;
</table>;
</html>;