/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

0 vote337 views1 answer
Postgresql print variable
SQL
15 votes337 views2 answers
Sql order by multiple columns
SQL
6 votes342 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote345 views7 answers
Les jointures sql server
SQL
7 votes388 views1 answer
Oracle pagination query rownum
SQL
0 vote361 views1 answer
Mariadb search columns
SQL
1 vote319 views1 answer
Select not matching data from two tables
SQL
0 vote387 views1 answer
Postgres list tables and row counts
SQL
0 vote354 views1 answer
My sql data file extention
SQL
17 votes368 views6 answers
What is cursor in sql server with example
SQL