CakePHP how to get multiple rows by array of ID's

Question

I would like to pull from database multiple rows, according to a list of array of ID's.

In some other frameworks there seem to be something like "WHERE_IN", but not here.

Can someone tell me how to do it?

I would like to know how to do that through the find() or read() (or any other cakephp function) and NOT build a query manually, since I want all data to be escaped and secure.

thank you

Thank you for your question, i was preparing my self to code some monstrosity before i googled this :D. — Vladimir Bozic
– Vladimir Bozic, Commented Oct 17, 2013 at 18:39

OGHaza · Accepted Answer · 2014-01-22 12:26:03Z

26

According to "Complex Find Functions" (third example) this should work:

$this->YourModel->find('all', array(
    'conditions' => array(
        "YourModel.id" => array(1, 2, 3, 4)
    )
));

edited Jan 22, 2014 at 12:26

OGHaza

4,7957 gold badges26 silver badges30 bronze badges

answered Jul 25, 2011 at 17:27

vstm

12.5k1 gold badge53 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Martin Over a year ago

to do the same but with id different of array?

vstm Over a year ago

@Martin: thank you for the question. I'm not sure what you mean - do you want to select records whose IDs are not in the array like the NOT IN-operator? Or do you want to select using another field than id

Martin Over a year ago

I already solved the doubt, thanks anyway stackoverflow.com/questions/14508682/…

ᴍᴇʜᴏᴠ Over a year ago

On CakePHP 3 this throws InvalidArgumentException: Cannot convert value to integer

Joe C · Accepted Answer · 2021-12-12 23:27:41Z

1

It looks like in the newer CakePHPs you need to specify 'IN'. This solves aexl question.

$this->YourModel->find('all', [
    'conditions' => [
        "YourModel.id IN" => [1, 2, 3, 4]
    ]
]);

answered Dec 12, 2021 at 23:27

Joe C

2,8444 gold badges33 silver badges39 bronze badges

Collectives™ on Stack Overflow

CakePHP how to get multiple rows by array of ID's

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related