/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 vote181 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote221 views1 answer
Sql get count without group by
SQL
1 vote213 views1 answer
Sql how to duplicate a table
SQL
0 vote230 views2 answers
Insert data mysql with cmd
SQL
2 votes215 views1 answer
Where clause for child record apex
SQL
1 vote218 views1 answer
Postgres left join
SQL
2 votes206 views4 answers
2nd highest salary in mysql
SQL
2 votes196 views1 answer
SQL column name Postgre
SQL
0 vote278 views1 answer
How to check common records in 2 table
SQL
1 vote225 views1 answer
Mysql count all table rows
SQL