Cakephp Using the id's from a find('list') array instead of display value

Question

I'm trying to do this:

$customers = $this->Customer->find('list', array('conditions' => //some code));
$conditions = array('Event.customer_id' => $customers //here's the problem);
$this->Event->find('all', ('conditions' => $conditions));

the $customers find returns:

 array(
       [id1] => "Cust name 1",
       [id2] => "Cust name 2",
       ...
       [idn] => "Cust name n")

while I need that in the $conditions the $customers array should be a list of customer id's to find what I need, instead it uses the display value (es. "Cust name n") so the find returns an empty $events variable.

How is possible to use the array index instead of the array value in a find condition filter?

I know this could be easy but I'm really stuck here.

thanks.

Ilie Pandia · Accepted Answer · 2014-01-28 13:49:56Z

1

You only need to change your code like this:

$customers = $this->Customer->find('list', array('conditions' => //filter));
$conditions = array('Event.customer_id' => array_keys( $customers) );
$this->Event->find('all', ('conditions' => $conditions));

Notice that you pass array_keys( $customers ) instead of simply the array. That will extract the IDs you need in a format that CakePHP can use.

edited Jan 28, 2014 at 13:49

answered Jan 28, 2014 at 11:45

Ilie Pandia

1,83914 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Cakephp Using the id's from a find('list') array instead of display value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related