网页制作吧 关注:156,876贴子:479,048
  • 0回复贴,共1

急问!本人做了个搜索框,请问怎样将搜索到的匹配数据显示出来

取消只看楼主收藏回复

搜索框的代码:
<input type="search" name="name2" value="请输入关键字" onMouseOver="this.focus()" onBlur="if (value ==''){value='请输入关键字'}" onFocus="this.select()" onClick="if(this.value=='请输入关键字')this.value=''">
返回搜索结果的页面:
<?php
error_reporting(0);
$db=mysql_connect("localhost","rfid","rfid");
$select=mysql_select_db("rfid2",$db);
$_sql="SELECT * FROM info WHERE tagID LIKE '%name2%' OR name1 LIKE '%name2%' OR type1 LIKE '%name2%' OR manufacturer LIKE '%name2%' OR classification LIKE '%name2%' OR buyDate LIKE '%name2%' OR ManufactureDate LIKE '%name2%' OR unit LIKE '%name2%' OR buyer LIKE '%name2%' OR amount LIKE '%name2%'; ";
mysql_query("set names utf8");//编码设置为utf8
$query=mysql_query($_sql);
echo "<table>";
while($row=mysql_fetch_array($query))
{
//从数据库查询出来的字段
$data1=$row["tagID"];
$data2=$row["name1"];
$data3=$row["type1"];
$data4=$row["manufacturer"];
$data5=$row["classification"];
$data6=$row["buyDate"];
$data7=$row["ManufactureDate"];
$data8=$row["buyer"];
$data9=$row["unit"];
$data10=$row["amount"];
//将数据放到html的表格中
echo "<tr><td>$data1</td><td>$data2</td><td>$data3</td><td>$data4</td><td>$data5</td><td>$data6</td><td>$data7</td><td>$data8</td><td>$data9</td><td>$data10</td></tr>";
}
echo "</table>";
?>
结果不显示,怎么回事???


1楼2015-05-19 20:43回复