Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in

by

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++
}

More Related Contents:

  1. which is better every user have a table or just a row [closed]
  2. Echo in an image
  3. PHP – Change value y,n in database [closed]
  4. Good PHP ORM Library?
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. Many-to-many relationships examples
  7. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  8. Get the Last Inserted Id Using Laravel Eloquent
  9. How to upload images into MySQL database using PHP code
  10. MySQL check if a table exists without throwing an exception
  11. Maximum execution time in phpMyadmin
  12. How to get the total number of rows of a GROUP BY query?
  13. Mysql No connection could be made because the target machine actively refused it
  14. Replacing mysql_* functions with PDO and prepared statements
  15. Is there any way to check the performance of mysql Indexing
  16. Proper Repository Pattern Design in PHP?
  17. phpmyadmin automatic logout time
  18. retrieve data from db and display it in table in php .. see this code whats wrong with it?
  19. Dealing with timezones in PHP
  20. PHP and Microsoft Access database – Connection and CRUD
  21. MongoDB updating fields in nested array
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Fatal error: Call to undefined function mysqli_result()
  24. Laravel nested relationships
  25. Why I am getting an error when using w3school tutorial? [duplicate]
  26. Selecting all fields except only one field in mysql [duplicate]
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. looping a SQL insert statement with dates
  29. Auto Increment skipping numbers?
  30. How to get last inserted id from table MySQL [duplicate]

Leave a Comment