Display total products for categories

Code: Select all

$results = $database->getRows("select * from category c left join category_description cd on (c.category_id = cd.category_id) left join image i on (c.image_id = i.image_id) where c.parent_id = '" . (int)(!$request->get('path') ? '0' : (int)end(explode('_', $request->get('path')))) . "' and cd.language_id = '" . (int)$language->getId() . "' order by sort_order");
foreach ($results as $result) {
   // count products in category inserted by Fido-X
   $num_products = $database->countRows("select * from product_to_category where category_id = '" . (int)$result['category_id'] . "'");
   // end of insert
   $category_data[] = array(
      // inserted by Fido-X
      'product_count' = > $num_products,
      // end of insert
      'name'  => $result['name'],
      'description' => html_entity_decode($result['description']),
      'href'  => $url->href('category', FALSE, array('path' => ($request->get('path')) ? $request->get('path') . '_' . $result['category_id'] : $result['category_id'])),
      'thumb' => $image->resize($result['filename'], $config->get('config_image_width'), $config->get('config_image_height'))
   );
}
$view->set('categories', $category_data);
// inserted by Fido-X
$view->set('text_count', $language->get('text_count'));
// end of insert

Code: Select all

$_['text_count'] = 'Products in Category: ';

Code: Select all

<?php echo $text_count; ?><?php echo $category['product_count']; ?>

Code: Select all

$num_products = $database->countRows("select * from product_to_category p2c left join product p on p2c.product_id = p.product_id where p.status = '1' and p2c.category_id = '" . (int)$result['category_id'] . "'");