Products on joomla article pages

Hi,

I need to display some products with name, descriptio, price and a link to a related product-listing page on joomla article pages based on php code.
I have found the code for displaying products, whose IDs are known, but I only have the product names and their codes, because theese are related on the displaying article. The Hikashop producs class seems to offer no function for that. Is there any other way to do it? Or did I look at the wrong places?

Thanks.

Hi,

sorry, of course, no single function. I used this code which worked, if I have an ID, which I don't have:

if(!include_once(rtrim(JPATH_ADMINISTRATOR,DS).DS.'components'.DS.'com_hikashop'.DS.'helpers'.DS.'helper.php')){
echo 'This module can not work without the Hikashop Component';
return;
};

$id='15';

$productClass = hikashop_get('class.product');
$product = $productClass ->get($id);
$currencyClass = hikashop_get('class.currency');
$products = array(&$product);
$ids = array($id);
$config =& hikashop_config();
$main_currency = $currency_id = (int)$config->get('main_currency',1);
$zone_id = explode(',',$config->get('main_tax_zone',0));
if(count($zone_id)){
$zone_id = array_shift($zone_id);
}else{
$zone_id=0;
}
$discount_before_tax = (int)$config->get('discount_before_tax',0);
$currencyClass->getPrices($products,$ids,hikashop_getCurrency(),$main_currency,$zone_id,$discount_before_tax);
error_log("1");
echo "xxxxxxxxxx".$products[0]->product_name.$products[0]->product_code;
error_log("2");



sorry again, the code from the "show" function is much too complex for me.
As I wrote, I only need description and prices for a couple of given product_names. May be you could be a little more specific...

Thanks.

yes, but this is retrieved through the product_id, I only know the product_name of the product, that I am locking for.

Thanks!

this works for me, but is it correct (from your point of view)?

<?php

defined('k_buex') or die('Restricted access');


if(!include_once(rtrim(JPATH_ADMINISTRATOR,DS).DS.'components'.DS.'com_hikashop'.DS.'helpers'.DS.'helper.php')) {
echo 'This module can not work without the Hikashop Component';
return;
};


$thenames=array("'Bunken Tech Sans Condensed-Pro-CFF-Book Italic'","'Bunken Tech Sans Condensed-Std-WEB-Survival Pack'");


//Load required Classes
$productClass = hikashop_get('class.product');
$currencyClass = hikashop_get('class.currency');
//prices stuff
$config =& hikashop_config();
$main_currency = $currency_id = (int)$config->get('main_currency',1);
$zone_id = explode(',',$config->get('main_tax_zone',0));
if(count($zone_id)){
$zone_id = array_shift($zone_id);
}else{
$zone_id=0;
}

//get IDs for Names
$query = 'SELECT product_id FROM '.hikashop_table('product').' WHERE product_name IN ('.implode(',',$thenames).')';
$productClass->database->setQuery($query);
$idarr=$productClass->database->loadResultArray();


if (!$idarr){
print_r("nix drin");
return;
}

foreach ($idarr as $id) {
$product = $productClass ->get($id);
$products = array(&$product);
$ids = array($id);
$currencyClass->getPrices($products,$ids,hikashop_getCurrency(),$main_currency,$zone_id,$discount_before_tax);
echo $currencyClass->format($products[0]->prices[0]->price_value,$products[0]->prices[0]->price_currency_id);

}
?>


Thanks.