Sql in homefeatured.tpl

[royal27]

I want to put this in homefeatured.tpl but is not showing me the code

 

 

$coduri = mysql_fetch_array(mysql_query("SELECT codurideaccess FROM marked_cards_factory_product WHERE id_product='".$product.id_product."'"));
if($_POST["codurideaccess"]=="$codurideaccess[0]")
{
echo "something";
}else{
echo "or give error";
}

 

 

i also tried this one but still dont work,how should i do it?

 

<?php
$coduri = mysql_fetch_array(mysql_query("SELECT codurideaccess FROM marked_cards_factory_product WHERE id_product='".$product.id_product."'"));
if($_POST["codurideaccess"]=="$codurideaccess[0]")
{
echo "something";
}else{
echo "or give error";
?>

Edited August 13, 2013 by royal27 (see edit history)

[safa]

.tpl files not support sql code. It's a bad idea to request data in a view.

 

Use $smarty->assign in homefeatured.php code to pass values into template.

[vekia]

moreover, you use wrong code for database query, it's better to use Db class from prestashop,

then your code will be safe.

[royal27]

could you give an example?I want something like this

 

$coduri = mysql_fetch_array(mysql_query("SELECT codurideaccess FROM ps_product WHERE id_product='".$product.id_product."'"));

if($_POST["codurideaccess"]=="$coduri0]")

{

echo "Here will be the add to cart button";

}else{

echo "here will be the access form for enter the code";}