How to get full name in gridview in yii2?

Question

Yii

Tell me, here's how to get the full name by ID from another table and display it in the gridview?

Answer 1

If I understand you correctly, then something like this:
Let's say you have Books and Authors models. And you want to display a list of books with the name of the author in the GridView.

<?= GridView::widget([
                'dataProvider' => $dataProvider,
                'columns' => [
                    ['class' => 'yii\grid\SerialColumn'],
                    'title',
                    'author' => [
                        'class' => \yii\grid\DataColumn::className(),
                        'format' => 'html',
                        'value' => function ($model, $index, $widget) {
                            return $model->author->name ;
                        },
                    ],
                   // и т.п. ...

And to access $model->author->... you must set up a relationship between models. In our example, in the Books model, we need to add something like this:

public function getAuthor() {
        return $this->hasOne(Authors::className(), ['id' => 'author_id']);
    }