| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/ |
Upload File : |
<?php
if ($ses_marq > 0) {
//////////////////////////////////////////////////////
if ($px_par_page =='1'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id,p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
INNER JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 ss
ON ss.cha_var1 = pc.id_category
WHERE p.status = 1 AND pm.id_marque = :marq AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq, 'session' => $session));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id,p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 ss
ON ss.cha_var1 = pc.id_category
WHERE p.status = 1 AND pm.id_marque = :marq AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq, 'session' => $session));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 ss
ON ss.cha_var1 = pc.id_category
WHERE p.status = 1 AND pm.id_marque = :marq AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq, 'session' => $session));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 ss
ON ss.cha_var1 = pc.id_category
WHERE p.status = 1 AND pm.id_marque = :marq AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq, 'session' => $session));
}
} else {
/////////////////////////////////////////////////
if ($px_par_page =='1'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
INNER JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND pm.id_marque = :marq AND pp.position = 1
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
INNER JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND pm.id_marque = :marq AND pp.position = 1
GROUP BY p.id ORDER BY p.price ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
INNER JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND pm.id_marque = :marq AND pp.position = 1
GROUP BY p.id ORDER BY p.price DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id,p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND pm.id_marque = :marq AND pp.position = 1
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('marq' => $marq, 'session' => $session));
}
}
$results = $test->fetchAll();
$smarty->assign("products", $results);
?>