Correct way of binding in conditions with variables

Question

Correct way of binding in conditions with variables

Danillo Sep '17

Created Sep '17	Last Reply Sep '17	Replies 2	Views 918	Votes 0

Danillo 3.8k

Sep '17

When I try make a consult with a codition like and a variable bind is returning:

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

I try put :name: and anothers way of bind and I get the same error or OP CODE error 58

            $item = Item::find(
                            [
                                    'conditions' => "name LIKE '%?0%' ",
                                    'columns' => 'name',
                                    'limit' => 10,
                                    'bind' => [
                                            $busca
                                    ],
                            ]
                            );

If I put literally works:


                    $item = Item::find(
                            [
                                    'conditions' => "name LIKE '%Os%' ",
                                    'columns' => 'name',
                                    'limit' => 10,
                            ]
                            );

corentin-begne
12.8k

Accepted
answer

edited Sep '17
Sep '17

just dont set the quotes string, the binding is there to do it :

$item = Item::find(
                            [
                                    'conditions' => "name LIKE ?1  ",
                                    'columns' => 'name',
                                    'limit' => 5,
                                    'bind' => [
                                        1 => '%'.$search.'%',  
                                    ],
                            ]
                            );

corentin-begne · Answer 1 · 2017-09-23T14:15:44-07:00

$item = Item::find(
                            [
                                    'conditions' => "name LIKE :name: ",
                                    'columns' => 'name',
                                    'limit' => 10,
                                    'bind' => [
                                            'name'=>'%Os%'
                                    ],
                            ]
                            );

Danillo · Answer 2 · 2017-09-23T14:28:22-07:00

but I wanna pass a variable in the where-like, I try this too:


$item = Item::find(
                            [
                                    'conditions' => "name LIKE ?1  ",
                                    'columns' => 'name',
                                    'limit' => 5,
                                    'bind' => [
                                        1 => "''%'.$search.'%''",  
                                    ],
                            ]
                            );