/SQL/Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens

Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens

It looks like you're trying to build a long(?) series of 'or' comparisons: if (x=1) or (x=2) or (x=3) etc.... You may find it easier to replace it with:

$cnt = count($options);
if ($cnt > 0) {
   $placeholders = str_repeat(', ?', $cnt - 1);
   $sql .= 'WHERE '`prods_empresas`.`produtos_codigo` IN (?' . $placeholders . ')';
}
which, if there were 5 options, would give you

 WHERE prods_empresas.produtos_condigo IN (?, ?, ?, ?, ?)
And then do the values binding with:

$pos = 1;
foreach ($options as $option) {
   $statement->bindValue($pos, $option->getId());
   $pos++
}

Source: stackoverflow.com

Similar codes

7 votes329 views3 answers
How ot change name of column mysql
SQL
24 votes273 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote340 views2 answers
Nodejs mysql convert to plain object
SQL
-1 vote341 views2 answers
Create temporary table sql
SQL
0 vote321 views1 answer
Mysql_union
SQL
0 vote311 views1 answer
H2 auto increment and unique
SQL
25 votes343 views6 answers
Import mysql database command line
SQL
2 votes307 views1 answer
Get first 3 letters name in sql
SQL
0 vote352 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote313 views1 answer
Postgres count string length
SQL