如例:
$ofTm="word1,word2,word3";
$input_array = explode(",","$ofTm");SELECT * FROM `数据库` WHERE `so` = '$input_array'";
$ofTm="word1,word2,word3";
$input_array = explode(",","$ofTm");SELECT * FROM `数据库` WHERE `so` = '$input_array'";
要转换成字符串,('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'";
}