Phalcon: How can I use find() with IN() from sql?

240 Views Asked by At

I've got a Model "Member" and selected (via form) multiple Member-IDs.

Now I want to do something like this:

SELECT * FROM member WHERE id IN($idsFromForm)

Is this possible with Member::find()? If yes then how can I do that?

2

There are 2 best solutions below

0
On BEST ANSWER

You can use Phalcon\Mvc\Model\Criteria

$members = Member::query()->inWhere('id', $idsFromForm)->execute();
2
On
Member::find(array('member IN ('.$idsFromForm.')'));