/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 vote185 views3 answers
SELECT * FROM
SQL
0 vote214 views1 answer
Sql tablo sp
SQL
0 vote219 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote195 views1 answer
UseSqlServer no definition
SQL
8 votes180 views1 answer
Script to add datafile to tablespace
SQL
0 vote179 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote176 views1 answer
Renommer table sql
SQL
2 votes180 views2 answers
Postgres add column integer
SQL
0 vote196 views1 answer
Sql query inline if
SQL
0 vote175 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL