Yii2 Join multiple tables

Question

I have a table

CREATE TABLE IF NOT EXISTS `register` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(15) NOT NULL,
  `title` varchar(100) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(50) NOT NULL,
  `gsm` varchar(15) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `birth_date` date NOT NULL,
  `department_id` int(2) NOT NULL,
  `specialization` varchar(150) NOT NULL,
  `level_id` int(2) NOT NULL,
  `reason` varchar(2000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

which have relation with two tables department and level

CREATE TABLE IF NOT EXISTS `level` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

and

CREATE TABLE IF NOT EXISTS `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `department` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

I have made relation in Register model as

public function getDepartments() {
        return $this->hasOne(app\models\Department::className(), ['id' => 'department_id']);
    }

But in view.php (view file )when I use

<?= DetailView::widget([
        'model' => $model,
        'attributes' => [
            'id',
            'student_id',
            'name',
            'email:email',
            'gsm',
            'gender',
            'birth_date',

 'department' ,
            'specialization',
            'level',
            'reason',
        ],
    ]) ?> ,

the department is shown as 'not set'. Also print_r($model);?> shows [department] =>(i.e, blank) . What is the issue here ?

Use ['attribute' => 'department_id', 'value' => $model->departments->department]. if not then show your query. — Insane Skull
– Insane Skull, Commented Jan 7, 2016 at 9:20
Yes , the error is pointing to public function getDepartments() { return $this->hasOne(app\models\Department::className(), ['id' => 'department_id']); } — user7282
– user7282, Commented Jan 7, 2016 at 9:36

Insane Skull · Accepted Answer · 2016-01-07 09:46:48Z

2

Use $model->relationName->field_name:

[
'attribute' => 'department_id', 
'value' => $model->departments->department
],

And add department model in register model.

answered Jan 7, 2016 at 9:46

Insane Skull

9,3619 gold badges49 silver badges66 bronze badges

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

Comments

anruence · Accepted Answer · 2017-04-06 04:46:23Z

0

better change getDepartments to getDepartment as this is a hasOne relation.

[
  'attribute' => 'department_id', 
  'value' => isset($model->department) ? $model->department->department : ''
]

answered Apr 6, 2017 at 4:46

anruence

1

Collectives™ on Stack Overflow

Yii2 Join multiple tables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related