模糊查询数据库内的所有字段,并返回。
"$textfield"就是你输入的查询内容。$mysql_db=mysql_connect("localhost", "root", "");
mysql_select_db("abc",$mysql_db);
$sql="SELECT * from basic where name like '%$textfield%' or ID like '%$textfield%' or age like '%$textfield%' or birthday like '%$textfield%' or sex like '%$textfield%' or room like '%$textfield%' or room_phone like '%$textfield%' or bp like '%$textfield%' or mobile like '%$textfield%'";
$sql_result=mysql_query($sql);
while($sql_row=mysql_fetch_array($sql_result))
{ //结果
echo $sql_row[name];
echo $sql_row[ID];
echo $sql_row[age];
echo $sql_row[birthday];
echo $sql_row[sex];
echo $sql_row[room];
echo $sql_row[room_phone];
echo $sql_row[bp];
echo $sql_row[mobile];
}
"$textfield"就是你输入的查询内容。$mysql_db=mysql_connect("localhost", "root", "");
mysql_select_db("abc",$mysql_db);
$sql="SELECT * from basic where name like '%$textfield%' or ID like '%$textfield%' or age like '%$textfield%' or birthday like '%$textfield%' or sex like '%$textfield%' or room like '%$textfield%' or room_phone like '%$textfield%' or bp like '%$textfield%' or mobile like '%$textfield%'";
$sql_result=mysql_query($sql);
while($sql_row=mysql_fetch_array($sql_result))
{ //结果
echo $sql_row[name];
echo $sql_row[ID];
echo $sql_row[age];
echo $sql_row[birthday];
echo $sql_row[sex];
echo $sql_row[room];
echo $sql_row[room_phone];
echo $sql_row[bp];
echo $sql_row[mobile];
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货