Calling a second image URL to realize image change function on mouseover in Magento

Calling a second image URL to realize image change function on mouseover in Magento

September 30, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Calling a second image URL to realize image change function on mouseover in Magento

Realizing Image Change Function on Mouseover in Magento

Hello Liang,

I appreciate your question about implementing an image change function on mouseover for product images in the category grid view of Magento.

The Challenge

To achieve this, we need to determine if a second image exists for each product and then call out its URL dynamically. Since you’re not a coder by profession, I’ll provide a step-by-step guide using simple PHP code that should help you accomplish this task.

Step 1: Determine If a Second Image Exists

Magento stores multiple images for products in the catalog_product_entity_varchar table where attribute_id = 83. This attribute corresponds to the “additional_images” field. To check if additional images exist, we can query this table:

$additionalImages = $this->getAdditionalImages($_product);

Here’s a simple function that retrieves additional images:

private function getAdditionalImages($product)
{
    $images = [];
    $connection = Mage::getSingleton('core/resource')->getConnection('core_read');
    $select = $connection->select()
        ->from('catalog_product_entity_varchar')
        ->where('entity_id = ?', (int)$product->getId())
        ->where('attribute_id = 83')
        ->limit(1);
    $result = $connection->fetchAll($select);

    if (!empty($result)) {
        foreach ($result as $image) {
            $images[] = (string)$image['value'];
        }
    }

    return $images;
}

Step 2: Dynamically Call Out the URL of the Second Image

Once we have determined that a second image exists, we can call out its URL using the Mage_Catalog_Model_Product_Image helper:

if (count($additionalImages) > 0) {
    $secondImageUrl = Mage::helper('catalog/image')->init($_product, 'additional_images', null)->resize(170, 255);
}

Step 3: Implement the Image Change Function

Now we can combine these steps with the HTML and JavaScript code you provided earlier:

<a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>" class="product-image">
    <img src="<?php echo Mage::helper('catalog/image')->init($_product, 'small_image')->resize(170, 255); ?>"
         width="170" height="255" alt="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>"
        onmouseover="this.src='<?php if (isset($secondImageUrl)) { echo $secondImageUrl; } ?>'"
        onmouseout="this.src='<?php echo Mage::helper('catalog/image')->init($_product, 'small_image')->resize(170, 255); ?>'" />
</a>

Conclusion

With this implementation, the product image should now change to the second image when a user hovers over it in the category grid view.

Remember that you’ll need to add this code within your PHTML template file for the category listing (e.g., app/design/frontend/default/theme/template/catalog/product/list.phtml).

If you encounter any further challenges or have specific questions about your Magento setup, feel free to reach out. We provide expert Magento development services at Laravel Company.

Catalog Database Admin SEO

Our network