How to call a php function inside a smarty .tpl file?

Question

Hi i have written a function in .php file. i.e.

public static function getCategories($id_lang = false, $active = true, $order = true, $sql_filter = '', $sql_sort = '',$sql_limit = '')
{
    if (!Validate::isBool($active))
        die(Tools::displayError());

    $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
        SELECT *
        FROM `'._DB_PREFIX_.'category` c
        LEFT JOIN `'._DB_PREFIX_.'category_lang` cl 
        ON c.`id_category` = cl.`id_category`
        WHERE 1 '.$sql_filter.' '.($id_lang ? 'AND `id_lang` = '.(int)($id_lang) : '').'
        '.($active ? 'AND `active` = 1' : '').'
        '.(!$id_lang ? 'GROUP BY c.id_category' : '').'
        '.($sql_sort != '' ? $sql_sort : 'ORDER BY c.`level_depth` ASC, c.`position` ASC').'
        '.($sql_limit != '' ? $sql_limit : '')
    );

    if (!$order)
        return $result;

    $categories = array();
    foreach ($result AS $row)
    {
        $categories[$row['id_parent']][$row['id_category']]['infos'] = $row;
    }
    return $categories;
}

and i want to call this function inside a .tpl file. I used {php} {/php} way,but this not works. What is the way to call this one?

Thanks

Answer 1

Smarty is a templating language - if you want to output the results of a function, assign the output to a smarty variable

$smarty->assign('categories', getCategories($args));

And then use it in your template

{$categories}

There are very few situations where this isn't the correct pattern.

Answer 2

you can use something like this and i always used it

{category.id|function_name}

let me explain it :

category.id = is the id of the category you want to get information about in the function

function_name = is the name of the function

Answer 3

because you are using a static method, you will not be able to use $this keyword in your function. So therefore, you will not be able to use

$this->context->smarty->assign('categories', self::getCategories($args));

So you should create a variable and assign the context to it and in your case you will only need the smarty part of it.

$smarty = Context::getContext()->smarty;

Now you can use this as follows:

$smarty->assign('categories', self::getCategories($args));

I'm assuming that you will call the function in the same class, so I used self::getCategories($args), if you want to use it in another class use className::getCategories($args)

Hope this helps you, try it and give me feedback! ;)