How do I delete rows in Yii2?

Question

I want to delete a row in database based on some condition. I tried like this

$fanclub        =   FanClub::find()->where(['user_id'=>$userid])->
            andwhere(['crew_member_id'=>$id])->one();
            if($fanclub)
            {
                $fanclub->delete();
            }

is this the right way to delete a row in database?

Answer 1

There you are getting record first, but you can do it directly

$fanclub = FanClub::find()
  ->where(['user_id'=>$userid])
  ->andwhere(['crew_member_id'=>$id])
  ->one()
  ->delete();