例如链接:?id=&business=a&telephone=&address=b&pageSize=10
其中有两个参数,参数business是字符a,参数address是字符b
$business = input('business/s');
$address = input('address/s');
$arr[] = "%$business%";
$arr[] = "%$address%";
$sql = "SELECT * FROM tx_business WHERE business LIKE ? AND address LIKE ?";
Db::query($sql, $arr);
这样不行。怎样才对呢?
注:我需要用原生的SQL,因为语句比较复杂,我并不想用连贯操作。
最佳答案