MySQL 준비 문에서 가변 크기 IN 절을 어떻게 처리할 수 있나요?

// Define the query with a placeholder IN clause
$sql = 'SELECT age, name FROM people WHERE id IN (%s)';

// Get the number of parameters in the IN clause
$parmcount = count($parms);

// Create a placeholder string for the IN clause (e.g., "?, ?, ?, ?")
$inclause = implode(',', array_fill(0, $parmcount, '?'));

// Format the query with the dynamic IN clause
$preparesql = sprintf($sql, $inclause);

// Prepare and execute the statement
$st = $dbh->prepare($preparesql);
$st->execute($parms);

$st = $dbh->prepare(sprintf('SELECT age, name FROM people WHERE id IN (%s)',
    implode(',', array_fill(0, count($parms), '?'))));
$st->execute($parms);