How to do double select WHERE with DAO in Yii2?

Question

MySQL

There is a controller

public function actionIndex()
    {
$accountident = Yii::$app->user->identity->account;
        $users = $db->createCommand("SELECT * FROM transactions WHERE sender='$accountident' AND payee='$accountident'")->queryAll();
        
        $dataProvider = new ArrayDataProvider([
            'allModels' => $users,
        ]);
        
        return $this->render('index', [
            'dataProvider' => $dataProvider,
        ]);
 }

C AND doesn't output anything for some reason

Answer 1

This means that there is no entry in the transactions table that you want to find
. In general, it is better to write queries in Yii in this form:
$users = $db->createCommand()
->select('*')
->from('transactions')
->where ('sender=:sender', array('sender' => $accountident))
->andWhere('payee=:payee', array('payee' =>$accountident))
->queryAll();
It will be safer.)