怎样用数组搜索搜索数据库中的数据 如例:$ofTm="word1,word2,word3";$input_array = explode(",","$ofTm");SELECT * FROM `数据库` WHERE `so` = '$input_array'"; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看你是想怎样搜了,如果是用in,要转换成字符串,('a','b','c')$ofTm="a,b,c"; 转成$str="('a','b','c')";会吧SELECT * FROM `数据库` WHERE `so` in $str";数组大时效率不高 explore函数返回的是一个数组。所以SELECT * FROM `数据库` WHERE `so` = '$input_array' 中 so = '$input_array'会出错。$ofTm="word1,word2,word3";$input_array = explode(",","$ofTm"); $str = "(";for ($i = 0; $i < count($input_array); $i ++) { $str .= $input_array.",";}$str = substr($str ,0 ,strlen($str) - 1).")";$sql = "select * from 数据库 where so in".$str;下面执行mysql函数。 $ofTm="word1,word2,word3"; $input_array = explode(",","$ofTm"); $str = "('".join("','",$input_array)."')";SELECT * FROM `数据库` WHERE `so` in '$str'"; 如果是字符串类型,数据库中存储word1,word2,word3然后用FIND_IN_SET $ofTm="word1,word2,word3"; $input_array = explode(",","$ofTm"); foreach( $input_array as $Startingk) { SELECT * FROM `数据库` WHERE `so` = '$Startingk'"; } shopex二次开发 cakePHP我怎么插入到mysql里面乱码,但是页面从数据库读取出来正常,是怎么回事? Error page: http://www.zhuangshi6.com/qun521/article_edit.php zend studio8 怎么样进行设断点的单步调试? 亲 求登陆判断语句,我这里有了只差一点点.. IE关闭不跳转 session中保存连接 邮箱服务器的句柄问题 thinkphp 生成列表页 PHPEclipse安装配置问题 ping++ 支付宝wap支付报错问题 div+css高手留意: 09界应届毕业生求职(附作品)
要转换成字符串,('a','b','c')$ofTm="a,b,c";
转成$str="('a','b','c')";
会吧SELECT * FROM `数据库` WHERE `so` in $str";数组大时效率不高
所以SELECT * FROM `数据库` WHERE `so` = '$input_array' 中 so = '$input_array'会出错。$ofTm="word1,word2,word3";
$input_array = explode(",","$ofTm");
$str = "(";
for ($i = 0; $i < count($input_array); $i ++) {
$str .= $input_array.",";
}
$str = substr($str ,0 ,strlen($str) - 1).")";
$sql = "select * from 数据库 where so in".$str;
下面执行mysql函数。
$input_array = explode(",","$ofTm");
$str = "('".join("','",$input_array)."')";
SELECT * FROM `数据库` WHERE `so` in '$str'";
然后用FIND_IN_SET
$input_array = explode(",","$ofTm");
foreach( $input_array as $Startingk)
{
SELECT * FROM `数据库` WHERE `so` = '$Startingk'";
}