[ACCEPTED]-PDO with "WHERE... IN" queries-pdo

Accepted answer

Score: 36

Since you can't mix Values (the Numbers) with 3 control flow logic (the commas) with prepared 2 statements you need one placeholder per 1 Value.

$idlist = array('260','201','221','216','217','169','210','212','213');

$questionmarks = str_repeat("?,", count($idlist)-1) . "?";

$stmt = $dbh->prepare("DELETE FROM `foo` WHERE `id` IN ($questionmarks)");

and loop to bind the parameters.

Score: 8

This may be helpful too:

https://phpdelusions.net/pdo#in

$arr = [1,2,3];
$in  = str_repeat('?,', count($arr) - 1) . '?';
$sql = "SELECT * FROM table WHERE column IN ($in)";
$stm = $db->prepare($sql);
$stm->execute($arr);
$data = $stm->fetchAll();

0

Source: stackoverflow.com

More Related questions

What is the best way to bind decimal / double / float values with PDO in PHP?

Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?

Create SQLite database in memory

Is there a way to fetch associative array grouped by the values of a specified column with PDO?

escaping column name with PDO

php pdo get only one value from mysql; value that equals to variable

PDO: How to check if connection is active, for real?

Fatal error: Call to undefined method PDO::close()

PDO MySQL: Insert multiple rows in one query

PDO - get current inserted ID

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.