PHP pmb_mysql_free_result函数代码示例

 function get_primaldata()
 {
     global $dbh;
     $requete = "SELECT * FROM sub_collections WHERE sub_coll_id='" . addslashes($this->id) . "' ";
     $result = pmb_mysql_query($requete, $dbh);
     if (pmb_mysql_num_rows($result)) {
         $obj = pmb_mysql_fetch_object($result);
         pmb_mysql_free_result($result);
         $this->get_primaldatafrom($obj);
     } else {
         // pas de sous-collection avec cette clé
         $this->id = 0;
         $this->name = '';
         $this->parent = '';
         $this->parent_libelle = '';
         $this->parent_isbd = '';
         $this->publisher = '';
         $this->publisher_libelle = '';
         $this->publisher_isbd = '';
         $this->display = '';
         $this->issn = '';
         $this->isbd_entry = '';
         $this->comment = '';
     }
 }

 function get_primaldata()
 {
     global $dbh;
     $requete = "SELECT * FROM authors WHERE author_id='" . addslashes($this->id) . "' LIMIT 1 ";
     $result = @pmb_mysql_query($requete, $dbh);
     if (pmb_mysql_num_rows($result)) {
         $obj = pmb_mysql_fetch_object($result);
         pmb_mysql_free_result($result);
         $this->get_primaldatafrom($obj);
     } else {
         // pas d'auteur avec cette clé
         $this->id = 0;
         $this->type = '';
         $this->name = '';
         $this->rejete = '';
         $this->date = '';
         $this->see = '';
         $this->display = '';
         $this->isbd_entry = '';
         $this->author_web = '';
         $this->author_comment = '';
         $this->subdivision = '';
         $this->lieu = '';
         $this->salle = '';
         $this->ville = '';
         $this->pays = '';
         $this->numero = '';
     }
 }

 function getData()
 {
     global $dbh;
     global $msg;
     if (!$this->idetagere) {
         // pas d'identifiant.
         $this->name = '';
         $this->comment = '';
         $this->autorisations = "";
         $this->validite = "";
         $this->validite_date_deb = "";
         $this->validite_date_fin = "";
         $this->validite_date_deb_f = "";
         $this->validite_date_fin_f = "";
         $this->visible_accueil = "";
         $this->id_tri = 0;
         $this->thumbnail_url = '';
         $this->classementGen = '';
     } else {
         $requete = "SELECT idetagere, name, comment, validite, ";
         $requete .= "validite_date_deb, date_format(validite_date_deb, '" . $msg["format_date"] . "') as validite_date_deb_f,  ";
         $requete .= "validite_date_fin, date_format(validite_date_fin, '" . $msg["format_date"] . "') as validite_date_fin_f,  ";
         $requete .= "visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement FROM etagere WHERE idetagere='{$this->idetagere}' ";
         $result = @pmb_mysql_query($requete, $dbh);
         if (pmb_mysql_num_rows($result)) {
             $temp = pmb_mysql_fetch_object($result);
             pmb_mysql_free_result($result);
             $this->idetagere = $temp->idetagere;
             $this->name = $temp->name;
             $this->comment = $temp->comment;
             $this->validite = $temp->validite;
             $this->validite_date_deb = $temp->validite_date_deb;
             $this->validite_date_deb_f = $temp->validite_date_deb_f;
             $this->validite_date_fin = $temp->validite_date_fin;
             $this->validite_date_fin_f = $temp->validite_date_fin_f;
             $this->visible_accueil = $temp->visible_accueil;
             $this->autorisations = $temp->autorisations;
             $this->id_tri = $temp->id_tri;
             $this->thumbnail_url = $temp->thumbnail_url;
             $this->thumbnail_url = $temp->etagere_classsement;
         } else {
             // pas de caddie avec cet id
             $this->idetagere = 0;
             $this->name = "";
             $this->comment = "";
             $this->validite = "";
             $this->validite_date_deb = "";
             $this->validite_date_fin = "";
             $this->validite_date_deb_f = "";
             $this->validite_date_fin_f = "";
             $this->visible_accueil = "";
             $this->autorisations = "";
             $this->id_tri = '';
             $this->thumbnail_url = '';
             $this->classementGen = '';
         }
     }
 }

 function getData()
 {
     global $dbh;
     if (!$this->id) {
         // pas d'identifiant. on retourne un tableau vide
         $this->id = 0;
         $this->name = '';
         $this->parent = 0;
         $this->editeur = '';
         $this->editor_isbd = '';
         $this->display = '';
         $this->issn = '';
         $this->collection_web = '';
         $this->comment = '';
     } else {
         $requete = "SELECT * FROM collections WHERE collection_id={$this->id} LIMIT 1 ";
         $result = @pmb_mysql_query($requete, $dbh);
         if (pmb_mysql_num_rows($result)) {
             $temp = pmb_mysql_fetch_object($result);
             pmb_mysql_free_result($result);
             $this->id = $temp->collection_id;
             $this->name = $temp->collection_name;
             $this->parent = $temp->collection_parent;
             $this->issn = $temp->collection_issn;
             $this->collection_web = $temp->collection_web;
             $this->comment = $temp->collection_comment;
             if ($temp->collection_web) {
                 $this->collection_web_link = " <a href='{$temp->collection_web}' target=_blank><img src='./images/globe.gif' border=0 /></a>";
             } else {
                 $this->collection_web_link = "";
             }
             $editeur = new editeur($temp->collection_parent);
             $this->editor_isbd = $editeur->isbd_entry;
             $this->issn ? $this->isbd_entry = $this->name . ', ISSN ' . $this->issn : ($this->isbd_entry = $this->name);
             $this->editeur = $editeur->name;
             $this->display = $this->name . ' (' . $this->editeur . ')';
             // Ajoute un lien sur la fiche collection si l'utilisateur à accès aux autorités
             if (SESSrights & AUTORITES_AUTH) {
                 $this->isbd_entry_lien_gestion = "<a href='./autorites.php?categ=collections&sub=collection_form&id=" . $this->id . "' class='lien_gestion'>" . $this->name . "</a>";
             } else {
                 $this->isbd_entry_lien_gestion = $this->name;
             }
         } else {
             // pas de collection avec cette clé
             $this->id = 0;
             $this->name = '';
             $this->parent = 0;
             $this->editeur = '';
             $this->editor_isbd = '';
             $this->display = '';
             $this->issn = '';
             $this->collection_web = '';
             $this->collection_web_link = "";
             $this->comment = "";
         }
     }
 }

function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $msg;
    global $no_display;
    global $charset;
    // on récupére le nombre de lignes qui vont bien
    if ($user_input == "") {
        $requete = "SELECT COUNT(1) FROM notices where notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1' ";
    } else {
        $aq = new analyse_query(stripslashes($user_input));
        if ($aq->error) {
            error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
            exit;
        }
        $members = $aq->get_query_members("notices", "index_wew", "index_sew", "notice_id");
        $requete = "select count(notice_id) from notices where (" . $members["where"] . " or code like '" . stripslashes($user_input) . "') and notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1'";
    }
    $res = pmb_mysql_query($requete, $dbh);
    $nbr_lignes = @pmb_mysql_result($res, 0, 0);
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if ($user_input == "") {
            $requete = "SELECT notice_id, tit1, code FROM notices where notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1' ORDER BY tit1, code LIMIT {$debut},{$nb_per_page} ";
        } else {
            $requete = "select notice_id, tit1, code, " . $members["select"] . " as pert from notices where (" . $members["where"] . " or code like '" . stripslashes($user_input) . "') and notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1' group by notice_id order by pert desc, index_serie, tnvol, index_sew, code limit {$debut},{$nb_per_page}";
        }
        $res = @pmb_mysql_query($requete, $dbh);
        print "<table><tr>";
        while ($notice = pmb_mysql_fetch_object($res)) {
            $notice_entry = $notice->tit1 . "&nbsp;" . $notice->code;
            print "\n\t\t\t\t<tr>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$notice->notice_id}', '" . htmlentities(addslashes($notice->tit1), ENT_QUOTES, $charset) . " ({$notice->code})')\">" . htmlentities($notice->tit1, ENT_QUOTES, $charset) . "</a></td>\n\t\t\t\t\t<td>{$notice->code}</td>";
            print "</tr>";
        }
        print "</table>";
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
    }
    // affichage de la pagination
    print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
    $url_base = $base_url . "&user_input=" . rawurlencode(stripslashes($user_input));
    $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
    print $nav_bar;
    print "</div>";
}

function show_results($dbh, $nbr_lignes = 0, $page = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $charset;
    global $msg;
    global $id_fou;
    // on récupére le nombre de lignes qui vont bien
    $nbr_lignes = types_produits::countTypes();
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        $q = types_produits::listTypes($debut, $nb_per_page);
        $res = pmb_mysql_query($q, $dbh);
        while ($row = pmb_mysql_fetch_object($res)) {
            $typ = $row->id_produit;
            $lib_typ = $row->libelle;
            $taux_tva = new tva_achats($row->num_tva_achat);
            $lib_tva = htmlentities($taux_tva->taux_tva, ENT_QUOTES, $charset);
            $offre = new offres_remises($id_fou, $row->id_produit);
            if ($offre->remise) {
                $lib_rem = htmlentities($offre->remise, ENT_QUOTES, $charset);
            } else {
                $lib_rem = '0';
            }
            print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$row->id_produit}', '" . htmlentities(addslashes($lib_typ), ENT_QUOTES, $charset) . "', '{$lib_rem}', '{$lib_tva}'  )\">{$lib_typ}</a>");
            print "<br />";
        }
        pmb_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>';
}

function dsi_list_classements()
{
    global $dbh, $msg;
    global $page, $nbr_lignes;
    global $dsi_list_tmpl;
    global $form_cb;
    // nombre de références par pages
    $nb_per_page = 10;
    if (!$nbr_lignes) {
        $requete = "SELECT COUNT(1) FROM classements ";
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = @pmb_mysql_result($res, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        $requete = "SELECT id_classement, nom_classement, type_classement FROM classements ORDER BY type_classement, nom_classement, id_classement LIMIT {$debut},{$nb_per_page} ";
        $res = @pmb_mysql_query($requete, $dbh);
        $parity = 0;
        while ($clas = pmb_mysql_fetch_object($res)) {
            if ($parity % 2) {
                $pair_impair = "even";
            } else {
                $pair_impair = "odd";
            }
            $tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./dsi.php?categ=options&sub=classements&id_classement={$clas->id_classement}&suite=acces';\" ";
            $empr_list .= "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>";
            $empr_list .= "\n\t\t\t\t<td>\n\t\t\t\t\t<strong>" . $msg['dsi_clas_type_class_' . $clas->type_classement] . "</strong>\n\t\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t<strong>{$clas->nom_classement}</strong>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>";
            $parity += 1;
        }
        pmb_mysql_free_result($res);
        // affichage de la barre de navig
        $url_base = "{$PHP_SELF}?categ=options&sub=classements";
        $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
        if ($nbr_lignes > 0) {
            $dsi_list_tmpl = str_replace("<!--!!nb_total!!-->", "(" . $nbr_lignes . ")", $dsi_list_tmpl);
        }
        $dsi_list_tmpl = str_replace("!!cle!!", $form_cb, $dsi_list_tmpl);
        $dsi_list_tmpl = str_replace("!!list!!", $empr_list, $dsi_list_tmpl);
        $dsi_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $dsi_list_tmpl);
        $dsi_list_tmpl = str_replace("!!message_trouve!!", "", $dsi_list_tmpl);
        $ajout = "<br /><input type='button' class='bouton' value='{$msg['dsi_clas_ajouter']}' onclick=\"document.location='./dsi.php?categ=options&sub=classements&suite=add'\" />";
        return $dsi_list_tmpl . $ajout;
    } else {
        return "";
    }
}

function affiche_notice_navigopac($requete)
{
    global $page, $nbr_lignes, $id, $location, $dcote, $lcote, $nc, $main, $ssub, $plettreaut;
    global $opac_nb_aut_rec_per_page, $opac_section_notices_order, $msg, $dbh, $opac_notices_depliable, $begin_result_liste, $add_cart_link_spe, $base_path;
    global $back_surloc, $back_loc, $back_section_see;
    global $opac_perio_a2z_abc_search, $opac_perio_a2z_max_per_onglet;
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $opac_nb_aut_rec_per_page;
    //On controle paramètre de tri
    if (!trim($opac_section_notices_order)) {
        $opac_section_notices_order = "index_serie, tnvol, index_sew";
    }
    if ($plettreaut && $plettreaut != "vide") {
        $opac_section_notices_order = "index_author, " . $opac_section_notices_order;
    }
    $requete .= " ORDER BY " . $opac_section_notices_order . " LIMIT {$debut},{$opac_nb_aut_rec_per_page}";
    $res = @pmb_mysql_query($requete, $dbh);
    print $nbr_lignes . " " . $msg["results"] . "<br />";
    if ($opac_notices_depliable) {
        print $begin_result_liste;
    }
    if ($add_cart_link_spe) {
        print pmb_bidi(str_replace("!!spe!!", "&location={$location}&dcote={$dcote}&lcote={$lcote}&ssub={$ssub}&nc={$nc}&plettreaut={$plettreaut}", $add_cart_link_spe));
    }
    //affinage
    //enregistrement de l'endroit actuel dans la session
    $_SESSION["last_module_search"]["search_mod"] = "section_see";
    $_SESSION["last_module_search"]["search_id"] = $id;
    $_SESSION["last_module_search"]["search_location"] = $location;
    $_SESSION["last_module_search"]["search_page"] = $page;
    //affinage
    if ($dcote == "" && $plettreaut == "" && $nc == "") {
        print "<span class=\"espaceResultSearch\">&nbsp;&nbsp;</span><span class=\"affiner_recherche\"><a href='{$base_path}/index.php?search_type_asked=extended_search&mode_aff=aff_module' title='" . $msg["affiner_recherche"] . "'>" . $msg["affiner_recherche"] . "</a></span>";
    }
    //fin affinage
    print "<blockquote>";
    print aff_notice(-1);
    while ($obj = pmb_mysql_fetch_object($res)) {
        print pmb_bidi(aff_notice($obj->notice_id));
    }
    print aff_notice(-2);
    print "</blockquote>";
    pmb_mysql_free_result($res);
    // constitution des liens
    $nbepages = ceil($nbr_lignes / $opac_nb_aut_rec_per_page);
    print '<div id="navbar"><hr /><center>' . printnavbar($page, $nbepages, './index.php?lvl=section_see&id=' . $id . '&location=' . $location . ($back_surloc ? '&back_surloc=' . urlencode($back_surloc) : '') . ($back_loc ? '&back_loc=' . urlencode($back_loc) : '') . ($back_section_see ? '&back_section_see=' . urlencode($back_section_see) : '') . '&page=!!page!!&nbr_lignes=' . $nbr_lignes . '&dcote=' . $dcote . '&lcote=' . $lcote . '&nc=' . $nc . '&main=' . $main . '&ssub=' . $ssub . '&plettreaut=' . $plettreaut) . '</center></div>';
}

function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $class_path;
    global $no_display;
    global $charset;
    global $msg;
    global $dbh;
    // on récupére le nombre de lignes
    if ($user_input == "") {
        $requete = "SELECT empr_cp, empr_ville FROM empr group by empr_cp, empr_ville ";
    } else {
        $requete = "SELECT empr_cp, empr_ville FROM empr where empr_cp like '{$user_input}%' group by empr_cp, empr_ville ";
    }
    $res = pmb_mysql_query($requete, $dbh);
    $nbr_lignes = pmb_mysql_num_rows($res);
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if ($user_input == "") {
            $requete = "SELECT empr_cp, empr_ville, count(id_empr) as nbre FROM empr group by empr_cp, empr_ville ORDER BY empr_cp, empr_ville LIMIT {$debut},{$nb_per_page} ";
        } else {
            $requete = "SELECT empr_cp, empr_ville, count(id_empr) as nbre  FROM empr where empr_cp like '{$user_input}%' group by empr_cp, empr_ville ORDER BY empr_cp, empr_ville LIMIT {$debut},{$nb_per_page} ";
        }
        $res = pmb_mysql_query($requete, $dbh);
        while ($cp_ville = pmb_mysql_fetch_object($res)) {
            print "<div class='row'>";
            print pmb_bidi("<a href='#' onclick=\"set_parent('{$caller}', '" . htmlentities(addslashes($cp_ville->empr_ville), ENT_QUOTES, $charset) . "', '" . htmlentities(addslashes($cp_ville->empr_cp), ENT_QUOTES, $charset) . "')\">{$cp_ville->empr_cp} - {$cp_ville->empr_ville} : {$cp_ville->nbre}</a>");
            print "</div>";
        }
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage de la pagination
        print "<hr /><div align='center'>";
        $url_base = $base_url . "&rech_regexp={$rech_regexp}&user_input=" . rawurlencode(stripslashes($user_input));
        $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
        print $nav_bar;
        print '</div>';
    }
}

 function get_primaldata()
 {
     global $dbh;
     $requete = "SELECT * FROM series WHERE serie_id='" . addslashes($this->id) . "' ";
     $result = @pmb_mysql_query($requete, $dbh);
     if (pmb_mysql_num_rows($result)) {
         $obj = pmb_mysql_fetch_object($result);
         pmb_mysql_free_result($result);
         $this->get_primaldatafrom($obj);
     } else {
         // pas de collection avec cette clé
         $this->id = 0;
         $this->name = '';
         $this->index = '';
     }
 }

function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $msg;
    global $charset;
    global $idaction;
    global $current_note;
    $user_input = str_replace('*', '%', $user_input);
    if ($user_input == "") {
        $req_count = "select count(1) from demandes_notes where num_action='" . $idaction . "' and id_note !='" . $current_note . "'";
    } else {
        $req_count = "select count(1) from demandes_notes where num_action='" . $idaction . "' and contenu like '%" . $user_input . "%' and id_note !='" . $current_note . "'";
    }
    $res = pmb_mysql_query($req_count, $dbh);
    $nbr_lignes = @pmb_mysql_result($res, 0, 0);
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if ($user_input == "") {
            $req = "select id_note, date_note, CONCAT(SUBSTRING(contenu,1,50),'','...') as note from demandes_notes where num_action='" . $idaction . "' and id_note !='" . $current_note . "'";
        } else {
            $req = "select id_note, date_note, CONCAT(SUBSTRING(contenu,1,50),'','...') as note from demandes_notes where num_action='" . $idaction . "' and contenu like '%" . $user_input . "%' and id_note !='" . $current_note . "'";
        }
        $res = pmb_mysql_query($req, $dbh);
        while ($note = pmb_mysql_fetch_object($res)) {
            print "<div class='row'>";
            print "<a href='#' onclick=\"set_parent('{$caller}', '{$note->id_note}', '" . htmlentities(addslashes($note->note), ENT_QUOTES, $charset) . "')\"> [" . htmlentities(formatdate($note->date_note), ENT_QUOTES, $charset) . '] ' . htmlentities($note->note, ENT_QUOTES, $charset) . "</a>";
            print "</div>";
        }
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
    }
    print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
    $url_base = $base_url . "&user_input=" . rawurlencode(stripslashes($user_input));
    $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
    print $nav_bar;
    print "</div>";
}

 protected function _get_notices_ids()
 {
     if (!$this->searched) {
         $query = $this->_get_search_query();
         $this->notices_ids = "";
         $res = pmb_mysql_query($query);
         if ($res && pmb_mysql_num_rows($res)) {
             while ($row = pmb_mysql_fetch_object($res)) {
                 if ($this->notices_ids != "") {
                     $this->notices_ids .= ",";
                 }
                 $this->notices_ids .= $row->num_obj;
             }
             pmb_mysql_free_result($res);
         }
         $this->searched = true;
     }
     return $this->notices_ids;
 }

 function getData()
 {
     global $dbh;
     if (!$this->id_classement) {
         $this->type_classement = 'BAN';
         $this->nom_classement = '';
     } else {
         $requete = "SELECT type_classement, nom_classement FROM classements WHERE id_classement='{$this->id_classement}' ";
         $result = @pmb_mysql_query($requete, $dbh);
         if (pmb_mysql_num_rows($result)) {
             $temp = pmb_mysql_fetch_object($result);
             pmb_mysql_free_result($result);
             $this->type_classement = $temp->type_classement;
             $this->nom_classement = $temp->nom_classement;
         } else {
             $this->id_classement = 0;
             $this->type_classement = '';
             $this->nom_classement = '';
         }
     }
 }

 function getData()
 {
     global $dbh;
     if (!$this->idemprcaddie) {
         // pas d'identifiant.
         $this->name = '';
         $this->comment = '';
         $this->nb_item = 0;
         $this->autorisations = "";
         $this->classementGen = "";
     } else {
         $requete = "SELECT * FROM empr_caddie WHERE idemprcaddie='{$this->idemprcaddie}' ";
         $result = @pmb_mysql_query($requete, $dbh);
         if (pmb_mysql_num_rows($result)) {
             $temp = pmb_mysql_fetch_object($result);
             pmb_mysql_free_result($result);
             $this->idemprcaddie = $temp->idemprcaddie;
             $this->name = $temp->name;
             $this->comment = $temp->comment;
             $this->autorisations = $temp->autorisations;
             $this->classementGen = $temp->empr_caddie_classement;
             //liaisons
             $req = "SELECT id_planificateur, num_type_tache, libelle_tache FROM planificateur WHERE num_type_tache=8 AND param REGEXP 's:11:\"empr_caddie\";s:[0-9]+:\"" . $this->idemprcaddie . "\";'";
             $res = pmb_mysql_query($req, $dbh);
             if ($res && pmb_mysql_num_rows($res)) {
                 while ($ligne = pmb_mysql_fetch_object($res)) {
                     $this->liaisons["mailing"][] = array("id" => $ligne->id_planificateur, "id_bis" => $ligne->num_type_tache, "lib" => $ligne->libelle_tache);
                 }
             }
         } else {
             // pas de caddie avec cet id
             $this->idemprcaddie = 0;
             $this->name = '';
             $this->comment = '';
             $this->autorisations = "";
             $this->classementGen = "";
         }
         $this->compte_items();
     }
 }

 function do_header()
 {
     global $dbh;
     global $charset;
     global $pmb_notice_reduit_format;
     global $base_path;
     global $msg;
     $aut1_libelle = array();
     // récupération du titre de série
     if ($this->notice->is_article) {
         $this->header = $this->notice->serie_name;
         if ($this->notice->bull_num && $this->notice->bull_periode) {
             $this->header .= " (" . $this->notice->bull_num . " - " . $this->notice->bull_periode . ")";
         } elseif ($this->notice->bull_num) {
             $this->header .= " (" . $this->notice->bull_num . ")";
         } elseif ($this->notice->bull_periode) {
             $this->header .= " (" . $this->notice->bull_periode . ")";
         }
     } elseif ($this->notice->serie_name) {
         $this->tit_serie = $this->notice->serie_name;
         $this->header = $this->tit_serie;
         if ($this->notice->tnvol) {
             $this->header .= ', ' . $this->notice->tnvol;
         }
     }
     $this->tit1 = $this->notice->tit1;
     $this->header ? $this->header .= '. ' . $this->tit1 : ($this->header = $this->tit1);
     if ($this->source_name) {
         $this->header = $this->source_name . " : " . $this->header;
     }
     //on ajoute la checkbox pour l'intégration en lot...
     //calcul de la checkbox
     $checkbox = "<input type='checkbox' name='external_notice_to_integer[]' value='" . $this->notice_id . "'";
     //on commence par regarder si cette notice n'a pas déjà été intégrér
     $query = "select rid from notices_externes join external_count on external_count.recid = notices_externes.recid where rid=" . $this->notice_id;
     $result = pmb_mysql_query($query);
     if (pmb_mysql_num_rows($result)) {
         $checkbox .= " checked='checked' disabled='disabled'";
     }
     $checkbox .= "/>";
     //ajout dans le header;
     $this->header = $checkbox . "&nbsp;" . $this->header;
     //$this->responsabilites
     $as = array_search("0", $this->responsabilites["responsabilites"]);
     if ($as !== FALSE && $as !== NULL) {
         $auteur_0 = $this->responsabilites["auteurs"][$as];
         //$auteur = new auteur($auteur_0["id"]);
         if ($auteur_0["auteur_isbd"]) {
             $this->header .= ' / ' . $auteur_0["auteur_titre"];
         }
     } else {
         $as = array_keys($this->responsabilites["responsabilites"], "1");
         for ($i = 0; $i < count($as); $i++) {
             $indice = $as[$i];
             $auteur_1 = $this->responsabilites["auteurs"][$indice];
             $aut1_libelle[] = $auteur_1["auteur_titre"];
         }
         $auteurs_liste = implode("; ", $aut1_libelle);
         if ($auteurs_liste) {
             $this->header .= ' / ' . $auteurs_liste;
         }
     }
     switch ($pmb_notice_reduit_format) {
         case "1":
             if ($this->notice->year != '') {
                 $this->header .= ' (' . htmlentities($this->notice->year, ENT_QUOTES, $charset) . ')';
             }
             break;
         case "2":
             if ($this->notice->year != '') {
                 $this->header .= ' (' . htmlentities($this->notice->year, ENT_QUOTES, $charset) . ')';
             }
             if ($this->notice->code != '') {
                 $this->header .= ' / ' . htmlentities($this->notice->code, ENT_QUOTES, $charset);
             }
             break;
         default:
             break;
     }
     if ($this->drag) {
         $drag = "<span id=\"NOTI_drag_" . $this->notice_id . ($this->anti_loop ? "_p" . $this->anti_loop[count($this->anti_loop) - 1] : "") . "\"  dragicon=\"{$base_path}/images/icone_drag_notice.png\" dragtext=\"" . $this->header . "\" draggable=\"yes\" dragtype=\"notice\" callback_before=\"show_carts\" callback_after=\"\" style=\"padding-left:7px\"><img src=\"" . $base_path . "/images/notice_drag.png\"/></span>";
     }
     if ($this->action) {
         $this->header = "<a href=\"" . $this->action . "\">" . $this->header . '</a>';
     }
     if ($this->notice->niveau_biblio == 'b') {
         $rqt = "select tit1 from bulletins,notices where bulletins.num_notice='" . $this->notice_id . "' and notices.notice_id=bulletins.bulletin_notice";
         $execute_query = pmb_mysql_query($rqt);
         $row = pmb_mysql_fetch_object($execute_query);
         $this->header .= " <i>" . str_replace("%s", $row->tit1, $msg["bul_titre_perio"]) . "</i>";
         pmb_mysql_free_result($execute_query);
     }
     if ($this->notice->lien) {
         // ajout du lien pour les ressourcenotice_parent_useds électroniques
         $this->header .= "<a href=\"" . $this->notice->lien . "\" target=\"__LINK__\">";
         global $use_opac_url_base, $opac_url_base;
         if (!$use_opac_url_base) {
             $this->header .= "<img src=\"./images/globe.gif\" border=\"0\" align=\"middle\" hspace=\"3\"";
         } else {
             $this->header .= "<img src=\"" . $opac_url_base . "images/globe.gif\" border=\"0\" align=\"middle\" hspace=\"3\"";
//.........这里部分代码省略.........