X-Cart forums - Access $product from Static Page

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

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

- - Access $product from Static Page (https://forum.x-cart.com/showthread.php?t=67684)

Access $product from Static Page

Hello,

What do I need to import to be able to access $product from a static page? More specifically, I'm trying to access the smarty tag variable {$product.productcode}...

Thanks!

Re: Access $product from Static Page

You will need to query it in pages.php or you won't have access to it.

Re: Access $product from Static Page

how to do then? pls share your code here!

Re: Access $product from Static Page

To pull in a product array, I typically use the function func_search_products

Here is an example from a module I am building for a client, it refernces some non-standard x-cart tables so won;t work for you, but it should get the juices flowing and point you in th right direction:

PHP Code:


		
			
$product_kit_items = func_search_products(
    array(
        'fields'        => array("$sql_tbl[products].*", "$sql_tbl[product_kit_items].*"),
        'from_tbls'     => array('product_kit_items'=>''),
        //'skip_tables'   => XCSearchProducts::getSkipTablesByTemplate(XCSearchProducts::SKIP_ALL_POSSIBLE),
        'query'         => " AND $sql_tbl[products].productid = $sql_tbl[product_kit_items].productid AND $sql_tbl[product_kit_items].parentid = '$productid'",
    ),
    $user_account['membershipid'],
    "$sql_tbl[product_kit_items].orderby, product",
    "",
    false,
    false,
    true
);

Re: Access $product from Static Page

how to add the above code, pls?