本文整理汇总了PHP中pmb_mysql_free_result函数的典型用法代码示例。如果您正苦于以下问题：PHP pmb_mysql_free_result函数的具体用法？PHP pmb_mysql_free_result怎么用？PHP pmb_mysql_free_result使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了pmb_mysql_free_result函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: get_primaldata
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 = '';
}
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:25，代码来源:subcollection.class.php
示例2: get_primaldata
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 = '';
}
}
开发者ID:hogsim，项目名称:PMB，代码行数:29，代码来源:author.class.php
示例3: getData
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 = '';
}
}
}
开发者ID:hogsim，项目名称:PMB，代码行数:58，代码来源:etagere.class.php
示例4: getData
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 = "";
}
}
}
开发者ID:hogsim，项目名称:PMB，代码行数:57，代码来源:collection.class.php
示例5: show_results
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 . " " . $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'> <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>";
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:54，代码来源:perio.inc.php
示例6: show_results
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>';
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:53，代码来源:types_produits.inc.php
示例7: dsi_list_classements
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 "";
}
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:50，代码来源:func_clas.inc.php
示例8: affiche_notice_navigopac
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\"> </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>';
}
开发者ID:hogsim，项目名称:PMB，代码行数:49，代码来源:show_localisation.inc.php
示例9: show_results
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>';
}
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:48，代码来源:codepostal.inc.php
示例10: get_primaldata
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 = '';
}
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:16，代码来源:serie.class.php
示例11: show_results
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'> <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>";
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:46，代码来源:notes.inc.php
示例12: _get_notices_ids
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;
}
开发者ID:hogsim，项目名称:PMB，代码行数:19，代码来源:cms_editorial_searcher.class.php
示例13: getData
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 = '';
}
}
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:21，代码来源:classements.class.php
示例14: getData
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();
}
}
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:40，代码来源:empr_caddie.class.php
示例15: do_header
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 . " " . $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\"";
//.........这里部分代码省略.........
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:101，代码来源:mono_display_unimarc.class.php
示例16: get_info_editeur
function get_info_editeur($id)
{
$info = array();
if ($id) {
$requete = "SELECT * FROM publishers WHERE ed_id={$id} LIMIT 1 ";
$result = @pmb_mysql_query($requete);
if ($result && pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
pmb_mysql_free_result($result);
$id = $temp->ed_id;
$name = $temp->ed_name;
$adr1 = $temp->ed_adr1;
$adr2 = $temp->ed_adr2;
$cp = $temp->ed_cp;
$ville = $temp->ed_ville;
$pays = $temp->ed_pays;
$web = $temp->ed_web;
$ed_comment = $temp->ed_comment;
// Determine le lieu de publication
$l = '';
if ($adr1) {
$l = $adr1;
}
if ($adr2) {
$l = $l == '' ? $adr2 : $l . ', ' . $adr2;
}
if ($cp) {
$l = $l == '' ? $cp : $l . ', ' . $cp;
}
if ($pays) {
$l = $l == '' ? $pays : $l . ', ' . $pays;
}
if ($ville) {
$l = $l == '' ? $ville : $ville . ' (' . $l . ')';
}
if ($l == '') {
$l = '[S.l.]';
}
// Determine le nom de l'editeur
if ($name) {
$n = $name;
} else {
$n = '[S.n.]';
}
// Constitue l'ISBD pour le coupe lieu/editeur
if ($l == '[S.l.]' and $n == '[S.n.]') {
$isbd_entry = '[S.l. : s.n.]';
} else {
$isbd_entry = $l . ' : ' . $n;
}
$info['isbd_entry'] = $isbd_entry;
$info['name'] = $name;
$info['place'] = $l;
}
}
return $info;
}
开发者ID:hogsim，项目名称:PMB，代码行数:57，代码来源:notice_info.class.php
示例17: while
while ($j = pmb_mysql_fetch_array($resultat_droits_expl)) {
$temp .= $j["idlocation"] . ",";
$visibilite_expl_user .= "\n\t\t\t<div class='row'>\n\t\t\t\t<div class='colonne3' align='right'>" . $j["location_libelle"] . " : </div>\n\t\t\t\t<div class='colonne_suite'> <select name=\"form_expl_visibilite_" . $j["idlocation"] . "\">\n\t\t\t";
$as_invis = array_search($j["idlocation"], $explr_tab_invis);
$as_unmod = array_search($j["idlocation"], $explr_tab_unmod);
$as_mod = array_search($j["idlocation"], $explr_tab_modif);
$visibilite_expl_user .= "\n<option value='explr_invisible' " . ($as_invis !== FALSE && $as_invis !== NULL ? "selected='selected' " : "") . ">" . $msg["explr_invisible"] . "</option>";
if ($as_mod !== FALSE && $as_mod !== NULL || $as_unmod !== FALSE && $as_unmod !== NULL || $as_invis !== FALSE && $as_invis !== NULL) {
$visibilite_expl_user .= "\n<option value='explr_visible_unmod' " . ($as_unmod !== FALSE && $as_unmod !== NULL ? "selected='selected' " : "") . ">" . $msg["explr_visible_unmod"] . "</option>";
} else {
$visibilite_expl_user .= "\n<option value='explr_visible_unmod' selected='selected' >" . $msg["explr_visible_unmod"] . "</option>";
}
$visibilite_expl_user .= "\n<option value='explr_visible_mod' " . ($as_mod !== FALSE && $as_mod !== NULL ? "selected='selected' " : "") . ">" . $msg["explr_visible_mod"] . "</option>";
$visibilite_expl_user .= "</select></div></div>\n";
}
pmb_mysql_free_result($resultat_droits_expl);
if (!$explr_invisible && !$explr_visible_unmod && !$explr_visible_mod) {
$rqt = "UPDATE users SET explr_invisible=0,explr_visible_mod=0,explr_visible_unmod='" . substr($temp, 0, strlen($temp) - 1) . "' WHERE userid={$id}";
@pmb_mysql_query($rqt);
}
$deflt_user .= $visibilite_expl_user;
}
//fin visibilité des exemplaires
$param_default = "\n<div class='row'><hr /></div>\n\t\t{$param_user}\n\t<div class='row'><hr /></div>\n\t\t" . str_replace("!!param_allloc!!", $param_user_allloc, $deflt_user) . "\n\t<br />\n\t<div class='row'><hr /></div>\n\t\t{$value_user}\n\t<div class='row'><hr /></div>\n\t\t{$deflt_user_style}\n\t<br />";
if ($speci_user || $deflt3user) {
$param_default .= "<div class='row'><hr /></div>";
$param_default .= $deflt3user;
$param_default .= $speci_user;
$param_default .= "<div class='row'></div>";
}
echo window_title($msg[1003] . $msg[18] . $msg[1003] . $msg[86] . $msg[1003] . $usr->username . $msg[1001]);
开发者ID:noble82，项目名称:proyectos-ULS，代码行数:31，代码来源:user_modif.inc.php
-
librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam
阅读：1215|2022-08-30
-
avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave
阅读：1124|2022-08-17
-
女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的
阅读：934|2022-11-06
-
medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho
阅读：1331|2022-08-18
-
http://blog.sina.com.cn/s/blog_45b486b80100g45a.html
阅读：515|2022-07-18
-
ZeosLibhttp://sourceforge.net/projects/zeoslib一套开源的数据库控件，可以支持多数
阅读：697|2022-07-18
-
In Bluetooth, there is a possible out of bounds write due to a missing bounds ch
阅读：945|2022-07-08
-
sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor
阅读：483|2022-08-16
-
fabric8io/jenkins-pipeline-library: a collection of reusable jenkins pipelines a
阅读：688|2022-08-15
-
离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾
阅读：633|2022-11-06
|
客服电话
APP下载
官方微信
请发表评论