1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122
|
<?php
include("Connexion.php");
$id_ag=(isset($_POST["id_rdv"])) ? $_POST["id_ag"] : "";
$nom=(isset($_POST["nom"])) ? $_POST["nom"] : "";
$prenom =(isset($_POST["prenom"])) ? $_POST["prenom"] : "";
$fonction_ag =(isset($_POST["fonction_ag"])) ? $_POST["fonction_ag"] : "";
$contact =(isset($_POST["contact"])) ? $_POST["contact"] : "";
$mail_ag =(isset($_POST["mail_ag"])) ? $_POST["mail_ag"] : "";
$adresse =(isset($_POST["adresse"])) ? $_POST["adresse"] : "";
$login =(isset($_POST["login"])) ? $_POST["login"] : "";
$id_rdv =(isset($_POST["id_rdv"])) ? $_POST["id_rdv"] : "";
$Objet_rdv =(isset($_POST["Objet_rdv"])) ? $_POST["Objet_rdv"] : "";
$Contact=(isset($_POST["Contact"])) ? $_POST["Contact"] : "";
$Lieu_rdv =(isset($_POST["Lieu_rdv"])) ? $_POST["Lieu_rdv"] : "";
$Debut_rdv =(isset($_POST["Debut_rdv"])) ? $_POST["Debut_rdv"] : "";
$Type_rdv=(isset($_POST["Type_rdv"])) ? $_POST["Type_rdv"] : "";
if(!empty($_POST['recherche'])) //Si la recherche n'est pas vide
{
$recherche=$_POST['recherche'];
//var_dump($recherche);
//On prépare la requête SQL
$request=$db->prepare('SELECT id_ag,nom,prenom,fonction_ag,contact,mail_ag,adresse,login ,id_rdv,Objet_rdv,Contact,Lieu_rdv,Debut_rdv,Type_rdv FROM agent,rendez_vous WHERE id_ag LIKE :recherche OR nom LIKE :recherche OR prenom LIKE :recherche OR fonction_ag LIKE :recherche OR contact LIKE :recherche OR mail_ag LIKE :recherche OR adresse LIKE :recherche OR login LIKE :recherche
OR id_rdv LIKE :recherche OR Objet_rdv LIKE :recherche OR Contact LIKE :recherche OR Lieu_rdv LIKE :recherche OR Debut_rdv LIKE :recherche OR Type_rdv LIKE :recherche)AND(agent.id_ag=rendez_vous.id_ag)');
//var_dump($request);
//On l'exécute
$request->execute(array
(
'recherche' => '%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
, 'recherche' =>'%'.$recherche.'%'
));
var_dump($id_ag);
var_dump($nom);
var_dump($prenom);
var_dump($fonction_ag);
var_dump($contact);
var_dump($mail_ag);
var_dump($adresse);
var_dump($login);
var_dump($id_rdv);
var_dump($Objet_rdv);
var_dump($Contact);
var_dump($Lieu_rdv);
var_dump($Debut_rdv);
var_dump($Type_rdv);
while($data = $request->fetch())
{
echo $data['id_ag'];
echo $data['nom'];
echo $data['prenom'];
echo $data['fonction_ag'];
echo $data['contact'];
echo $data['mail_ag'];
echo $data['adresse'];
echo $data['login'];
echo $data['id_rdv'];
echo $data['Objet_rdv'];
echo $data['Contact'];
echo $data['Lieu_rdv'];
echo $data['Debut_rdv'];
echo $data['Type_rdv'];
}
}
?>
<!DOCTYPE HTML>
<html>
<head><title> recherche</title>
<link rel="stylesheet" href="/css/bootstrap.min.css">
<!-- Optional theme -->
<link rel="stylesheet" href="css/bootstrap-theme.min.css">
<!-- style css -->
<link rel="stylesheet" href="/courrier_rendez_vous/css/Page.css">
<script type="text/javascript" src="JS/jquery.js"></script>
<script type="text/javascript" src="JS/jquery.autocomplete.js"></script>
</head>
<body>
<form class="navbar-form navbar-right" method="post" action="search.php">
<div class="form-group">
<input type="text" class="form-control" placeholder="Rechercher" name="recherche">
</div>
<button type="submit" class="btn btn-primary" name="rechercher"><i class="icon icon-search"></i>
<span class="glyphicon glyphicon-search" aria-hidden="true"></span></button>
</form>
<script src="/js/bootstrap.min.js"></script>
<script src="/js/main.js"></script>
</body>
</html> |
Partager