VirtueMart Forum

Hi all,

Help me please , i want to know how to input product image into invoice.

thank you so much.

See http://bfy.tw/6QjZ

Now i can add product image on invoice .

Add in line 105 befor

                       <td align="center">
            <?php echo $item->order_item_sku; ?>
         </td>


I use this code

<?php
         if (!empty($item->product_quantity)) {

             $db = JFactory::getDBO();
             $qs = "select file_url
               from cathtest_virtuemart_medias
               where virtuemart_media_id ='34'"; //print_r($qs);
         $db->setQuery($qs);
         $item2 = $db->loadAssocList();
         foreach($item2 as $file_thumb){
            //echo $file_thumb['file_url_thumb'];
             ?>
             <img src="<?php  echo JURI::root () . $file_thumb['file_url_thumb'] ?>" />
             <?php
             }
          }

        ?>   

add in invoice_item.php