Get mutiple multiple rows value base on array id IN CAKE PHP

Question

i want to get multiple rows value base on multiple id value and i m getting id in array.

id output array

pr($currentSessionData['Category']);
Array
(
    [Category] => Array
        (
            [0] => 1
            [1] => 24
            [2] => 25
        )

)

Below code for getting rows value but not working

$this->YourModelName->find('all', array(
            'conditions' => array(
                        "YourModelName.id" => array($currentSessionData['Category'])
                )
));

your code is pretty much correct.You need to check what query is generated by your find query. — Garry
– Garry, Commented Jan 31, 2014 at 10:24

Yogesh Saroya · Accepted Answer · 2014-01-31 10:31:41Z

3

dont use array() .eg array($currentSessionData['Category'])

Try this.

$cat_ids=array(0=>10,1=>51,2=>51,3=>6561,4=>1,5=>561);

$this->YourModelName->find('all', array(
            'conditions' => array(
                        "YourModelName.id" => cat_ids  /*dont use array() */
                )
));

i hope its helpful for you :)

answered Jan 31, 2014 at 10:31

Yogesh Saroya

1,5155 gold badges25 silver badges57 bronze badges

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

2 Comments

thecodedeveloper.com Over a year ago

yes u r right, could you tell me how can i remove category index in cakephp

Yogesh Saroya Over a year ago

$ar['Category']= array(0=>12,1=>13452,2=>1452,3=>12544); if(!empty($ar['Category'])) { foreach ($ar['Category'] as $k=>$v) { $arr[]=$v; } } pr($arr);

Collectives™ on Stack Overflow

Get mutiple multiple rows value base on array id IN CAKE PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related