How to pull data from two tables in yii2?

Question

Yii

Hello! There are two related tables production (id, id_category, title, status) and image (id, id_production, imagepath), where each record from production can correspond to several records from image. Next, I try to display pictures from image those that correspond to production with the status status = 1, and the picture should be displayed for each production along with the caption title:

$dataProvider = new ActiveDataProvider([
    'query' => Production::find()
            ->joinWith('image')
      ->where(['image.id_production' => 'id'])
            ->where(['status' => 1])
            ->orderBy('id DESC')->limit(12),
    
]);


echo ListView::widget([
    'dataProvider' => $dataProvider,
    'itemView' => '_workitem',
    'summary' => false,
  'emptyText' => '',
  
]);

In _workitem, this is the code:

<?php
use yii\helpers\Html;
?>

<div class="col-xs-12 col-sm-6 col-md-3 isotope-item <?= Html::encode($model->id_category) ?>">
    <div class="image-box">
        <?php echo Html::a(Html::img("@frontendWebroot/uploads/images/thumbs/$model->imagepath"), "@frontendWebroot/uploads/images/$model->imagepath", ['rel' => 'fancybox', 'title'=>$model->title]); ?>
                <div class="overlay-container">                                       
                    <a class="overlay" src="">								
                      <i class="fa fa-search-plus"></i>
                      <span><?= Html::encode($model->title) ?></span>		
                    </a>										
                </div>									
    </div>								
</div>

As a result, I get the error Getting unknown property: frontend\models\Production::imagepath, and so on with any parameter from the image, but if I substitute a parameter from the production table, it displays this parameter. From which I conclude that this join of tables takes into account only the parameters from the production table, and I need data from both tables. How to do it? point me in the right direction)

Answer 1

I don’t see the point here for join. We need to make a connection in the production model

public function getImages(){
   return $this->hasMany(Images::classname(),['id_production'=>'id']);
}

Next, the date provider will look like this

$dataProvider = new ActiveDataProvider([
    'query' => Production::find()
            ->with('images')
            ->where(['status' => 1])
            ->orderBy('id DESC')->limit(12) //обычно лимит задает Pager, но Вам виднее
]);

accordingly, you could take the image path in view _workitem like this:
but this is with hasOne, and you have hasMany, therefore

foreach($model->images as $image){
echo $image->imagepath;
}
//или например взять первый объект из массива объектов
echo $model->images[0]->imagepath;

Answer 2

Thanks, the issue was resolved by a simple replacement with this line echo $model->images[0]->imagepath; I had an array displayed there, and I needed just the first element. But join still left, I don’t know if it’s necessary, but it seems to work.