Model find with IN operator

Question

Model find with IN operator

gvuuren24 Jun '20

Created Jun '20	Last Reply Jul '20	Replies 1	Views 145	Votes 0

gvuuren24 810

Jun '20

Hi Guys, can someone please give me a example of binding a array for a IN operator in find. eg.

$robots = Robots::find(
            [
                'conditions' => 'type_id IN :types:',
                'bind'       => [
                    "type_ids" => [1,2,3],
                ]
            ]
        );

The above gives SQL syntax errors.

I have tried this as well

$robots = Robots::find(
            [
                'conditions' => 'type_id IN (:types:)',
                'bind'       => [
                    "type_ids" => implode(",", [1,2,3]),
                ]
            ]
        );

but I still get errors

Alistar84
1.1k

Accepted
answer

Jun '20

Have you already tried this?

$robots = Robots::find(
            [
                'conditions' => 'type_id IN ({types_ids:array})',
                'bind'       => [
                    "type_ids" => [1,2,3]
                ]
            ]
        );

gvuuren24 · Answer 1 · 2020-06-15T06:35:58-07:00

I found a old post https://forum.phalcon.io/discussion/3469/modelfindcol-in-with-bind Is there a better way in phalcon 3.4 or 4.0?

gvuuren24 · Answer 2 · 2020-06-15T06:56:52-07:00

gvuuren24
810

in reply to

Alistar84

Jun '20

Awesome it works, thanks a lot.