PHP Iplode 获得 IN 查询的预期结果

Question

请帮助我怎样才能得到我预期的结果，在此先感谢并抱歉我的英语不好。

PHP:

  $dog = implode(',', $data['dogbreed']);
  $query .= "AND `dog_breeds`.`id` IN ('".$dog."')";

输出:

AND `dog_breeds`.`id` IN ('9,31')

预期结果:

AND `dog_breeds`.`id` IN ('9','31')

数组:

([0] => 9 [1] => 31)

Answer 1

试试这个:-

$dog = implode("','", $data['dogbreed']);
$query .= "AND `dog_breeds`.`id` IN ('".$dog."')";