How To Fetch All Images Of A Product On The Category Page

[rigids]

I am getting trouble while fetching all images for a product on the category page. For eg :-

i have a product named "abc". There are 3 images for this product. one is cover image and two other images. I want to display all the three images on the category page, currently it only displays the cover image.

[Medea Web Agency]

I've the same question, anyone knows how to fix?

[karthiiiiiiiiiik]

hi,

I am also searching for same thing has any one has got the solution.... ?

[vekia]

in this case it's necessary to modify controller (categoryController)

you need to add there function with sql query to database to get product images, for example:

public static function getImagesByProductID($id) {

    return Db::getInstance()->ExecuteS('SELECT `id_image` FROM `'._DB_PREFIX_.'image` WHERE `id_product` = '.(int)($id_product));

}

 

then in .tpl file you can use foreach loop on function Category::getImagesByProductID(Tools::getValue('id_product'))

[karthiiiiiiiiiik]

hi vekia,

i have added the code to categorycontroller, but in tpl file how can i show up the images using the function you have said ?