当前位置: 首页>>代码示例>>PHP>>正文


PHP aff_pagination函数代码示例

本文整理汇总了PHP中aff_pagination函数的典型用法代码示例。如果您正苦于以下问题:PHP aff_pagination函数的具体用法?PHP aff_pagination怎么用?PHP aff_pagination使用的例子?那么, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了aff_pagination函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: 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 . "&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>";
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:54,代码来源:perio.inc.php

示例2: 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 = mysql_query($requete, $dbh);
        $nbr_lignes = @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 = @mysql_query($requete, $dbh);
        $parity = 0;
        while ($clas = 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;
        }
        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:bouchra012,项目名称:PMB,代码行数:50,代码来源:func_clas.inc.php

示例3: 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 = mysql_query($requete, $dbh);
    $nbr_lignes = 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 = mysql_query($requete, $dbh);
        while ($cp_ville = 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>";
        }
        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:bouchra012,项目名称:PMB,代码行数:48,代码来源:codepostal.inc.php

示例4: 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'>&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>";
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:46,代码来源:notes.inc.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 $charset;
    global $msg;
    global $expl_list_id;
    // on récupére le nombre de lignes qui vont bien
    if (!$id) {
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM groupexpl";
        } 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;
            }
            $requete = "select count(distinct id_groupexpl) from groupexpl where groupexpl_name like '%" . $user_input . "%'";
        }
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = @pmb_mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $expl_list = explode(",", $expl_list_id);
        $expl_list_cb = array();
        foreach ($expl_list as $id_expl) {
            $query = "SELECT expl_cb FROM exemplaires WHERE expl_id='" . $id_expl . "'";
            $result = pmb_mysql_query($query);
            if ($result && pmb_mysql_num_rows($result)) {
                $cb = pmb_mysql_result($result, 0, 0);
                $expl_list_cb[] = $cb;
            }
        }
        $last_id_used = session::get_last_used("groupexpl");
        if ($last_id_used) {
            print "<div class='selector_last_used'>\n \t\t\t\t<div class='row'>\n \t\t\t\t\t<b>" . $msg["selector_last_groupexpl_used"] . "</b>\n \t\t\t\t</div>\n \t\t\t\t<div class='row'>";
            $query = "select id_groupexpl, groupexpl_name from groupexpl where id_groupexpl=" . $last_id_used;
            $result = pmb_mysql_query($query);
            while ($group = pmb_mysql_fetch_object($result)) {
                print pmb_bidi("\n\t\t\t\t\t\t<a href=\"{$base_url}&action=add_expl&id_groupexpl=" . $group->id_groupexpl . "&expl_list=" . implode(",", $expl_list_cb) . "\">\n\t\t\t\t\t\t{$group->groupexpl_name}</a><br />");
            }
            print "</div></div>";
        }
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT groupexpl.* FROM groupexpl";
                $requete .= " ORDER BY groupexpl_name LIMIT {$debut},{$nb_per_page} ";
            } else {
                $requete = "select groupexpl.* from groupexpl where groupexpl_name like '%" . $user_input . "%' order by groupexpl_name LIMIT {$debut},{$nb_per_page}";
            }
        } else {
            $requete = "select groupexpl.* FROM groupexpl where id_groupexpl='" . $id . "'";
        }
        $res = @pmb_mysql_query($requete, $dbh);
        while ($group = pmb_mysql_fetch_object($res)) {
            print pmb_bidi("\n \t\t\t<a href=\"{$base_url}&action=add_expl&id_groupexpl=" . $group->id_groupexpl . "&expl_list=" . implode(",", $expl_list_cb) . "\">\n\t\t\t\t\t{$group->groupexpl_name}</a><br />");
        }
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage 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>";
    }
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:78,代码来源:groupexpl.inc.php

示例6: 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 $no_display;
    global $charset;
    global $msg;
    global $callback;
    global $param1;
    // on récupére le nombre de lignes qui vont bien
    //	if($param1) $restrict=" and abt_id  not in (select num_serialcirc_abt from serialcirc) ";
    if (!$id) {
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM abts_abts where abt_id!='{$no_display}' {$restrict}";
        } else {
            $requete = "select count(distinct abt_id) from abts_abts where abt_name like '%abt%' and abt_id!='{$no_display}' {$restrict}";
        }
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = pmb_mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT * FROM abts_abts where abt_id!='{$no_display}' {$restrict} ";
                $requete .= "ORDER BY abt_name LIMIT {$debut},{$nb_per_page} ";
            } else {
                $requete = "SELECT * FROM abts_abts where  abt_name like '%{$user_input}%' and abt_id!='{$no_display}' {$restrict}";
                $requete .= "ORDER BY abt_name LIMIT {$debut},{$nb_per_page} ";
            }
        } else {
            $requete = "select * from abts_abts where abt_id='" . $id . "'";
        }
        print "<table>";
        $res = @pmb_mysql_query($requete, $dbh);
        while ($abt = pmb_mysql_fetch_object($res)) {
            $circlist_info = "";
            $flag_circlist_info = 0;
            $requete = "select id_serialcirc from serialcirc where num_serialcirc_abt=" . $abt->abt_id;
            $res_circlist = pmb_mysql_query($requete);
            print "<tr><td>";
            if (pmb_mysql_num_rows($res_circlist)) {
                $circlist_info = "<img align='top' title='" . $msg["serialcirc_img_info"] . "'  height='18' width='18' alt='" . $msg["serialcirc_img_info"] . "' src='./images/icon_a.gif'>";
                $flag_circlist_info = 1;
            }
            print "{$circlist_info}</td><td width='100%'>";
            $entry = $abt->abt_name;
            print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$abt->abt_id}', '" . htmlentities(addslashes($entry), ENT_QUOTES, $charset) . "','{$callback}',{$flag_circlist_info})\">\n\t\t\t\t{$entry}</a>");
            print "</td>";
        }
        print "</table>";
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage 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>";
    }
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:71,代码来源:abts.inc.php

示例7: show_list_sug


//.........这里部分代码省略.........
                $pair_impair = "odd";
            }
            $parity += 1;
            $tr_javascript_l1 = "onmouseover=\"this.className='surbrillance';this.parentNode.rows[this.rowIndex+1].className='surbrillance';\" onmouseout=\"this.className='" . $pair_impair . "';this.parentNode.rows[this.rowIndex+1].className='" . $pair_impair . "'\" ";
            $tr_javascript_l2 = "onmouseover=\"this.className='surbrillance';this.parentNode.rows[this.rowIndex-1].className='surbrillance';\" onmouseout=\"this.className='" . $pair_impair . "';this.parentNode.rows[this.rowIndex-1].className='" . $pair_impair . "'\" ";
            $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=sug&action=modif&id_bibli=" . $id_bibli . "&id_sug=" . $row->id_suggestion . "' \" ";
            if ($idempr) {
                $link_empr = "<a href='circ.php?categ=pret&id_empr={$idempr}'>";
                $link_empr_fin = "</a>";
            } else {
                $link_empr = "";
                $link_empr_fin = "";
            }
            $aff_row .= "<tr class='" . $pair_impair . "' " . $tr_javascript_l1 . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . formatdate($row->date_creation) . "<br />{$link_empr}" . htmlentities($lib_orig, ENT_QUOTES, $charset) . "{$link_empr_fin}</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . $col2 . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . $col3 . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . htmlentities($row->nb, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . htmlentities($row->prix, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >{$lib_statut}</td>";
            if (!$row->num_notice) {
                $aff_row .= "<td " . $dn_javascript . " ></td>";
            } else {
                $req_ana = "select analysis_bulletin as bull , analysis_notice as noti from analysis where analysis_notice ='" . $row->num_notice . "'";
                $res_ana = pmb_mysql_query($req_ana, $dbh);
                $num_rows_ana = pmb_mysql_num_rows($res_ana);
                if ($num_rows_ana) {
                    $ana = pmb_mysql_fetch_object($res_ana);
                    $url_view = "catalog.php?categ=serials&sub=bulletinage&action=view&bul_id={$ana->bull}&art_to_show=" . $ana->noti;
                } else {
                    $url_view = "./catalog.php?categ=isbd&id=" . $row->num_notice;
                }
                $aff_row .= "<td style='text-align:center;'><a href=\"" . $url_view . "\"><img border=\"0\" align=\"middle\" title=\"" . $msg['acquisition_sug_view_not'] . "\" alt=\"" . $msg['acquisition_sug_view_not'] . "\" src=\"./images/notice.gif\" /></a></td>";
            }
            $sug_src = new suggestion_source($row->sugg_source);
            if ($acquisition_sugg_categ == '1') {
                $categ = new suggestions_categ($row->num_categ);
                $aff_row .= "<td " . $dn_javascript . " >" . htmlentities($categ->libelle_categ, ENT_QUOTES, $charset) . "<br />" . htmlentities($sug_src->libelle_source, ENT_QUOTES, $charset) . "</td>";
                $colspan = '10';
            } else {
                $aff_row .= "<td " . $dn_javascript . " >" . htmlentities($sug_src->libelle_source, ENT_QUOTES, $charset) . "</td>";
                $colspan = '9';
            }
            $sug = new suggestions($row->id_suggestion);
            $img_pj = "<a href=\"{$base_path}/explnum_doc.php?explnumdoc_id=" . $sug->get_explnum('id') . "\" target=\"_LINK_\"><img src='{$base_path}/images/globe_orange.png' /></a>";
            $img_import = "<a href=\"{$base_path}/acquisition.php?categ=sug&sub=import&explnumdoc_id=" . $sug->get_explnum('id') . " \"><img src='{$base_path}/images/upload.gif' /></a>";
            $aff_row .= "<td align='center'><i>" . ($sug->get_explnum('id') ? "{$img_pj}&nbsp;{$img_import}" : '') . "</i></td>";
            $aff_row .= "<td ><input type='checkbox' id='chk[" . $row->id_suggestion . "]' name='chk[]' value='" . $row->id_suggestion . "' /></td>\n\t\t\t\t\t</tr>";
            $aff_row .= "\t\t<tr class='" . $pair_impair . "' " . $tr_javascript_l2 . " style='cursor: pointer' >\n\t\t\t\t\t\t<td colspan='" . $colspan . "' " . $dn_javascript . " ><i>" . htmlentities($row->commentaires, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t</tr>";
        }
        $sug_list_form = str_replace('<!-- sug_list -->', $aff_row, $sug_list_form);
        //Affichage des boutons
        //Bouton Imprimer
        $imp = "openPopUp('./pdf.php?pdfdoc=listsug&user_input=" . urlencode(stripslashes($user_input)) . "&statut=" . $statut . "&num_categ=" . $num_categ . "&sugg_location_id=" . $sugg_location_id . "' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');";
        $bt_imp = str_replace('!!imp!!', $imp, $bt_imp);
        $sug_list_form = str_replace('<!-- bt_imp -->', $bt_imp, $sug_list_form);
        //Génération de la liste des conversions possibles
        $catalog = _parser_text_no_function_(file_get_contents($base_path . "/admin/convert/imports/catalog.xml"), "CATALOG");
        $list_export = "<select name='export_list'>";
        for ($i = 0; $i < count($catalog["ITEM"]); $i++) {
            $item = $catalog["ITEM"][$i];
            if ($item["EXPORT"] == "yes") {
                $list_export .= "<option value='" . $i . "'>" . htmlentities($item["EXPORTNAME"], ENT_QUOTES, $charset) . "</option>\n";
            }
        }
        $list_export .= "</select>";
        $bt_exporter = str_replace("<!-- list_export -->", $list_export, $bt_exporter);
        //Lien vers la page suivante
        $link_export = "document.sug_list_form.action='acquisition.php?categ=sug&sub=export'; document.sug_list_form.submit();";
        $bt_exporter = str_replace("!!exp!!", $link_export, $bt_exporter);
        $sug_list_form = str_replace('<!-- bt_exporter -->', $bt_exporter, $sug_list_form);
        //Bouton Sélectionner
        $sug_list_form = str_replace('<!-- bt_chk -->', $bt_chk, $sug_list_form);
        //Liste Boutons
        $button_list = $sug_map->getButtonList($statut);
        $sug_list_form = str_replace('<!-- bt_list -->', $button_list, $sug_list_form);
        //Bouton Reprendre
        $bt_todo = $sug_map->getButtonList_TODO($statut);
        $sug_list_form = str_replace('<!-- bt_todo -->', $bt_todo, $sug_list_form);
        if ($acquisition_sugg_categ == '1') {
            //Selecteur Affecter a une categorie
            $to_categ = $sug_map->getCategModifier($statut, $num_categ, $nb_per_page);
        } else {
            $to_categ = "";
        }
        $sug_list_form = str_replace('<!-- to_categ -->', $to_categ, $sug_list_form);
        //Bouton Supprimer
        $button_sup = $sug_map->getButtonList_DELETED($statut);
        $sug_list_form = str_replace('<!-- bt_sup -->', $button_sup, $sug_list_form);
        //JavaScript
        $script_list = $sug_map->getScriptList($statut, $num_categ, $nb_per_page);
        $script = str_replace('<!-- script_list -->', $script_list, $script);
        $sug_list_form = str_replace('<!-- script -->', $script, $sug_list_form);
        //Barre de navigation
        if (!$last_param) {
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, true, true);
        } else {
            $nav_bar = "";
        }
        $sug_list_form = str_replace('<!-- nav_bar -->', $nav_bar, $sug_list_form);
        print $sug_list_form;
    } else {
        // la requête n'a produit aucun résultat
        error_message($msg['acquisition_sug_rech'], str_replace('!!sug_cle!!', stripslashes($user_input), $msg['acquisition_sug_rech_error']), 0, './categ=sug&sub=todo&action=list&id_bibli=' . $id_bibli);
    }
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:101,代码来源:suggestions_display_genes.inc.php

示例8: show_list_fac


//.........这里部分代码省略.........
    if (!$nbr_lignes) {
        if (!$user_input) {
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_FAC, $statut);
        } else {
            $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
            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;
            }
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_FAC, $statut, $aq, $user_input);
        }
    } else {
        $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $url_base = "{$PHP_SELF}?categ=ach&sub=fact&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}&sortBy={$sortBy}";
        // on lance la vraie requête
        if (!$user_input) {
            $res = entites::listActes($id_bibli, TYP_ACT_FAC, $statut, $debut, $nb_per_page, 0, '', $sortBy);
        } else {
            $res = entites::listActes($id_bibli, TYP_ACT_FAC, $statut, $debut, $nb_per_page, $aq, $user_input, $sortBy);
        }
        //Affichage liste des factures
        $fac_list = "";
        $nbr = pmb_mysql_num_rows($res);
        $parity = 1;
        for ($i = 0; $i < $nbr; $i++) {
            $row = pmb_mysql_fetch_object($res);
            $st = $row->statut & ~STA_ACT_ARC;
            switch ($st) {
                case STA_ACT_REC:
                    $st_fac = htmlentities($msg['acquisition_fac_rec'], ENT_QUOTES, $charset);
                    break;
                case STA_ACT_PAY:
                    $st_fac = htmlentities($msg['acquisition_fac_pay'], ENT_QUOTES, $charset);
                    break;
                default:
                    $st_fac = '';
            }
            if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
                $st_fac = '<s>' . $st_fac . '</s>';
            }
            if ($parity % 2) {
                $pair_impair = "even";
            } else {
                $pair_impair = "odd";
            }
            $parity += 1;
            $tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
            $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=fact&action=modif&id_bibli=" . $id_bibli . "&id_fac=" . $row->id_acte . "' \" ";
            $fac_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->num_acte_parent . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($row->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_fac}</i></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<a href=# onclick=\"openPopUp('./pdf.php?pdfdoc=fact&id_fac=" . $row->id_acte . "' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t</td>";
            if ($statut == STA_ACT_REC) {
                $fac_list .= "<td><input type='checkbox' name='chk[]' id='chk[" . $row->id_acte . "]' value='" . $row->id_acte . "'/></td>";
            }
            $fac_list .= "</tr>";
        }
        if (!$last_param) {
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, true, true);
        } else {
            $nav_bar = "";
        }
        $fieldList = array("1" => "numero", "2" => "num_acte_parent", "3" => "raison_sociale", "4" => "date_acte");
        foreach ($fieldList as $k => $field) {
            if ($sortBy == $field) {
                $faclist_form = str_replace('!!sortBy_' . $k . '_1!!', "-" . $field, $faclist_form);
                $faclist_form = str_replace('!!sortBy_' . $k . '_2!!', "&nbsp;&#x25B4;", $faclist_form);
            } elseif ($sortBy == "-" . $field) {
                $faclist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $faclist_form);
                $faclist_form = str_replace('!!sortBy_' . $k . '_2!!', "&nbsp;&#x25BE;", $faclist_form);
            } else {
                $faclist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $faclist_form);
                $faclist_form = str_replace('!!sortBy_' . $k . '_2!!', "", $faclist_form);
            }
        }
        $faclist_form = str_replace('<!-- fac_list -->', $fac_list, $faclist_form);
        $faclist_form = str_replace('<!-- nav_bar -->', $nav_bar, $faclist_form);
        $bt_list = '';
        $bt_sup = '';
        if ($statut == STA_ACT_REC) {
            //colonne chk
            $faclist_form = str_replace("<!-- chk_th -->", "<th class='act_cell_chkbox'>&nbsp;</th>", $faclist_form);
            //Bouton Sélectionner
            $faclist_form = str_replace('<!-- bt_chk -->', $faclist_bt_chk, $faclist_form);
            //JavaScript
            $faclist_form = str_replace('<!-- script -->', $faclist_script, $faclist_form);
            //bouton payer
            $bt_list = $faclist_bt_pay;
        }
        $faclist_form = str_replace('<!-- bt_list -->', $bt_list, $faclist_form);
        $faclist_form = str_replace('<!-- bt_sup -->', $bt_sup, $faclist_form);
        print $faclist_form;
    } else {
        // la requête n'a produit aucun résultat
        error_message($msg['acquisition_fac_rech'], str_replace('!!fac_cle!!', stripslashes($user_input), $msg['acquisition_fac_rech_error']), 0, './categ=ach&sub=fact&action=list&id_bibli=' . $id_bibli);
    }
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:101,代码来源:factures.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 $callback;
    global $charset;
    global $msg;
    global $no_display;
    // on récupére le nombre de lignes qui vont bien
    if (!$id) {
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM collections where collection_id!='{$no_display}' ";
        } 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;
            }
            $requete = $aq->get_query_count("collections", "collection_name", "index_coll", "collection_id", "collection_id!='{$no_display}'");
        }
        $res = mysql_query($requete, $dbh);
        $nbr_lignes = @mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT collections.*,publishers.* FROM collections, publishers WHERE collection_id!='{$no_display}' and ed_id=collection_parent group by collection_id";
                $requete .= " ORDER BY index_coll, index_publisher LIMIT {$debut},{$nb_per_page} ";
            } else {
                $members = $aq->get_query_members("collections", "collection_name", "index_coll", "collection_id");
                $requete = "select collections.*,publishers.*, " . $members["select"] . " as pert from collections, publishers where " . $members["where"] . " and collection_id!='{$no_display}' and ed_id=collection_parent group by collection_id order by pert desc, index_coll, index_publisher LIMIT {$debut},{$nb_per_page}";
            }
        } else {
            $requete = "select collections.*,publishers.* from collections,publishers where collection_id='" . $id . "' and collection_parent=ed_id group by collection_id";
        }
        $res = @mysql_query($requete, $dbh);
        while ($col = mysql_fetch_object($res)) {
            print pmb_bidi("\n \t\t\t<a href='#' onclick=\"set_parent('{$caller}', {$col->collection_id}, '" . htmlentities(addslashes($col->collection_name), ENT_QUOTES, $charset) . "', {$col->ed_id}, '" . htmlentities(addslashes($col->ed_name), ENT_QUOTES, $charset) . "','{$callback}')\">\n\t\t\t\t{$col->collection_name}</a>");
            print pmb_bidi(".&nbsp;{$col->ed_name}<br />");
        }
        mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage 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>";
    }
}
开发者ID:bouchra012,项目名称:PMB,代码行数:61,代码来源:collection.inc.php

示例10: stripslashes

                    $pair_impair = "even";
                } else {
                    $pair_impair = "odd";
                }
                $parity += 1;
                $liste_mots .= "<tr class='{$pair_impair}'><td><strong>" . stripslashes($r->mot) . "</strong></td>";
                $liste_mots .= "<td width='50%'>&nbsp;</td><td><input type='radio' id='type_lien2_" . $r->id_mot . "' name='type_lien2_" . $r->id_mot . "' onClick='modify_type_mot_vide(" . $r->id_mot . ",2);'";
                if ($r->type_lien == 2) {
                    $liste_mots .= " checked";
                }
                $liste_mots .= "></td><td><input type='radio' id='type_lien3_" . $r->id_mot . "' name='type_lien3_" . $r->id_mot . "' onClick='modify_type_mot_vide(" . $r->id_mot . ",3);'";
                if ($r->type_lien == 3) {
                    $liste_mots .= " checked";
                }
                $liste_mots .= "></td><td><input type='radio' id='type_lien4_" . $r->id_mot . "' name='type_lien4_" . $r->id_mot . "' onClick='modify_type_mot_vide(" . $r->id_mot . ",4);'";
                if ($r->type_lien == 4) {
                    $liste_mots .= " checked";
                }
                $liste_mots .= "></td><td><div class='right'><input type='button' class='bouton_small' value='" . $msg["63"] . "' onClick=\"response=confirm('" . $msg["word_del_confirm"] . "'); if (response) document.location='./autorites.php?categ=semantique&sub=empty_words&action=del&id_mot=" . $r->id_mot . "&type_lien=" . $r->type_lien . "';\"></div></td>";
                $liste_mots .= "</tr>\n";
            }
            //affichage de la pagination
            $autorites_list_empty_word = str_replace("!!pagination!!", "<div class='row'>" . aff_pagination($baseurl, $compt, $nb_per_page, $page) . "</div>", $autorites_list_empty_word);
        } else {
            $autorites_list_empty_word = str_replace("!!pagination!!", "", $autorites_list_empty_word);
        }
        $autorites_list_empty_word = str_replace("!!see_last_words!!", "<div class='right'><a href='./autorites.php?categ=semantique&sub=empty_words&action=last_words'>" . $msg["see_last_words_added"] . "</a></div>", $autorites_list_empty_word);
    }
    $autorites_list_empty_word = str_replace("!!liste_mots!!", $liste_mots, $autorites_list_empty_word);
    print $autorites_list_empty_word;
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:31,代码来源:dico_empty_words.inc.php

示例11: dsi_list_empr

function dsi_list_empr($form_cb = "", $ban_priv_seuls = 1)
{
    global $dbh, $msg;
    global $page, $nbr_lignes;
    global $dsi_list_tmpl, $empr_location_id;
    global $deflt2docs_location, $empr_location_id, $pmb_lecteurs_localises;
    if ($ban_priv_seuls) {
        $form_restrict_priv = " join bannettes on num_bannette=id_bannette ";
        $where_restrict_priv = " and  proprio_bannette=id_empr ";
    }
    $retour = array();
    // nombre de références par pages
    $nb_per_page = 10;
    if ($form_cb) {
        $form_cb_rech = str_replace("*", "%", $form_cb);
        $clause = "WHERE empr_nom like '{$form_cb_rech}%' and empr_categ=id_categ_empr";
        if ($pmb_lecteurs_localises && $empr_location_id) {
            $clause .= " and empr_location={$empr_location_id} ";
        }
    } else {
        $clause = "WHERE empr_categ=id_categ_empr";
    }
    if ($empr_location_id && $pmb_lecteurs_localises) {
        $clause .= " and empr_location='{$empr_location_id}' ";
    }
    if (!$nbr_lignes) {
        $requete = "SELECT COUNT(distinct id_empr) FROM empr join bannette_abon on id_empr=num_empr {$form_restrict_priv}, empr_categ {$clause} {$where_restrict_priv} ";
        $res = mysql_query($requete, $dbh) or die(mysql_error() . "<br /><br />{$requete}");
        $nbr_lignes = @mysql_result($res, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes == 1) {
        // on lance la vraie requête
        $requete = "SELECT distinct id_empr as id FROM empr join bannette_abon on id_empr=num_empr {$form_restrict_priv}, empr_categ {$clause} {$where_restrict_priv} ";
        $res = @mysql_query($requete, $dbh);
        $id = @mysql_result($res, '0', 'id');
        if ($id) {
            $retour['id_empr'] = $id;
            $retour['message'] = $msg[dsi_encours_de_dev] . " // lecteur trouvé à partir du nom...";
            return $retour;
        }
    } else {
        if ($nbr_lignes) {
            // on lance la vraie requête
            $requete = "SELECT distinct libelle, empr_cb, empr_nom, empr_prenom, id_empr  FROM empr join bannette_abon on id_empr=num_empr {$form_restrict_priv}, empr_categ {$clause} {$where_restrict_priv} ORDER BY empr_nom, empr_prenom LIMIT {$debut},{$nb_per_page} ";
            $res = mysql_query($requete, $dbh) or die(mysql_error() . $requete);
            $parity = 0;
            while ($empr = 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=bannettes&sub=abo&id_empr={$empr->id_empr}&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>{$empr->empr_cb}</strong>\n\t\t\t\t\t</td>\n\t\t\t\t<td>\n        \t\t\t\t{$empr->empr_nom}&nbsp;{$empr->empr_prenom}\n\t\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t{$empr->libelle}\n\t\t\t\t\t</td>\n\t\t\t\t</tr>";
                $parity += 1;
            }
            mysql_free_result($res);
            // affichage de la barre de navig
            $url_base = "{$PHP_SELF}?categ=bannettes&sub=abo&suite=search&form_cb=" . rawurlencode($form_cb) . "&ban_priv_seuls={$ban_priv_seuls}&empr_location_id={$empr_location_id}";
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
            $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!!", $msg['dsi_empr_trouves'], $dsi_list_tmpl);
            $retour['id_empr'] = 0;
            $retour['message'] = $dsi_list_tmpl;
            return $retour;
        } else {
            $retour['id_empr'] = 0;
            $retour['message'] = $msg[dsi_lect_aucun_trouve];
            return $retour;
        }
    }
}
开发者ID:bouchra012,项目名称:PMB,代码行数:79,代码来源:func_abo.inc.php

示例12: aff_pagination

             break;
         case "retard":
         case "retard_par_date":
             $bouton_imprime_tout = "<input type='hidden' name='act' value=''><input type='button' class='bouton' value=\"" . $msg['lettres_relance'] . "\" onclick=\"this.form.act.value='print'; this.form.submit();\" >";
             break;
         case "owner":
             break;
         case "encours":
         default:
             break;
     }
     if ($bouton_imprime_tout) {
         echo "\n\t\t\t\t\t<br />\n\t\t\t\t\t<form class='form-{$current_module}' action='' method='post'>\n\t\t\t\t\t{$bouton_imprime_tout}\n\t\t\t\t\t</form>";
     }
 }
 $nav_bar = aff_pagination("{$url_page}?categ={$categ}&sub={$sub}", $nombre_lignes_pret, $nb_per_page, $page, 10, false, true);
 print $nav_bar;
 //impression/emails (on est dans le cas retards/retards par date)
 if ($act == "print") {
     $not_all_mail = array();
     if ($nombre_lignes_pret) {
         $resultat = pmb_mysql_query($sql);
         while ($r = pmb_mysql_fetch_object($resultat)) {
             $mail_sended = 0;
             if (($mailretard_priorite_email == 1 || $mailretard_priorite_email == 2) && $r->empr_mail) {
                 // l'objet du mail
                 $var = "mailretard_" . $relance . "objet";
                 eval("\$objet=\"" . ${$var} . "\";");
                 // la formule de politesse du bas (le signataire)
                 $var = "mailretard_" . $relance . "fdp";
                 eval("\$fdp=\"" . ${$var} . "\";");
开发者ID:hogsim,项目名称:PMB,代码行数:31,代码来源:expl.inc.php

示例13: htmlentities

                                $affichage_mots .= htmlentities($valeur_syn, ENT_QUOTES, $charset) . "</a><br />\n";
                            }
                            $compt++;
                        }
                    } else {
                        if (pmb_substr($valeur_syn, 0, 1) == '0' || !array_search(convert_diacrit(pmb_strtolower(pmb_substr($valeur_syn, 0, 1))), $alphabet)) {
                            if ($compt >= ($page - 1) * $nb_per_page && $compt < $page * $nb_per_page) {
                                $affichage_mots .= "<a href='#' onClick=\"set_parent('" . $key . "','" . htmlentities(addslashes($valeur_syn), ENT_QUOTES, $charset) . "')\">";
                                $affichage_mots .= htmlentities($valeur_syn, ENT_QUOTES, $charset) . "</a><br />\n";
                            }
                        }
                        $compt++;
                    }
                }
            }
            $affichage_mots .= "</div>";
            $affichage_mots .= "<div class='row'>&nbsp;</div><hr />\n";
            //affichage de la pagination
            $affichage_mots .= aff_pagination($baseurl . "&user_input={$user_input}&letter=" . $letter, $compt, $nb_per_page, $page);
            $affichage_mots .= "<div class='row'>&nbsp;</div>\n";
        }
        //ajout du script
        $sel_word = str_replace("!!jscript!!", $jscript, $sel_word);
        //ajout des lettres
        $sel_word = str_replace("!!lettres!!", $affichage_lettres, $sel_word);
        //ajout des mots
        $sel_word = str_replace("!!liste_mots!!", $affichage_mots, $sel_word);
        //ajout de l'url
        $sel_word = str_replace("!!action!!", $baseurl, $sel_word);
        print $sel_word;
}
开发者ID:bouchra012,项目名称:PMB,代码行数:31,代码来源:sel_word.inc.php

示例14: 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 $callback;
    if (!$id) {
        // on récupére le nombre de lignes
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM titres_uniformes where tu_id!='{$no_display}' ";
        } 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;
            }
            $requete = $aq->get_query_count("titres_uniformes", "tu_name,", "index_tu", "tu_id", "tu_id!='{$no_display}'");
        }
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = @pmb_mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT * FROM titres_uniformes where tu_id!='{$no_display}' ORDER BY tu_name LIMIT {$debut},{$nb_per_page} ";
            } else {
                $members = $aq->get_query_members("titres_uniformes", "tu_name", "index_tu", "tu_id");
                $requete = "select *," . $members["select"] . " as pert from titres_uniformes where " . $members["where"] . " and tu_id!='{$no_display}' group by tu_id order by pert desc,index_tu limit {$debut},{$nb_per_page}";
            }
        } else {
            $requete = "select * from titres_uniformes where tu_id='" . $id . "'";
        }
        $res = @pmb_mysql_query($requete, $dbh);
        while ($titre_uniforme = pmb_mysql_fetch_object($res)) {
            $tu = new titre_uniforme($titre_uniforme->tu_id);
            $titre_uniforme_entry = $tu->display;
            print "<div class='row'>";
            print pmb_bidi("<a href='#' onclick=\"set_parent('{$caller}', '{$titre_uniforme->tu_id}', '" . htmlentities(addslashes($titre_uniforme_entry), ENT_QUOTES, $charset) . "','{$callback}')\">{$titre_uniforme_entry}</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 du lien précédent si nécéssaire
        print "<div class='row'>&nbsp;<hr /></div><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>";
    } else {
        print $msg["aut_titre_uniforme_not_found"];
    }
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:66,代码来源:titre_uniforme.inc.php

示例15: mysql_query

        break;
}
$nb_per_page = 100;
if (!$page) {
    $page = 1;
}
$debut = ($page - 1) * $nb_per_page;
$rqt .= " limit {$debut},{$nb_per_page}";
$res = mysql_query($rqt, $dbh);
$st = "odd";
while ($data = mysql_fetch_array($res)) {
    if ($st == "odd") {
        $st = "even";
    } else {
        $st = "odd";
    }
    $lien = str_replace("!!id!!", $data[0], $link);
    if ($data[2]) {
        $lien = str_replace("!!id_notice!!", $data[2], $lien);
    }
    $liste .= "<tr class='" . $st . "' onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $st . "'\"  style='cursor: pointer'>\n\t\t\t\t\t<td onClick=\"parent.location.href='" . $lien . "';\">" . $data[1] . "</td>\n\t\t\t\t</tr>";
}
$global = "\n<div class='row'>\n\t<div class='right'><a href='#' onClick='parent.kill_frame_items();return false;'><img src='" . $base_path . "/images/close.gif' border='0' align='right'></a></div>\n\t<h3>" . $titre . " (" . $total . ")</h3>\n\t<table>\t\n\t\t!!liste!!\n\t</table>\n</div>";
print str_replace("!!liste!!", $liste, $global);
print "<div class='row'><div align='center'>";
$url_base = $base_path . "/admin/docs/frame_liste_items.php?what=" . $what . "&item=" . $item . "&total=" . $total;
$nav_bar = aff_pagination($url_base, $total, $nb_per_page, $page, 10, false, true);
print $nav_bar;
print "</div>";
print "</body></html>";
mysql_close($dbh);
开发者ID:bouchra012,项目名称:PMB,代码行数:31,代码来源:frame_liste_items.php


注:本文中的aff_pagination函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。