请问php pdo 执行 in 数组查询sql代码怎么写？
网友回复
<?php
$pdo = new \PDO('mysql:host=localhost;dbname=guest;port=3306', 'guest', 'p6yhG8iDRMNxdJ9w');
// IN 查询预处理
$param2 = [2,3,4];
$prepare = rtrim( str_pad('?', 2 * count($param2), ',?') , ',');
$sql2 = "select * from User where id in($prepare)";
$stmt2 = $pdo->prepare($sql2);
if ($stmt2->execute($param2)) {
$res2 = $stmt2->fetchAll(\PDO::FETCH_ASSOC);
print_r($res2);
}
by thinkfuture
我知道答案，我要回答
私活外包
最新提问
