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
|
<form action ="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<br/>
<label for="query">Recherche:</label>
<input type="search" name="query" " maxlength="80" size="80" id="query"/><br/>
<br/>
Recherche au niveau de:
<select name="filtre">
<option value="tbl_form">Formulaire</option>
</select><br/>
<br/>
<input type="submit" value="rechercher">
</form>
</body>
</html>
<?php
$resultats = "";
// Traitement de la requête
if(isset($_POST['query']) && !empty($_POST['query'])){
// Si l'utilisateur à rentré quelque chose, on traite sa requête
$query = preg_replace("#[^a-zA-Z ?0-9]#i", "", $_POST['query']);
if($_POST['filtre'] == "Site entier"){
} else if ($_POST['filtre'] == "tbl_form") {
$sql = "SELECT date, nom, ville FROM tbl_form WHERE date LIKE ? OR nom LIKE ? OR ville LIKE ? ORDER BY date DESC, nom DESC";
}
include('src/connection.php');
$req = $db->prepare($sql);
$req->execute(array('%'.$query.'%', '%'.$query.'%', '%'.$query.'%'));
$count = $req->rowCount();
if ($count >= 1){
echo "$count résultat(s) trouvé(s)<hr/>";
echo'
<table>
<tr>
<th>Date</th>
<th>Nom</th>
<th>Ville</th>
</tr>';
//while($data = $req->fetch(PDO::FETCH_OBJ)){
while($data = $req->fetch()){
echo'
<tr>
<td class="tdcenter">'.$data['date'].'</td>
<td class="tdcenter">'.$data['nom'].'</td>
<td class="tdcenter">'.$data['ville'].'</td>
</tr>';
//echo 'Date:'.$data->date. ' ,H Départ:' .$data->h_depart. ' ,H Rentrée:' .$data->h_rentree. ' ,Adresse:' .$data->adresse. ',' .$data->numero. ' ,Ville:' .$data->ville. ' ,Rapport:' .$data->num_rapport. ' ,Chauffeur:' .$data->chauffeur. ' ,Convoyeur:' .$data->convoyeur. ' ,Supp:' .$data->supp. ' ,Nbr km:' .$data->nbr_km. ' ,Hopital:' .$data->hopital. ' ,Prise en chare:' .$data->prise_en_charge. '<br/>';
}
'</table>';
} else {
echo "0 résultat trouvé<hr/>";
}
}
?>
<br/>
<br/>
<br/>
<?php echo $resultats; ?>
<?php } ?> |
