function show_results($dbh, $nbr_lignes = 0, $page = 0) { global $nb_per_page; global $base_url; global $caller; global $charset; global $msg; global $id_bibli; // on récupére le nombre de lignes qui vont bien $nbr_lignes = entites::count_coordonnees($id_bibli); if (!$page) { $page = 1; } $debut = ($page - 1) * $nb_per_page; if ($nbr_lignes) { // on lance la vraie requête $res = entites::get_coordonnees($id_bibli, '-1', $debut, $nb_per_page); while ($row = mysql_fetch_object($res)) { $adresse = ''; $adresse1 = ''; if ($row->libelle != '') { $adresse = htmlentities(addslashes($row->libelle), ENT_QUOTES, $charset) . "\\n"; $adresse1 = htmlentities($row->libelle, ENT_QUOTES, $charset); } if ($row->contact != '') { $adresse .= htmlentities(addslashes($row->contact), ENT_QUOTES, $charset) . "\\n"; } $adresse1 .= ' ('; if ($row->adr1 != '') { $adresse .= htmlentities(addslashes($row->adr1), ENT_QUOTES, $charset) . "\\n"; $adresse1 .= htmlentities($row->adr1, ENT_QUOTES, $charset) . ' '; } if ($row->adr2 != '') { $adresse .= htmlentities(addslashes($row->adr2), ENT_QUOTES, $charset) . "\\n"; $adresse1 .= htmlentities($row->adr2, ENT_QUOTES, $charset) . ' '; } if ($row->cp != '') { $adresse .= htmlentities(addslashes($row->cp), ENT_QUOTES, $charset) . ' '; $adresse1 .= htmlentities($row->cp, ENT_QUOTES, $charset) . ' '; } if ($row->ville != '') { $adresse .= htmlentities(addslashes($row->ville), ENT_QUOTES, $charset); $adresse1 .= htmlentities($row->ville, ENT_QUOTES, $charset); } $adresse1 .= ')'; print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$row->id_contact}', '{$adresse}' )\">{$adresse1}</a>"); print "<br />"; } mysql_free_result($res); // constitution des liens $nbepages = ceil($nbr_lignes / $nb_per_page); $suivante = $page + 1; $precedente = $page - 1; // affichage du lien précédent si nécessaire print '<hr /><div align=center>'; if ($precedente > 0) { print "<a href='{$base_url}&page={$precedente}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/left.gif' border='0' title='{$msg['48']}' alt='[{$msg['48']}]' hspace='3' align='middle' /></a>"; } for ($i = 1; $i <= $nbepages; $i++) { if ($i == $page) { print "<b>{$i}/{$nbepages}</b>"; } } if ($suivante <= $nbepages) { print "<a href='{$base_url}&page={$suivante}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/right.gif' border='0' title='{$msg['49']}' alt='[{$msg['49']}]' hspace='3' align='middle' /></a>"; } } print '</div>'; }