problem with joinwith

Salhi · August 21, 2015, 4:16pm

Hi everyone,

i have to table in my database categories(id,name) and products(id,price,name,category_id) and i made a join query in CategoriesController :

public function actionCommand()

{

    &#036;categories = Categories::find()-&gt;joinWith('products')-&gt;all();


    return &#036;this-&gt;render('command', ['categories'=&gt;&#036;categories]);

}

and i display them in the categories\command view :

foreach ($categories as $category){

    echo &#036;category-&gt;name;


  }

now i want to display all the products for a specific category and i dont’t know how.

Please help me if anyone can

softark · August 22, 2015, 1:20am




foreach ($categories as $category){

    echo $category->name;

    foreach ($category->products as $product) {

        echo $product->name;

    }

}

Please look at the guide:

http://www.yiiframework.com/doc-2.0/guide-db-active-record.html#relational-data