我要根据关键字检索数据库中的信息,要怎么写代码才正确???
<?php
if (isset($_POST[sel_key]))
{
$key=$_POST[sel_key];
echo"$key";
$sql="select * from tb_wishes where (id = ".$key." or Picker like '%".$key."%' or author like '%".$key."%' or QQ = '".$key."' or cip like '%".$content1."%' or content like '%".$key."%' or sendTime like '%".$key."%')";
echo"$sql";
$rst = mysql_query($sql);
echo"$rst";
$result=mysql_fetch_array($rst);
if(mysql_num_rows($rst) == 0)
{
echo "[<font color=red>对不起,您检索的信息不存在!</font>]";
}
else{
?>
<tr>
<td><?php echo $result['id']; ?></td>
<td><?php echo $result['Picker']; ?></td>
<td><?php echo $result['content']; ?></td>
<?php } ?>
在表单中输入id号后,运行,我用echo输出$sql,显示的是 select * from tb_wishes where (id = 12 or Picker like '%12%' or author like '%12%' or QQ = '12' or cip like '%%' or content like '%12%' or sendTime like '%12%')
但是没有输出id为12的那条信息?这是怎么回事??
<?php
if (isset($_POST[sel_key]))
{
$key=$_POST[sel_key];
echo"$key";
$sql="select * from tb_wishes where (id = ".$key." or Picker like '%".$key."%' or author like '%".$key."%' or QQ = '".$key."' or cip like '%".$content1."%' or content like '%".$key."%' or sendTime like '%".$key."%')";
echo"$sql";
$rst = mysql_query($sql);
echo"$rst";
$result=mysql_fetch_array($rst);
if(mysql_num_rows($rst) == 0)
{
echo "[<font color=red>对不起,您检索的信息不存在!</font>]";
}
else{
?>
<tr>
<td><?php echo $result['id']; ?></td>
<td><?php echo $result['Picker']; ?></td>
<td><?php echo $result['content']; ?></td>
<?php } ?>
在表单中输入id号后,运行,我用echo输出$sql,显示的是 select * from tb_wishes where (id = 12 or Picker like '%12%' or author like '%12%' or QQ = '12' or cip like '%%' or content like '%12%' or sendTime like '%12%')
但是没有输出id为12的那条信息?这是怎么回事??
这个结果好像是用 foreach 循环的吧。