PHP pmb_mysql_error函数代码示例

function traite_rqt($requete = "", $message = "")
{
    global $dbh, $charset;
    $retour = "";
    /*if($charset == "utf-8"){ //Contrairement au addon ce n'est pas à faire car dans les fichiers alter_vX.inc.php on fait un set names latin1
    		$requete=utf8_encode($requete);
    	}*/
    $res = pmb_mysql_query($requete, $dbh);
    $erreur_no = pmb_mysql_errno();
    if (!$erreur_no) {
        $retour = "Successful";
    } else {
        switch ($erreur_no) {
            case "1060":
                $retour = "Field already exists, no problem.";
                break;
            case "1061":
                $retour = "Key already exists, no problem.";
                break;
            case "1091":
                $retour = "Object already deleted, no problem.";
                break;
            default:
                $retour = "<font color=\"#FF0000\">Error may be fatal : <i>" . pmb_mysql_error() . "<i></font>";
                break;
        }
    }
    return "<tr><td><font size='1'>" . ($charset == "utf-8" ? utf8_encode($message) : $message) . "</font></td><td><font size='1'>" . $retour . "</font></td></tr>";
}

 function getData()
 {
     global $dbh;
     if (!$this->s_id) {
         // pas d'identifiant. on retourne un tableau vide
         $this->s_id = 0;
         $this->name = '';
         $this->index = '';
         $this->num_statut = 1;
     } else {
         $requete = "SELECT * FROM series WHERE serie_id='" . $this->s_id . "' ";
         $result = pmb_mysql_query($requete, $dbh) or die($requete . "<br />" . pmb_mysql_error());
         if (pmb_mysql_num_rows($result)) {
             $temp = pmb_mysql_fetch_object($result);
             $this->s_id = $temp->serie_id;
             $this->name = $temp->serie_name;
             $this->index = $temp->serie_index;
             $authority = new authority(0, $this->s_id, AUT_TABLE_SERIES);
             $this->num_statut = $authority->get_num_statut();
             // Ajoute un lien sur la fiche série si l'utilisateur à accès aux autorités
             if (SESSrights & AUTORITES_AUTH) {
                 //$this->isbd_entry_lien_gestion = "<a href='./autorites.php?categ=series&sub=serie_form&id=".$this->s_id."' class='lien_gestion'>".$this->name."</a>";
                 $this->isbd_entry_lien_gestion = "<a href='./autorites.php?categ=see&sub=serie&id=" . $this->s_id . "' class='lien_gestion'>" . $this->name . "</a>";
             } else {
                 $this->isbd_entry_lien_gestion = $this->name;
             }
         } else {
             // pas de titre avec cette clé
             $this->s_id = 0;
             $this->name = '';
             $this->index = '';
             $this->num_statut = 1;
         }
     }
 }

 function getData()
 {
     global $dbh;
     if (!$this->indexint_id) {
         if ($this->name) {
             // rech par cote et non par $id
             $requete = "SELECT indexint_id,indexint_name,indexint_comment,num_pclass FROM indexint WHERE indexint_name='" . $this->name . "' ";
             $result = pmb_mysql_query($requete, $dbh) or die($requete . "<br />" . pmb_mysql_error());
             if (pmb_mysql_num_rows($result)) {
                 $temp = pmb_mysql_fetch_object($result);
                 $this->indexint_id = $temp->indexint_id;
                 $this->name = $temp->indexint_name;
                 $this->comment = $temp->indexint_comment;
                 $this->pclass = $temp->num_pclass;
                 if ($this->comment) {
                     $this->display = $this->name . " ({$this->comment})";
                 } else {
                     $this->display = $this->name;
                 }
             } else {
                 // pas de titre avec cette clé
                 $this->indexint_id = 0;
                 $this->name = '';
                 $this->comment = '';
                 $this->pclass = 0;
                 $this->display = "";
             }
         } else {
             // pas d'identifiant. on retourne un tableau vide
             $this->indexint_id = 0;
             $this->name = '';
             $this->comment = '';
             $this->pclass = 0;
             $this->display = "";
         }
     } else {
         $requete = "SELECT indexint_id,indexint_name,indexint_comment,num_pclass FROM indexint WHERE indexint_id='" . $this->indexint_id . "' ";
         $result = pmb_mysql_query($requete, $dbh) or die($requete . "<br />" . pmb_mysql_error());
         if (pmb_mysql_num_rows($result)) {
             $temp = pmb_mysql_fetch_object($result);
             $this->indexint_id = $temp->indexint_id;
             $this->name = $temp->indexint_name;
             $this->comment = $temp->indexint_comment;
             $this->pclass = $temp->num_pclass;
             if ($this->comment) {
                 $this->display = $this->name . " ({$this->comment})";
             } else {
                 $this->display = $this->name;
             }
         } else {
             // pas de titre avec cette clé
             $this->indexint_id = 0;
             $this->name = '';
             $this->comment = '';
             $this->pclass = 0;
             $this->display = "";
         }
     }
     $this->cherche_child();
 }

function traite_rqt($requete = "", $message = "")
{
    global $dbh, $charset;
    $retour = "";
    if ($charset == "utf-8") {
        $requete = utf8_encode($requete);
    }
    $res = pmb_mysql_query($requete, $dbh);
    $erreur_no = pmb_mysql_errno();
    if (!$erreur_no) {
        $retour = "Successful";
    } else {
        switch ($erreur_no) {
            case "1060":
                $retour = "Field already exists, no problem.";
                break;
            case "1061":
                $retour = "Key already exists, no problem.";
                break;
            case "1091":
                $retour = "Object already deleted, no problem.";
                break;
            default:
                $retour = "<font color=\"#FF0000\">Error may be fatal : <i>" . pmb_mysql_error() . "<i></font>";
                break;
        }
    }
    return "<tr><td><font size='1'>" . ($charset == "utf-8" ? utf8_encode($message) : $message) . "</font></td><td><font size='1'>" . $retour . "</font></td></tr>";
}

function cpt_transferts($clause_where)
{
    global $deflt_docs_location;
    global $msg;
    $rqt = "SELECT 1 " . "FROM transferts " . "INNER JOIN transferts_demande ON id_transfert = num_transfert " . "WHERE " . $clause_where . " " . "LIMIT 1";
    //echo $rqt."<br />";
    $req = pmb_mysql_query($rqt) or die($msg["err_sql"] . "<br />" . $rqt . "<br />" . pmb_mysql_error());
    $nb_limite = pmb_mysql_num_rows($req);
    return $nb_limite;
}

function my_error($echo = 1)
{
    if (!pmb_mysql_errno()) {
        return "";
    }
    $erreur = 'erreur ' . pmb_mysql_errno() . ' : ' . pmb_mysql_error() . '<br />';
    if ($echo) {
        echo $erreur;
    } else {
        trigger_error($erreur, E_USER_ERROR);
        return $erreur;
    }
}

function alerte_demandes()
{
    global $dbh;
    global $msg;
    // comptage des demandes à valider
    $sql = " SELECT 1 FROM demandes where etat_demande=1 limit 1";
    $req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
    $nb_limite = pmb_mysql_num_rows($req);
    if (!$nb_limite) {
        return "";
    } else {
        return "<li><a href='./demandes.php?categ=list&idetat=1' target='_parent'>{$msg['alerte_demandes_traiter']}</a></li>";
    }
}

 static function get_info_surloc_from_location($id_docs_location = 0)
 {
     global $dbh;
     if ($id_docs_location) {
         $requete = "SELECT * FROM docs_location where idlocation='{$id_docs_location}'";
         $res = pmb_mysql_query($requete, $dbh) or die(pmb_mysql_error() . "<br />{$requete}");
         if (pmb_mysql_num_rows($res)) {
             $row = pmb_mysql_fetch_object($res);
             if ($row->surloc_num) {
                 $sur_loc = new sur_location($row->surloc_num);
                 return $sur_loc;
             }
         }
     }
     return $sur_loc = new sur_location();
 }

function expl_retour_todo()
{
    global $dbh;
    global $msg;
    global $deflt_docs_location;
    if (!$deflt_docs_location) {
        return "";
    }
    $sql = "SELECT expl_id FROM exemplaires where expl_retloc='{$deflt_docs_location}' limit 1";
    $req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
    $nb = pmb_mysql_num_rows($req);
    if (!$nb) {
        return "";
    } else {
        return "<li><a href='./circ.php?categ=ret_todo' target='_parent'>" . $msg["alert_circ_retour_todo"] . "</a></li>";
    }
}

function alerte_sugg()
{
    global $dbh;
    global $msg;
    global $opac_show_suggest;
    if (!$opac_show_suggest) {
        return "";
    }
    // comptage des tags à valider
    $sql = " SELECT 1 FROM suggestions where statut=1 limit 1";
    $req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
    $nb_limite = pmb_mysql_num_rows($req);
    if (!$nb_limite) {
        return "";
    } else {
        return "<li><a href='./acquisition.php?categ=sug&action=list&statut=1' target='_parent'>{$msg['alerte_suggestion_traiter']}</a></li>";
    }
}

function alerte_avis()
{
    global $dbh;
    global $msg;
    global $opac_avis_allow;
    if (!$opac_avis_allow) {
        return "";
    }
    // comptage des avis à valider
    $sql = " SELECT 1 FROM avis where valide=0 limit 1";
    $req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
    $nb_depasse = pmb_mysql_num_rows($req);
    if (!$nb_depasse) {
        return "";
    } else {
        return "<li><a href='./catalog.php?categ=avis' target='_parent'>{$msg['alerte_avis_a_valider']}</a></li>";
    }
}

function get_info_expl($cb_doc)
{
    global $dbh, $msg;
    $requete = "SELECT notices_m.notice_id as m_id, notices_s.notice_id as s_id, expl_cb, expl_cote, expl_location,pret_date, pret_retour, tdoc_libelle, section_libelle, location_libelle, trim(concat(ifnull(notices_m.tit1,''),ifnull(notices_s.tit1,''),' ',ifnull(bulletin_numero,''), if (mention_date, concat(' (',mention_date,')') ,''))) as tit, ";
    $requete .= " date_format(pret_date, '" . $msg["format_date"] . "') as aff_pret_date, ";
    $requete .= " date_format(pret_retour, '" . $msg["format_date"] . "') as aff_pret_retour, ";
    $requete .= " IF(pret_retour>sysdate(),0,1) as retard, notices_m.tparent_id, notices_m.tnvol ";
    $requete .= " FROM (((exemplaires LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id), docs_type, docs_section, docs_location, pret ";
    $requete .= " WHERE expl_cb='" . $cb_doc . "' and expl_typdoc = idtyp_doc and expl_section = idsection and expl_location = idlocation and pret_idexpl = expl_id  ";
    $res = pmb_mysql_query($requete, $dbh) or die("<br />" . pmb_mysql_error());
    $expl = pmb_mysql_fetch_object($res);
    $responsabilites = get_notice_authors($expl->m_id + $expl->s_id);
    $as = array_search("0", $responsabilites["responsabilites"]);
    if ($as !== FALSE && $as !== NULL) {
        $auteur_0 = $responsabilites["auteurs"][$as];
        $auteur = new auteur($auteur_0["id"]);
        $header_aut .= $auteur->isbd_entry;
    } else {
        $aut1_libelle = array();
        $as = array_keys($responsabilites["responsabilites"], "1");
        for ($i = 0; $i < count($as); $i++) {
            $indice = $as[$i];
            $auteur_1 = $responsabilites["auteurs"][$indice];
            $auteur = new auteur($auteur_1["id"]);
            $aut1_libelle[] = $auteur->isbd_entry;
        }
        $header_aut .= implode(", ", $aut1_libelle);
    }
    $header_aut ? $auteur = " / " . $header_aut : ($auteur = "");
    $expl->header_aut = $header_aut;
    // récupération du titre de série
    if ($expl->tparent_id && $expl->m_id) {
        $parent = new serie($expl->tparent_id);
        $tit_serie = $parent->name;
        if ($expl->tnvol) {
            $tit_serie .= ', ' . $expl->tnvol;
        }
    }
    if ($tit_serie) {
        $expl->tit = $tit_serie . '. ' . $expl->tit;
    }
    return $expl;
}

 static function add_days($dd, $md, $yd, $days)
 {
     global $pmb_utiliser_calendrier;
     global $deflt2docs_location;
     if ($pmb_utiliser_calendrier) {
         $requete = "select min(date_ouverture) from ouvertures where ouvert=1 and num_location={$deflt2docs_location} and date_ouverture>=adddate('" . $yd . "-" . $md . "-" . $dd . "', interval {$days} day)";
         $resultat = pmb_mysql_query($requete) or die($requete . " " . pmb_mysql_error());
         if (!@pmb_mysql_num_rows($resultat)) {
             $requete = "select adddate('" . $yd . "-" . $md . "-" . $dd . "', interval {$days} day)";
             $resultat = pmb_mysql_query($requete) or die($requete . " " . pmb_mysql_error());
         }
         if ($date = pmb_mysql_result($resultat, 0, 0)) {
             return $date;
         }
     }
     $requete = "select adddate('" . $yd . "-" . $md . "-" . $dd . "', interval {$days} day)";
     $resultat = pmb_mysql_query($requete) or die($requete . " " . pmb_mysql_error());
     $date = pmb_mysql_result($resultat, 0, 0);
     return $date;
 }

function empr_categ_change()
{
    global $dbh;
    global $msg;
    global $pmb_lecteurs_localises, $deflt2docs_location;
    // comptage des emprunteurs qui n'ont pas le droit d'être dans la catégorie
    $sql = "select 1 from empr left join empr_categ on empr_categ = id_categ_empr ";
    $sql .= " where ((((age_min<> 0) || (age_max <> 0)) && (age_max >= age_min)) && (((DATE_FORMAT( curdate() , '%Y' )-empr_year) < age_min) || ((DATE_FORMAT( curdate() , '%Y' )-empr_year) > age_max)))";
    // restriction localisation le cas échéant
    if ($pmb_lecteurs_localises) {
        $sql .= " AND empr_location='{$deflt2docs_location}' ";
    }
    $req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
    $nb_change = pmb_mysql_num_rows($req);
    if (!$nb_change) {
        return "";
    } else {
        return "<li><a href='./edit.php?categ=empr&sub=categ_change' target='_parent'>{$msg['empr_change_categ_todo']}</a></li>";
    }
}

 function getData()
 {
     global $dbh;
     if ($this->idlender == "") {
         // pas d'identifiant. on retourne un tableau vide
         $this->idlender = 0;
         $this->lender_libelle = "";
     } else {
         $requete = "SELECT idlender, lender_libelle FROM lenders WHERE idlender='" . $this->idlender . "' LIMIT 1 " or die(pmb_mysql_error());
         $result = pmb_mysql_query($requete, $dbh);
         if (pmb_mysql_num_rows($result)) {
             $temp = pmb_mysql_fetch_object($result);
             $this->idlender = $temp->idlender;
             $this->lender_libelle = $temp->lender_libelle;
         } else {
             // pas de lender avec cette clé
             $this->idlender = 0;
             $this->lender_libelle = "";
         }
     }
 }