/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

1 vote195 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
1 vote194 views1 answer
Sql how to replace full stop
SQL
2 votes225 views2 answers
Convert_tz mysql
SQL
0 vote208 views1 answer
Mysql get only the field names in a table
SQL
1 vote187 views1 answer
Mysql select another database
SQL
3 votes131 views2 answers
Mysql sum with condition
SQL
0 vote189 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote195 views1 answer
Copied text from internet not inserting in mysql
SQL
5 votes217 views1 answer
Get column name sql server
SQL
1 vote218 views3 answers
How to create a table structure from another table in mysql
SQL