PHP PDO: Invalid parameter number

Question

$emptyNumbers has 2 items and $qMarks is " ?,? ". What is the problem?

if(($key = array_search($row['nummer'], $emptyNumbers)) !== false) {
unset($emptyNumbers[$key]);
}
echo sizeof($emptyNumbers)."==>".$qMarks;  // 2 ==> ?,?
$qMarks = str_repeat('?,', count($emptyNumbers)-1) . '?';
$getPlayerData=$db->prepare( "SELECT number,surname,firstname,position,job FROM player WHERE nummer IN ($qMarks)");         
$getPlayerData->execute($emptyNumbers);

--> Error: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

no need to bound any parameter without bounding pdo work as well as — Mayank Vadiya
– Mayank Vadiya, Commented Nov 18, 2015 at 18:56
It would be helpful if you would var_dump($emptyNumbers); and show us that output. — HPierce
– HPierce, Commented Nov 18, 2015 at 19:13

Kewitschka · Accepted Answer · 2015-11-18 19:23:44Z

1

The problem was that I previously unset values from $emptyNumbers and I did not reorder the array so that there were empty values.

if(($key = array_search($row['nummer'], $emptyNumbers)) !== false) {
unset($emptyNumbers[$key]);
//delete the gaps in the array!
$emptyNumbers = array_values($emptyNumbers);
}

$qMarks = str_repeat('?,', count($emptyNumbers)-1) . '?';
$getPlayerData=$db->prepare( "SELECT number,surname,firstname,position,job FROM player WHERE nummer IN ($qMarks)");         
$getPlayerData->execute($emptyNumbers);

answered Nov 18, 2015 at 19:23

Kewitschka

1,6813 gold badges23 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP PDO: Invalid parameter number

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related