<article class="brand__container"> <div class="brand__icon-container agency"> <img alt="Agency" class="brand__icon agency" src="brand-icon-media.png"> </div> <div class="brand__title agency"> <h3 class="brand__title--bg">Espace de Recherche</h3> <div class="brand__title--line"></div> </div> <div class="brand__description"> <form name="f" method="post" action="rechercheComp.php"> <input id="fname" name="nomm" placeholder="Votre nom" type="text"> <input id="fprenom" type="text" name="prenomm" placeholder="votre prenom"/> <input id="contact" name="numeroo" placeholder="votre numero de telephone" type="text"> <input id="femail" name="emaill" placeholder="Votre Email" type="text"> <input id="fdomaine" name="domainee" placeholder="Votre Domaine" type="text"> <input id="fnature" type="text" name="natureVV" placeholder="Nature de véhicule"/> <input id="fmatricule" type="text" name="matriculee" placeholder="Matricule"/> <select name="adrDepp" id="fadrDep"> <option value="adr">Adresse de Départ</option> <option value="tunis">tunis</option> <option value="sfax">sfax</option> <option value="bbbb">bbbbb</option> <option value="oooooo">oooo</option> </select> <select name="adrArrr" id="fadrArr"> <option value="adr">Adresse d'Arriver</option> <option value="tunis">tunis</option> <option value="sfax">sfax</option> <option value="bbbb">bbbbb</option> <option value="oooooo">oooo</option> </select> <input id="fdateDep" type="date" name="dateDepp" placeholder="Date de départ"/> <input id="fdateArr" type="date" name="dateArrr" placeholder="Date d'arriver"/> <input id="fheure"type="text" name="heuree" placeholder="Heure"/> <input id="fcapacite" type="capacite" name="capacitee" placeholder="Capacité"/> <input id="fnb" type="number" name="nbPlacee" placeholder="Nombre des places chargées"/> <input id="submit" type="submit" value="cherecher"> </form> </div> </article>
<?php include"personne.class.php"; $p=new personne(); $adrArrr=$_POST['adrArrr']; $nomm=$_POST['nomm']; $prenomm=$_POST['prenomm']; $numeroo=$_POST['numeroo']; $emaill=$_POST['emaill']; $domainee=$_POST['domainee']; $adrDepp=$_POST['adrDepp']; $heuree=$_POST['heuree']; $natureVV=$_POST['natureVV']; $matriculee=$_POST['matriculee']; $capacitee=$_POST['capacitee']; $nbPlacee=$_POST['nbPlacee']; if ((isset($_POST['nomm']))&&((isset($_POST['prenomm'])))&&(isset($_POST['adrArrr']))&&((isset($_POST['adrDepp'])))&&(isset($_POST['natureVV']))&&((isset($_POST['matriculee']))) &&(isset($_POST['capacitee']))&&((isset($_POST['nbPlacee'])))&&(isset($_POST['numeroo']))&&((isset($_POST['emaill'])))) $res=$p->cherche($adrArrr,$nomm,$prenomm,$emaill,$domainee,$adrDepp,$matriculee,$numeroo,$emaill,$nbPlacee,$capacitee,$natureVV); ?> fonction cherche : public function cherche($adrArr,$nom,$prenom,$email,$domaine,$adrDep,$matricule,$numero,$email,$nbPlace,$capacite,$natureV) { include"connexion.class.php"; $cnx=new connexion(); $PDO=$cnx->CNXbase(); $req="select* from personne where adrArr='$adrArr' or (nom='$nom' or prenom='$prenom' and (nom='$nom' or prenom='$prenom' )) or email='$email' or domaine='$domaine' or adrDep='$adrDep' or matricule='$matricule' or numero='$numero' or email='$email' or nbPlace='$nbPlace' or capacite='$capacite' or natureV='$natureV' "; //echo $req; $res=$PDO->query($req); //$res=$PDO->prepare($req); //$res->execute(); return $res; }
EDIT : Ajout des balises de code (la coloration syntaxique).
Explications disponibles ici :ICI Merci d'y penser dans tes prochains messages. |