Printing data with condition equal to array of ids using cake php

Question

I'm trying to print the data from that query where the bstockBooksTableResearchIds is equal array(1,2,3) , but i'm getting error showing in bellow :

$bstockBooksTableResearches = $this->BstockIn->BstockResearchs->find('list', [
            'conditions' => ['BstockResearchs.id' => $bstockBooksTableResearchIds],

                ]) ;

That's not an error, that's the dump of a query object, as the (help) key contents indicate. — ndm
– ndm, Commented Oct 3, 2017 at 11:17
Possible duplicate of How to create a `IN` clause in CakePHP query? — ndm
– ndm, Commented Oct 3, 2017 at 11:17

tarikul05 · Accepted Answer · 2017-10-04 02:21:36Z

1

you should add IN in your conditions so your code will be

$bstockBooksTableResearches = $this->BstockIn->BstockResearchs->find('list', [
            'conditions' => [
                'BstockResearchs.id IN' => $bstockBooksTableResearchIds
                ]
            ]) ;

answered Oct 4, 2017 at 2:21

tarikul05

1,9131 gold badge16 silver badges26 bronze badges

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

Comments

SNG · Accepted Answer · 2017-10-04 05:03:40Z

0

try this:

 $bstockBooksTableResearches = $this->BstockIn->BstockResearchs->find('list', array(
                'conditions' =>array (
    'BstockResearchs.id' => $bstockBooksTableResearchIds),

                    )) ;

changes: IN clause should be in array.

edited Oct 4, 2017 at 5:03

answered Oct 3, 2017 at 11:22

SNG

3554 silver badges16 bronze badges

3 Comments

tarikul05 Over a year ago

square braces are not allowed where it was said ?? @Sucharitha

SNG Over a year ago

@tarikul05 : In my case for direct values square braces are working but in variables it raised error. so i thought it may not work.

tarikul05 Over a year ago

it's may be your php version problem, PHP doc says As of PHP 5.4 you can also use the short array syntax, which replaces array() with []. so it allow for all. You can't say not allowed.

Collectives™ on Stack Overflow

Printing data with condition equal to array of ids using cake php

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related