使用WHERE子句將數(shù)組傳遞給查詢給定一個(gè)ID數(shù)組$galleries = array(1,2,5)我希望有一個(gè)SQL查詢，它在WHERE子句中使用數(shù)組的值，如下所示：SELECT *FROM galleriesWHERE id = /* values of array $galleries... eg. (1 || 2 || 5) */如何生成這個(gè)查詢字符串以便與MySQL一起使用？
4 回答
躍然一笑
TA貢獻(xiàn)1826條經(jīng)驗(yàn) 獲得超6個(gè)贊
使用PDO：[1]
$in = join(',', array_fill(0, count($ids), '?'));$select = <<<SQL
SELECT *
FROM galleries
WHERE id IN ($in);SQL;$statement = $pdo->prepare($select);$statement->execute($ids);使用MySQLi [2]
$in = join(',', array_fill(0, count($ids), '?'));$select = <<<SQL
SELECT *
FROM galleries
WHERE id IN ($in);SQL;$statement = $mysqli->prepare($select);$statement->bind_param(str_repeat('i', count($ids)), ...$ids);
$statement->execute();$result = $statement->get_result();使用SQL IN()運(yùn)算符檢查給定列表中是否存在值。
expr IN (value,...)
()?$ids:
$in = join(',', array_fill(0, count($ids), '?'));$select = <<<SQL
SELECT *
FROM galleries
WHERE id IN ($in);SQL;$select
SELECT *FROM galleries WHERE id IN (?, ?, ?)
?
使用 IN()帶字符串的運(yùn)算符
str_repeat('i',str_repeat('s',
[1]:
[2]:
MMMHUHU
TA貢獻(xiàn)1834條經(jīng)驗(yàn) 獲得超8個(gè)贊
$matches = implode(',', $galleries);SELECT *FROM galleries WHERE id IN ( $matches )
添加回答
舉報(bào)
0/150
提交
取消