blank page

[ruisonika]

Hello i made a blank page following Nemo tutorial http://nemops.com/creating-new-pages-in-prestashop/#.X2yptpP0kWp.
So my problem is:
i wanna make a function with sql query to return something, i will put it on module php root file (i think).
in tpl file how do i call the function?
or i have to pass it for other file?
any help please?
 

public function getContaCorrente()
	{
	    $sql = 'SELECT * FROM '._DB_PREFIX_.'contacorrente WHERE email = [email protected]';
        if ($results = Db::getInstance()->ExecuteS($sql))
            foreach ($results as $row)
            echo $row['email'].' :: '.$row['date'].'<br />';
	}

How do i call this in template file?

[Knowband Plugins]

Search for "Smarty Assign" in the Google. Refer to below link as well. 

https://www.smarty.net/docs/en/api.assign.tpl