Yii2 Basic sql query in view

Question

I'm trying to get the user profile image of the author of the content inside the view , my view is channel I created but I get this error on my view

Undefined variable: queryAvatar

on my view I did

//Yii2 View code

use yii\helpers\Html;
use yii\widgets\DetailView;

/* @var $this yii\web\View */
/* @var $model app\models\Channel */

$this->title = $model->Channel_name;
?>
<div class="channel-view">

    <h1><?= Html::encode($this->title) ?></h1>
    <div><?php echo  $queryAvatar; ?></div> // THE LINE I ADD

    <?php if($model->uid == Yii::$app->user->id):?>
    <p>
        <?= Html::a('Update', ['update', 'id' => $model->Channel_id], ['class' => 'btn btn-primary']) ?>
        <?= Html::a('Delete', ['delete', 'id' => $model->Channel_id], [
            'class' => 'btn btn-danger',
            'data' => [
                'confirm' => 'Are you sure you want to delete this item?',
                'method' => 'post',
            ],
        ]) ?>
    </p>
    <?php endif;?>
</div>

and on my controller I created this function

//function on my controller

 public function actionChannel($id)
        {
            $cchannel = new Channel();
            $queryAvatar = (new \yii\db\Query())

            ->select(['uavatar'])
            ->from('userlogin')
            ->where(['uid' => $cchannel->uid])
            ->All();

            return $this->render('channel', [
                'model' => $this->findModel($id),
                'queryAvatar '=> $queryAvatar ,
            ]);
        }

In your code you define $cchannel as new model, so it is empty and $cchannel->uid are empty. — Sfili_81
Because the query return empty value , the where clause is something like that : WHERE uid = '' — Sfili_81
You must define $cchannel = $this->findModel($id) instead of $cchannel = new Channel(); — Sfili_81

Sfili_81 Sfili_81 · Accepted Answer · 2017-12-28T10:30:42

in your controller you define an empty model so your $cchannel->uid is empty.

You must define first your model like this

 public function actionChannel($id)
        {
            $cchannel = $this->findModel($id);
            $queryAvatar = (new \yii\db\Query())

            ->select(['uavatar'])
            ->from('userlogin')
            ->where(['uid' => $cchannel->uid])
            ->All();

            return $this->render('channel', [
                'model' => $cchannel ,
                'queryAvatar '=> $queryAvatar ,
            ]);
        }

Yii2 Basic sql query in view

2 Answers