if ((isset($_POST['hid_affichage']) && $_POST['hid_affichage']=="1") || !isset($_POST['hid_affichage']))
{
$_SESSION['rech_param']="";
$_SESSION['rech_tab']="";
}
if (isset($_POST['hid_affichage']) )
{
$_SESSION['rech_mot']=$_POST['txt_mot'];
$_SESSION['rech_ville']=$_POST['sel_ville'];
}
?>
| |
if ($_SESSION['rech_param']=="")
{
$clause="";
$tab_res="";
$tab_res="annuaire_medecin";
if ($_SESSION['rech_mot']!="")
{
$MotClef = explode(" ", addslashes(addslashes($_SESSION['rech_mot'])));
$field_search=array("r_sociale","adresse","tel","specialite");
$clause=func_recherche($field_search,$MotClef);
}
else
{
$clause=" where 1=1";
}
if ($_SESSION['rech_ville']!="" && $_SESSION['rech_ville']!="-1")
{
$clause=$clause." and ville='".$_SESSION['rech_ville']."'";
}
}
else
{
$clause=$_SESSION['rech_param'];
$tab_res=$_SESSION['rech_tab'];
}
$field=array("count(id_medecin) as compteur");
$clause=$clause;
$result=select($tab_res,$field,$clause);
$row=mysql_fetch_array($result);
$nb_rows=$row['compteur'];
$entrees_par_page = 10;
$total_pages = ceil($nb_rows/$entrees_par_page);
if(!isset($_GET['page']))
{
$page_courante = 1;
}
else
{
$page = $_GET['page'];
if ($page<=1) $page_courante=1;
elseif ($page>$total_pages) $page_courante=$total_pages;
else $page_courante=$page;
}
$param=$clause;
$start = ($page_courante * $entrees_par_page - $entrees_par_page);
if ($_SESSION['rech_param']=="")
{
$clause=$clause." order by r_sociale LIMIT $start, $entrees_par_page";
}
else
{
$clause=$_SESSION['rech_param']." order by r_sociale LIMIT $start, $entrees_par_page";;
}
$_SESSION['rech_param']=$param;
$_SESSION['rech_tab']=$tab_res;
$field=array("r_sociale","adresse","ville","tel","specialite");
$result=select($tab_res,$field,$clause);
$nb_total=mysql_num_rows($result);
if (isset($_GET['page']))
{
$var_page=$page_courante;
}
else
{
$var_page=1;
}
while ($row=mysql_fetch_array($result))
{
?>
| echo stripslashes($row['r_sociale']);?> |
echo stripslashes($row['specialite']);?> |
| Tel: echo stripslashes($row['tel']);?> |
echo stripslashes($row['adresse'])." ".stripslashes($row['ville']);?> |
| |
}
?> |
|
|
if (isset($var_page) && $nb_rows!=0)
{
$var_debut=($var_page-1)*$entrees_par_page+1;
$var_fin=$var_debut + $nb_total - 1;
echo ("Médecins ".$var_debut .' - '.$var_fin.' / '.$nb_rows);
}
elseif ($nb_rows==0)
{
echo "Les termes de recherche spécifiés ne correspondent à aucun médecin.";
}
?> |
echo pagination($total_pages,$page_courante,'annuaire.php');
?>
|
|
|