新手小白,如下这段代码,想用于搜索,但不知道该如何添加mysql查询语句,使之能循环查询遍历后的值?

function strsToArray($strs) { 
$result = array(); 
$array = array(); 
$strs = str_replace(',', ',', $strs); 
$strs = str_replace("n", ',', $strs); 
$strs = str_replace("rn", ',', $strs); 
$strs = str_replace(' ', ',', $strs); 
$array = explode(',', $strs); 
foreach ($array as $key => $value) {
if ('' != ($value = trim($value))) { 
$result[] = $value;
echo $value; 
}
}
return $result; 

//test 
$strs = $_GET["zi"];
var_dump(strsToArray($strs));

慕娘9325324
浏览 97回答 3
3回答

牧羊人nacy

<?phpfunction strsToArray($strs) {&nbsp;$result = array();&nbsp;$array = array();&nbsp;$strs = str_replace(',', ',', $strs);&nbsp;$strs = str_replace("n", ',', $strs);&nbsp;$strs = str_replace("rn", ',', $strs);&nbsp;$strs = str_replace(' ', ',', $strs);&nbsp;$array = explode(',', $strs);&nbsp;foreach ($array as $key => $value) {if ('' != ($value = trim($value))) {&nbsp;$result[] = $value;}}foreach($result as $k=>$v){$sql="";$sql="select * from table where 查询字段 = '".$v."' ";$row = mysql_query($sql);if($ret = mysql_fetch_assoc($row)){print_r($ret);}else{echo "没有找到值为".$v."的数据";}echo "<br>";}}&nbsp;$strs = $_GET["zi"];strsToArray($strs);?>

红颜莎娜

//示例代码:index.php<?php//请求URL示例:http://localhost/index.php?zi=111,zz,ddd//获取参数$strs&nbsp;=&nbsp;$_GET["zi"];//调用函数(strsToArray)&nbsp;构造查询sql条件$where&nbsp;=&nbsp;strsToArray($strs);//连接数据库$con&nbsp;=&nbsp;mysql_connect("localhost","root","root");if&nbsp;(!$con)&nbsp;&nbsp;{&nbsp;&nbsp;die('Could&nbsp;not&nbsp;connect:&nbsp;'&nbsp;.&nbsp;mysql_error());&nbsp;&nbsp;}&nbsp;mysql_select_db("my_db",&nbsp;$con);//拼装sql、结果如:SELECT&nbsp;*&nbsp;FROM&nbsp;test&nbsp;where&nbsp;1=1&nbsp;and&nbsp;title&nbsp;like&nbsp;'%111%'&nbsp;and&nbsp;title&nbsp;like&nbsp;'%zz%'&nbsp;and&nbsp;title&nbsp;like&nbsp;'%ddd%'&nbsp;$sql="SELECT&nbsp;*&nbsp;FROM&nbsp;test&nbsp;where&nbsp;1=1&nbsp;".$where;echo&nbsp;$sql;exit;$result&nbsp;=&nbsp;mysql_query($sql);&nbsp;echo&nbsp;"查询信息如下:";while($row&nbsp;=&nbsp;mysql_fetch_array($result))&nbsp;&nbsp;{&nbsp;&nbsp;echo&nbsp;$row['字段2']&nbsp;.&nbsp;"====="&nbsp;.&nbsp;$row['字段三'];&nbsp;&nbsp;echo&nbsp;"<br&nbsp;/>";&nbsp;&nbsp;}&nbsp;mysql_close($con);function&nbsp;strsToArray($strs)&nbsp;{$where&nbsp;=&nbsp;"";$array&nbsp;=&nbsp;array();$strs&nbsp;=&nbsp;str_replace(',',&nbsp;',',&nbsp;$strs);$strs&nbsp;=&nbsp;str_replace("n",&nbsp;',',&nbsp;$strs);$strs&nbsp;=&nbsp;str_replace("rn",&nbsp;',',&nbsp;$strs);$strs&nbsp;=&nbsp;str_replace('&nbsp;',&nbsp;',',&nbsp;$strs);$array&nbsp;=&nbsp;explode(',',&nbsp;$strs);foreach&nbsp;($array&nbsp;as&nbsp;$key&nbsp;=>&nbsp;$value)&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(''&nbsp;!=&nbsp;($value&nbsp;=&nbsp;trim($value)))&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$where.="&nbsp;and&nbsp;title&nbsp;like&nbsp;'%{$value}%'&nbsp;";&nbsp;&nbsp;&nbsp;&nbsp;}}return&nbsp;$where;}?>

炎炎设计

首先连接数据库$conn&nbsp;=&nbsp;mysql_connect('localhost',&nbsp;'root',&nbsp;'mypassword');&nbsp;//连接数据库mysql_select_db('mydatabase');&nbsp;//选择库mysql_query('set&nbsp;names&nbsp;mycharset');&nbsp;//设置编码调用函数得到关键字数组$arr&nbsp;=&nbsp;strsToArray($strs);&nbsp;//得到要查询的关键字数组遍历查询$result&nbsp;=&nbsp;array();&nbsp;//初始化结果数组foreach($arr&nbsp;as&nbsp;$keyword)&nbsp;//遍历数组{&nbsp;&nbsp;$sql&nbsp;=&nbsp;"select&nbsp;*&nbsp;from&nbsp;mytable&nbsp;where&nbsp;myfield&nbsp;like&nbsp;'%$keyword%'";&nbsp;//构造SQL语句&nbsp;&nbsp;$obj&nbsp;=&nbsp;mysql_query($sql);&nbsp;//查询数据库&nbsp;&nbsp;$result&nbsp;=&nbsp;array_merge($result,&nbsp;mysql_fetch_array($obj));&nbsp;//取得结果数组}$result&nbsp;=&nbsp;array_unique($result);&nbsp;//去重&nbsp;
打开App,查看更多内容
随时随地看视频慕课网APP