如何查找与数组中字符串匹配的字符串 - How to look for a String that match one in an array

How to look for a String that match one in an array

我必须制作一个SQL命令，在数据库表中查找与我的数组中包含的字符串匹配的字符串。

//this is my array
$liste_des_themes=array("Préfectures et sous-préfectures","Mairie","Banque");
$stmt = $this->db->prepare('SELECT * FROM etablissements where type IN $liste_des_themes');//i tried this but seems not working
$stmt->execute();
$stmt->bind_result($id, $libelle);
while ($stmt->fetch()) {
    echo "$id $libelle<br/>";
}
$stmt->close();

您需要以正确的格式创建IN列表:

$liste_des_themes=array("Préfectures et sous-préfectures","Mairie","Banque");
$in_list = "'".implode("','", $liste_des_themes)."'";
$stmt = 
 $this->db->prepare('SELECT * FROM etablissements where type IN ('.$in_list.')');