Products from subcategories

[barrosa]

Hi!

 

I am creating new module for work in category.tpl

 

I need to extract the id of actual category and get products that are in subcategories of this parent category.

 

Thank you

[NemoPS]

Hi There,

If you only want those in the first child (or children) and not further subcategories, do this

 

$id_category = (int)Tools::getValue('id_category');

 

//get subcategories IDS

$sql = 'SELECT id_category

FROM '._DB_PREFIX_.'category

WHERE id_parent = '.$id_category.';

$subcategories = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

 

Now create a string out of that result (if not empty!), and use another query to get products from category_product where id_category IN that list

 

Hope this helps

 

Fabio