SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Question

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Conner97 Oct '17

Created Oct '17	Last Reply Oct '17	Replies 2	Views 3588	Votes 0

Conner97 4.0k

Oct '17

Hey,

i get, if i use to bind a variable to a placeholder at Prepared Statements everytime this Error:

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

I have looked after helpful information which can solve this Problem, but i didnt't find anything. And if i find something, this didnt't solved this problem.

If i debug my Code at the Parameters are the value of the Parameter in the url like "Ha". The Error is showing at the DB-Query.

My Code:


                    $name = $this->request->get("name");

                    $parameters = [
                        "name" => $name
                    ];

                    $foundedNames = Name::findFirst(
                        [
                            "name LIKE ' % :name: % ' ",
                            "bind" => $parameters
                        ]
                    );

I hope you can help me at solve this Problem.

Conner

Wojciech Ślawski · Answer 1 · 2017-10-21T06:19:01-07:00

Just do it like:


  $parameters = [
                    "name" => "%{$name}%"
                ];

$foundedNames = Name::findFirst(
                    [
                        "name LIKE :name:",
                        "bind" => $parameters
                    ]
                );

Dylan Anderson · Answer 2 · 2017-10-23T10:03:42-07:00

To further explain - you cannot put a bound parameter in a like statement, surrounded by '%' - the sql compiler doesn't like that. So, you need to add the '%' to the value that gets bound.