writing query in yii2 with multiple where conditions

Question

query in plain php is

$p = "SELECT * FROM followusers WHERE (follower='$followed1 and
    followed='$follower1') or (follower='$follower1' and 
    followed='$followed1')"

i have written query in yii2 is

 $y = Followusers::find()->where(['follower' => $userid ] and
 ['followed' => $conid])->orwhere(['followed' => $userid ] and
 ['follower' => $conid])-> all();

but i m not getting the required result for the query in yii2

Insane Skull · Accepted Answer · 2016-07-09 12:53:03Z

2

Try this way:

Followusers::find()->where(['follower' => $userid])    
   ->andWhere(['followed' => $conid])
   ->orwhere(['AND',
        ['followed' => $userid], 
        ['follower' => $conid]
    ])
   -> all();

answered Jul 9, 2016 at 12:53

Insane Skull

9,3619 gold badges49 silver badges66 bronze badges

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

1 Comment

Denis Alexandrov Over a year ago

Yeah, perhaps it's more correct answer since I haven't coded in Yii for a while :)

Fabrizio Caldarelli · Accepted Answer · 2016-07-09 12:55:34Z

0

If followusers table model is FollowUsers (in the current namespace, otherwise you have to prefix with namespace), you can

$data = FollowUsers::find()
->where(['AND', 'follower='.$followed1, 'followed='.$follower1])
->orWhere(['AND', 'follower='.$follower1, 'followed='.$followed1])
->all();

Otherwise, you can usign parameters:

$data = FollowUsers::find()
->where('(follower=:followed1 AND followed=:follower1) OR (follower=:follower1 AND followed=:followed1)', [':followed1' => $followed1, ':follower1' => $follower1])
->all();

answered Jul 9, 2016 at 12:55

Fabrizio Caldarelli

3,00813 silver badges14 bronze badges

Comments

Denis Alexandrov · Accepted Answer · 2016-07-09 12:58:57Z

0

It seems like you have some syntax errors in your code, try formatting it as follows:

$y = Followusers::find()
     ->where(['follower' => $userid, 'followed' => $conid])
     ->orwhere(['followed' => $userid, 'follower' => $conid])
     ->all();

edited Jul 9, 2016 at 12:58

answered Jul 9, 2016 at 12:52

Denis Alexandrov

18510 bronze badges

Collectives™ on Stack Overflow

writing query in yii2 with multiple where conditions

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related