hello have 2 tables schead , scstock joined , put in array looks this.
return static::find() ->select('scstock.*') ->leftjoin('schead', 'schead.trno = scstock.trno') ->where([ 'schead.curriculumcode' => $currcode, 'schead.terms' => '1st', 'schead.styear' => 1]) ->asarray() ->all();
now when go view can't access columns in schead table in case index section
see screenshot below:
the question how access columns in schead table in array index? , did in view
<?php foreach($firstyearfirstterm $subjects):?> <?= $subjects['section']?> <?php endforeach; ?>
but resulted in screenshot below. suggested when trying output section.
foreach($subjects $subject){ echo $subject->schead->section; }
but got this.
i need trying solve this, new yii framework.
you selecting columns scstock
table. use following select statement:
->select(['scstock.*', 'schead.*'])
Comments
Post a Comment