php - 如何在sql查询中使用动态数组

Question

我的查询:

SELECT MAX(num)
FROM (SELECT nomInteretUser,idUser,COUNT(nomInteretUser) as num
      FROM userInteret
      WHERE nomInteretUser IN ('piano','flute','chien') GROUP BY idUser
     )

目标是将 IN ('piano','flute','chien') 更改为动态数组喜欢

SELECT nomInteretUser, idUser, COUNT(nomInteretUser) as num
FROM userInteret
WHERE nomInteretUser IN ($array)
GROUP BY idUser

注意:$array 是一个包含兴趣列表的数组

Answer 1

使用内爆()。试试下面的代码。您需要将数组转换为字符串。所以在这里我们将用逗号分隔它并用引号分隔它，例如 ',' 字符串，并在查询中使用它。

$array =array('piano','flute','chien');

$string = implode("','", $array);

$query = "SELECT nomInteretUser, idUser, COUNT(nomInteretUser) as num
FROM userInteret
WHERE nomInteretUser IN ('".$string."')
GROUP BY idUser";

查看在线演示:Click Here