What is the correct way to substitute a value into ... IN (?) ... using the execute() method?

Question

PHP

Task:
Extract rows with a specific id value from the database, but the nuance is that sometimes you need to extract several rows from the database.
For example, those whose id is equal to 100, 101 or 102.
Constructions ... WHERE id = ? not enough.

My decision:

$sql = 'SELECT * FROM table_name WHERE id IN (?)';
$query = $pdo->prepare($sql);
$query->execute([100, 101, 102]);
$result = $query->fetchAll(PDO::FETCH_ASSOC);

Also tried like this:

$sql = 'SELECT * FROM table_name WHERE id IN (?)';
$query = $pdo->prepare($sql);
$query->execute(array(100, 101, 102));
$result = $query->fetchAll(PDO::FETCH_ASSOC);

But none of the options work.
I have been working with php and sql for more than 5 months, but I have never encountered such a problem.

PS: the connection to the db is done correctly

Answer 1

https://stackoverflow.com/a/14767651/285587