该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
搜索框的代码:
返回搜索结果的页面:
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 "
";?>
结果不显示,怎么回事???