如何将多个参数绑定到 PHP 准备好的语句？

Question

"SELECT id as Id from dbTable WHERE code = ? AND CURDATE() BETWEEN 
start_date AND end_date AND offerId IN ('12321', '12124')";
//Passing arguments for the query
$args = array_merge(array(51342),$offerid);

//Execute the prepared query
$statement->execute($args);

现在数组（51342）表示代码+值的组合，除了我的数据库有值、代码列之外，所以我想要一个逻辑上看起来像这样的查询：

"SELECT id as Id from dbTable WHERE code and value 
//(Note here I do not know the syntax, 
//what am looking at is (code+value = ?), please advise on query) = ? 
AND CURDATE() BETWEEN start_date AND end_date AND offerId IN ('12321', '12124')";

Answer 1

刚刚在搜索中找到了一个：

"SELECT id as Id from dbTable WHERE concat(code, value) = ? 
AND CURDATE() BETWEEN start_date AND end_date AND offerId IN ('12321', '12124')"

虽然不确定这是否可以正常工作！

谢谢 ！！！