$region_arr=array('Capital','ABC','Def');
$RegionStr = implode(',', $region_arr);
$sql="SELECT tax_id from bf_taxes where tax_region IN ('$RegionStr')";
此查询对我不起作用,当回声时,结果为
SELECT tax_id from bf_taxes where tax_region IN ('Capital,ABC,DEF');
是错误的。查询应该是
SELECT tax_id from bf_taxes where tax_region IN ('Capital','ABC','DEF');
然后查询会给我准确的结果。因此,建议我在代码中需要进行的更改以实现所需的结果。
在区域之前和之后的引号('(之前尝试这样的尝试,
$region_arr=array('Capital','ABC','Def');
$RegionStr = "'".implode("','", $region_arr)."'"; //see this line
$sql="SELECT tax_id from bf_taxes where tax_region IN ($RegionStr);";
echo $sql;
输出:
从bf_taxes中选择tax_id,其中的税_区('capital','abc','def'(;