博客

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

搜索框的代码：

返回搜索结果的页面：

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 ”

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 ”

$data1$data2$data3$data4$data5$data6$data7$data8$data9$data10″;

}

echo ”

“;

?>

结果不显示，怎么回事？？？