X-Cart forums - Extra Field Search From product.tpl

Page 3 of 3

Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Extra Field Search From product.tpl (https://forum.x-cart.com/showthread.php?t=48320)

mrerotic

07-21-2009 03:33 PM

Re: Extra Field Search From product.tpl

ok the following is what I added to product.php

PHP Code:


		
			
// TEST ADDITION //
$product_cat = func_query("SELECT category FROM $sql_tbl[categories] WHERE categoryid IN (SELECT categoryid FROM $sql_tbl[products_categories] WHERE productid ='$productid')"); 
if (!empty($product_cat)) {
foreach ($product_cat as $c => $d) {
$explode_cats[] = $d['category'];
}
 
$smarty->assign("explode_cats", $explode_cats);
}
// END TEST ADDITION //

And in product.tpl I added:
------------------------------
<div>
{foreach from=$explode_cats item=c}
<a href="search.php?mode=search&including=any&categor yid=1" title="{$c}">{$c}</a> |
{/foreach}
</div>

How can I pass the category id's to product.tpl in above so each href is correct for each categoryid? I have the categories passing correctly, I just can't figure out how to get the id's.

Thanks :)

mrerotic

07-21-2009 04:54 PM

Re: Extra Field Search From product.tpl

OK I got this to work:

In product.php I have:

PHP Code:


		
			
# Start show categories for each product (ADD-ON)
$product_cat = func_query("SELECT category, categoryid FROM $sql_tbl[categories] WHERE categoryid IN (SELECT categoryid FROM $sql_tbl[products_categories] WHERE productid ='$productid')");  
if (!empty($product_cat)) {
 foreach ($product_cat as $c => $d) {
  $explode_cats[] = $d;
 }
 
 $smarty->assign("explode_cats", $explode_cats);
}
# end add to show categories for each product (ADD-ON)

Then in product.tpl I have the following:
---------------------------------------
<div>
{foreach from=$explode_cats item=c}
{assign var=Pcatid value=$c.categoryid}
{assign var=Pcatname value=$c.category}
<a href="search.php?mode=search&including=any&categor yid={$Pcatid}" title="{$Pcatname}">{$Pcatname}</a> |
{/foreach}
</div>

I HOPE THIS HELPS SOMEONE...

THANKS FOR ALL THE HELP :)

flamers

04-21-2010 02:44 AM

Re: Extra Field Search From product.tpl

Hi mrerotic, I also want to explode extra field items (a performer list, exactly the same as your initial query on this thread) but I am having a little difficulty following the code changes needed. Could you possibly post the coding changes that you carried out to make a hyperlink for each performer name?

Thanks in advance.

All times are GMT -8. The time now is 04:53 AM.

Page 3 of 3

Show 40 posts from this thread on one page