php - 用单引号将变量括在 implode 函数内

Question

我正在尝试使用 implode 函数内的数组来运行查询。

$dosages = implode(" AND CONCAT(prescription,'-',dosage) =",$doses);
$q=$this->db->query("SELECT account_num 
                     FROM ( 
                     SELECT account_num, CONCAT(prescription,'-',dosage) as script 
                     FROM ci_prescription_history 
                     )a 
                     WHERE script=".implode(' AND script=',$doses));

MySQL 一直提示“‘where 子句’中存在未知列‘Advair’”。我只是想知道是否可以用单引号将变量包装在 implode 函数内，这样当它被解析时，它会像这样读出

SELECT account_num 
FROM ( SELECT account_num, CONCAT(prescription,'-',dosage) as script 
FROM ci_prescription_history 
)a 
WHERE script='Advair-230/21' AND script='Advair-250/50'

Answer 1

是的，您需要将引号添加到查询和 implode() 中，如下所示:

$q=$this->db->query("SELECT account_num 
                 FROM ( 
                 SELECT account_num, CONCAT(prescription,'-',dosage) as script 
                 FROM ci_prescription_history 
                 )a 
                 WHERE script='" . implode("' AND script ='", $doses)) . "'";