1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| <?php
$query = $connexion->prepare("SELECT ps_product.id_product,ps_fonctionnalite_attribute.id_fc, fc_nameImage FROM ps_product, ps_product_lang, ps_fonctionnalite, ps_fonctionnalite_attribute WHERE ps_product.id_product=ps_fonctionnalite_attribute.id_product AND ps_fonctionnalite.id_fc=ps_fonctionnalite_attribute.id_fc AND ps_product.id_product=ps_product_lang.id_product AND id_lang=2");
$query->execute();
$list = array();
while($data = $query->fetch()){
$list[$data['ps_product.id_product']]['id'] = $data['ps_fonctionnalite_attribute.id_fc'];
$list[$data['ps_product.id_product']]['name'] = $data['fc_name'];
$list[$data['ps_product.id_product']]['nameI'] = $data['fc_nameImage'];
}
// On lance Smarty
require("../tools/smarty/smarty.class.php");
$tpl = new Smarty();
$tpl->assign('list', $list);
$tpl->display("product.tpl");
?> |
Partager