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
| <?php
include('conx_bd.php');
if(isset($_POST['submit']))
{
$search = mysql_real_escape_string(htmlentities(trim($_POST['search'])));
if(empty($search))
{
$msg="Saisir une hotel ou un région!";
}
else
{
$ou="";
$search=preg_split('/[\s]+/',$search);
$total_result = count($search);
foreach($search as $key=>$searches)
{
$ou.="region LIKE '%$searches%'";
if($key!=($total_result-1))
{
$ou.=" AND ";
}
}
$req= "SELECT * FROM hotel WHERE $ou" ;
$query=mysql_query($req);
$rows=mysql_num_rows($query);
if($rows) {
while($row= mysql_fetch_assoc($query)) {
echo $row['nom']."</strong><br/>";
}
}
else echo "Nous n'avons pas un hotel de ce nom, Verifier votre recherche!";
}
}
?>
<form action="reserver.php" method="POST">
<div>
<input type="text" name="search" placeholder="Chercher" required/>
<input type="submit" name="submit" value="Chercher"/>
</div>
</form> |
Partager