Breaking News: Grepper is joining You.com. Read the official announcement!

warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens

Viper answered on January 27, 2022 Popularity 9/10 Helpfulness 2/10

answer 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

Comment

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

Popularity 9/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: match sql

Link to this answer
Share Copy Link

Contributed on Jan 27 2022

Viper

0 Answers Avg Quality 2/10

Closely Related Answers

fatal error: uncaught pdoexception: sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens

Comment

The error message "cannot document request fields as the request body is empty" means 
you're trying to describe request fields, but there is no request body in your API request.

Popularity 7/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: whatever match

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

Ben10

0 Answers Avg Quality 2/10

warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens

Contents

More Related Answers

warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens

Closely Related Answers

fatal error: uncaught pdoexception: sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.