Yii relation, array check to see if value exists

Question

I am trying to create a if then statement to only display something if a value in a array exists.

Given two tables Address and Player I have the following relation

'displayAddress' => array(self::HAS_MANY, 'Address', 'PlayerId', 
                        'condition'=>array('IsHome=:home', 'IsWork=:wok'),
                        'params' => array(':hom'=>'Y', ':wok'=>'N')),

Now in a Player view I want to check to see if that player has any addresses where it is only their home and not their work.

I have tried setting a function for the array and checking doing isset in the view as well as in_array() and array_key_exists() but I haven't been able to solve it.

What do you mean by "any addresses where it is only their home and not their work."? Do you want to check if the two addresses are different? — Alfredo Castaneda Garcia
– Alfredo Castaneda Garcia, Commented Feb 4, 2012 at 19:46
Just as is stated in the condition/params of the relation I defined. I want to return a value only if the Player has at least one address that is both Home-Yes and Work-No — enfield
– enfield, Commented Feb 4, 2012 at 22:49

Eirik Hoem · Accepted Answer · 2012-02-06 13:05:20Z

2

The relation you have should / will return only instances where IsHome=Y and IsWork=N. Does this work as expected? If not, try:

'displayAddress' => array(self::HAS_MANY, 'Address', 'PlayerId', 'condition'=>'IsHome=:home AND IsWork=:wok', 'params' => array(':hom'=>'Y', ':wok'=>'N')),

answered Feb 6, 2012 at 13:05

Eirik Hoem

1,3107 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Yii relation, array check to see if value exists

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