Example #1
0
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>';
}