PHP Pager::link方法代码示例

 function browse($path, $visible, $offset = 0, $limit = 10)
 {
     global $intl, $loader;
     $loader->import('saf.Database.Pager');
     $output = '';
     $res = $this->doc->query($path);
     if (!is_array($res)) {
         $this->error = $this->doc->error;
         return 0;
     }
     $pager = new Pager();
     printf('<p>%s</p>', $pager->link($this->browseLink, $limit, $offset, count($res)));
     // create table header
     $output .= "<table border='1' cellpadding='5'>\n";
     $output .= "\t<tr>\n";
     $output .= "\t\t<th><input type='submit' name='action' value='" . $intl->get('Delete') . "' /></th>\n";
     $output .= "\t\t<th><input type='submit' value='" . $intl->get('Select All') . "' /></th>\n";
     foreach ($visible as $node) {
         $output .= "\t\t<th>" . ucwords(str_replace('_', ' ', $node)) . "</th>\n";
     }
     $output .= "\t</tr>\n";
     for ($i = $offset; $i < $offset + $limit; $i++) {
         if (!is_object($res[$i])) {
             break;
         }
         $row = $res[$i]->makeObj();
         $path = urlencode($res[$i]->path());
         $output .= "\t<tr>\n";
         $output .= "\t\t<td align='center'>";
         $output .= "<input type='checkbox' name='del_items[]' value='" . $path . "' />";
         //			$output .= $intl->get ('Delete');
         $output .= "</td>\n";
         $output .= "\t\t<td>";
         $output .= "<a href='" . $this->editLink . $path . "'>";
         $output .= $intl->get('Edit');
         $output .= '</a>';
         $output .= ' | ';
         $output .= "<a href='" . $this->downloadLink . $path . "'>";
         $output .= $intl->get('Download');
         $output .= '</a>';
         $output .= "</td>\n";
         foreach ($visible as $node) {
             $output .= "\t\t<td>" . $row->{$node} . "</td>\n";
         }
         $output .= "\t</tr>\n";
     }
     // create table footer
     $output .= "</table>\n";
     return $output;
 }

        $sql_query .= " and (recycle='0' or recycle='-1')";
        $total_count = $db->counter($table, $sql_query, "*");
        require_once 'include/pager.class.php';
        $page = (int) $page;
        if ($page_input) {
            $page = $page_input;
        }
        $list_num = 5;
        $rowset = new Pager($total_count, $list_num, $page);
        $from_record = $rowset->_offset();
        $img_list = $db->get_all("select * from {$table} {$sql_query} and (recycle='0' or recycle='-1') order by top_ok desc,no_order desc,updatetime desc,id desc LIMIT {$from_record}, {$list_num}");
        $page = $page == 0 ? 1 : $page;
        if ($page * $list_num > $total_count) {
            $list_num = $total_count - ($page - 1) * $list_num;
        }
        $page_list = $rowset->link("fileup.php?anyid={$anyid}&class1={$class1}&class2={$class2}&class3={$class3}&action=do&lang={$lang}&page=");
        $numtotal = $total_count;
        $numcsv = $total_count;
        if (!$img_list) {
            $listnots = $lang_listno;
        }
    }
    $listid = '';
    foreach ($img_list as $key => $val) {
        $listid .= $val['id'] . ',';
    }
    $from_record_1 = $from_record + 1;
    $from_record_2 = $from_record + $list_num;
}
require_once 'index.php';
$listclass = '';

        $list['access'] = $menber_array[$list['access']];
    }
    $list[new_ok1] = $list[new_ok] ? $lang_yes : $lang_no;
    $list[com_ok1] = $list[com_ok] ? $lang_yes : $lang_no;
    $list[displaytype1] = $list[displaytype] ? $lang_yes : $lang_no;
    $list[top_ok1] = $list[top_ok] ? $lang_yes : $lang_no;
    $list[wap_ok1] = $list[wap_ok] ? $lang_yes : $lang_no;
    $list[updatetime] = date('Y-m-d', strtotime($list[updatetime]));
    $num = 38;
    if (preg_match("/[-ÿ]/", $list['title'])) {
        $num = 20;
    }
    $list['titles'] = utf8substr($list['title'], 0, $num);
    $img_list[] = $list;
}
$page_list = $rowset->link("index.php?anyid={$anyid}&lang={$lang}&class1={$class1}&class2={$class2}&class3={$class3}&search={$search}&title={$title}&page=");
switch ($new) {
    case '1':
        $new1 = "selected='selected'";
        break;
    case '0':
        $new2 = "selected='selected'";
        break;
    default:
        $new0 = "selected='selected'";
        break;
}
switch ($recommend) {
    case '1':
        $recommend1 = "selected='selected'";
        break;

 $query = "SELECT * FROM {$met_message} {$serch_sql} {$order_sql} LIMIT {$from_record}, {$list_num}";
 $result = $db->query($query);
 while ($list = $db->fetch_array($result)) {
     if ($met_member_use) {
         if (intval($list[access]) > 0) {
             $list[info] = "<script language='javascript' src='access.php?metaccess=" . $list[access] . "&lang=" . $lang . "&listinfo=info&id=" . $list[id] . "'></script>";
             $list[useinfo] = "<script language='javascript' src='access.php?metaccess=" . $list[access] . "&lang=" . $lang . "&listinfo=useinfo&id=" . $list[id] . "'></script>";
         }
     }
     $message_list[] = $list;
 }
 if ($met_webhtm == 2) {
     $met_pagelist = $met_htmlistname ? "message_list_" : "index_list_";
     $met_pagelist = $message_column['filename'] != '' ? $message_column['filename'] . '_' : $met_pagelist;
     $met_ahtmtype = $message_column['filename'] != '' ? $met_chtmtype : $met_htmtype;
     $page_list = $rowset->link($met_pagelist, $met_ahtmtype);
 } else {
     if ($met_pseudo) {
         $page_list = $rowset->link('list-' . $class1 . '-', '-' . $lang . '.html');
     } else {
         $page_list = $rowset->link("index.php?lang=" . $lang . "&page=");
     }
 }
 $class2 = $class_list[$class1][releclass] ? $class1 : $class2;
 $class1 = $class_list[$class1][releclass] ? $class_list[$class1][releclass] : $class1;
 $class_info = $class2 ? $class2_info : $class1_info;
 if ($class2 != "") {
     $class_info[name] = $class2_info[name] . "-" . $class1_info[name];
 }
 $show[description] = $class_info[description] ? $class_info[description] : $met_description;
 $show[keywords] = $class_info[keywords] ? $class_info[keywords] : $met_keywords;

 /**
  * Close sql tag handler.
  * 
  * @access	private
  * @param	associative array	$node
  * @return	string
  * 
  */
 function _sql_end($node)
 {
     global $db;
     $sql = array_shift($this->sql);
     $out = '';
     if ($sql['pager']) {
         if (empty($sql['totalquery'])) {
             $sql['totalquery'] = preg_replace('/^select .+ from /i', 'select count(*) as total from ', $sql['query']);
             //				$sql['totalquery'] = preg_replace ('/ limit .+$/i', '', $sql['totalquery']);
         }
         $sql['totalquery'] = $this->exp->evaluate($sql['totalquery'], $this->exp->register['object'], 'string', true);
         $tot = $db->fetch($sql['totalquery'], $sql['bind']);
         if (!$tot) {
             $total = 0;
         } elseif (is_array($tot)) {
             $total = $tot[0]->total;
         } else {
             $total = $tot->total;
         }
         $limit = $sql['limit'];
         if (!is_numeric($limit)) {
             $limit = 20;
         }
         $offset = $this->exp->evaluate('cgi/' . $sql['offsetvar'] . ' | php: 0', $node, 'path', true);
         if (!is_numeric($offset)) {
             $offset = 0;
         }
         $sql['query'] .= ' limit ' . $offset . ', ' . $limit;
         global $loader, $cgi, $_SERVER;
         $loader->import('saf.Database.Pager');
         $cgi->{$sql['offsetvar']} = $offset;
         $pager = new Pager();
         $out .= '<p>' . $pager->link($_SERVER['SCRIPT_NAME'] . $cgi->makeQuery($sql['offsetvar']) . '&', $limit, $offset, $total) . '</p>';
     }
     $sql['query'] = $this->exp->evaluate($sql['query'], $this->exp->register['object'], 'string', true);
     $res = $db->fetch($sql['query'], $sql['bind']);
     if (!$res) {
         //$this->error = $db->error;
         $this->exp->setObject($db, 'result');
         return $this->fill($this->wrap($sql['else']), $this->exp->register['object'], true);
         $this->exp->setObject(false, 'result');
     } elseif (is_object($res)) {
         $res = array($res);
     }
     foreach ($res as $row) {
         $this->exp->setObject($row, 'result');
         $out .= $this->fill($this->wrap($sql['sub']), $this->exp->register['object'], true);
     }
     $this->exp->setObject(false, 'result');
     $this->rows = $db->rows;
     return $out;
 }

        $cname = ',';
        for ($i = 0; $i < count($lmod); $i++) {
            if ($lmod[$i] != '') {
                if ($lmod[$i] == 10001) {
                    $cname .= $lang_htmHome . ',';
                } else {
                    $columnids = $db->get_one("select * from {$met_column} where id='{$lmod[$i]}' and lang='{$lang}'");
                    $cname .= $columnids[name] . ',';
                }
            }
        }
        $list['modulename'] = $cname;
    }
    $flashrec[] = $list;
}
$page_list = $rowset->link("flash.php?lang={$lang}&cs={$cs}&page=");
$query1 = "select * from {$met_column} where if_in='0' and lang='{$lang}' order by no_order";
$result1 = $db->query($query1);
$mod1[0] = $mod[10001] = array(id => 10001, name => "{$lang_flashHome}", bigclass => 0);
$i = 1;
while ($list = $db->fetch_array($result1)) {
    if ($list[classtype] == 1) {
        $mod1[$i] = $list;
        $i++;
    }
    if ($list[classtype] == 2) {
        $mod2[$list[bigclass]][] = $list;
    }
    if ($list[classtype] == 3) {
        $mod3[$list[bigclass]][] = $list;
    }

                if ($key == $class1 || $key == $class2 || $key == $class3) {
                    $md_class1[$key] = $val;
                }
            }
        } else {
            if ($classnow == $class1) {
                $md_class1 = $md_class;
            }
        }
    }
    $md_class = $md_class1;
    $md_list[] = $list;
}
if ($search == 'search' && $mdmendy) {
    $pagemor = $mdname . ".php?lang={$lang}&class1={$class1}&class2={$class2}&class3={$class3}" . $serchpage . '&search=search&page=';
    $page_list = $rowset->link($pagemor);
} else {
    if ($met_pseudo) {
        $pagemor = ($metadmin['pagename'] and $class_list[$classnow]['filename'] != "") ? 'list-' . $class_list[$classnow]['filename'] . '-' : 'list-' . $classnow . '-';
        $hz = '-' . $lang . '.html';
        $page_list = $rowset->link($pagemor, $hz);
    } else {
        if ($met_webhtm == 2) {
            if ($class3 != 0) {
                $htmclass = $met_listhtmltype ? '_' . $class3 . '_' : '_' . $class1 . '_' . $class2 . '_' . $class3 . '_';
                $met_pagelist = (($metadmin['pagename'] and $class_list[$class3]['filename'] != "") ? $class_list[$class3]['filename'] : ($met_htmlistname ? $class_list[$class3]['foldername'] : $modulename[$class_list[$class3]['module']][0])) . $htmclass;
                $met_pagelist = $class_list[$class3]['filename'] != '' ? $class_list[$class3]['filename'] . '_' : $met_pagelist;
                $met_ahtmtype = $class_list[$class3]['filename'] != '' ? $met_chtmtype : $met_htmtype;
            } elseif ($class2 != 0) {
                $htmclass = $met_listhtmltype ? '_' . $class2 . '_' : '_' . $class1 . '_' . $class2 . '_';
                $met_pagelist = (($metadmin['pagename'] and $class_list[$class2]['filename'] != "") ? $class_list[$class2]['filename'] : ($met_htmlistname ? $class_list[$class2]['foldername'] : $modulename[$class_list[$class2]['module']][0])) . $htmclass;

if ($search == "detail_search") {
    if ($useinfo) {
        $serch_sql .= " and useinfo like '%{$useinfo}%' ";
    }
    $total_count = $db->counter($met_feedback, "{$serch_sql}", "*");
} else {
    $total_count = $db->counter($met_feedback, "{$serch_sql}", "*");
}
require_once 'include/pager.class.php';
$page = (int) $page;
if ($page_input) {
    $page = $page_input;
}
$list_num = 20;
$rowset = new Pager($total_count, $list_num, $page);
$from_record = $rowset->_offset();
$query = "SELECT * FROM {$met_feedback} {$serch_sql} {$order_sql} LIMIT {$from_record}, {$list_num}";
$result = $db->query($query);
while ($list = $db->fetch_array($result)) {
    $list['customerid'] = $list['customerid'] == '0' ? $lang_feedbackAccess0 : $list['customerid'];
    $list[readok] = $list[readok] ? $lang_yes : $lang_no;
    $feedback_list[] = $list;
}
$page_list = $rowset->link("index.php?anyid={$anyid}&lang={$lang}&class1={$class1}&search={$search}&readok={$readok}&useinfo={$useinfo}&met_fd_classname={$met_fd_classname}&customerid={$customerid}&page=");
$cs = 3;
$listclass = '';
$listclass[$cs] = 'class="now"';
$css_url = $depth . "../templates/css";
$img_url = $depth . "../templates/images";
include template('content/feedback/feedback');
footer();

    if ($search == "detail_search") {
        if ($webname) {
            $serch_sql .= " and webname like '%{$webname}%' ";
        }
        $total_count = $db->counter($met_link, "{$serch_sql}", "*");
    } else {
        $total_count = $db->counter($met_link, "{$serch_sql}", "*");
    }
    require_once 'include/pager.class.php';
    $page = (int) $page;
    if ($page_input) {
        $page = $page_input;
    }
    $list_num = 20;
    $rowset = new Pager($total_count, $list_num, $page);
    $from_record = $rowset->_offset();
    $query = "SELECT * FROM {$met_link} {$serch_sql} {$order_sql} LIMIT {$from_record}, {$list_num}";
    $result = $db->query($query);
    while ($list = $db->fetch_array($result)) {
        $list[show_ok] = $list[show_ok] ? $lang_yes : $lang_no;
        $list[com_ok] = $list[com_ok] ? $lang_yes : $lang_no;
        $list[link_type] = $list[link_type] ? $lang_linkType5 : $lang_linkType4;
        $link_list[] = $list;
    }
    $met_weburl = substr($met_weburl, 0, -1);
    $page_list = $rowset->link("index.php?lang={$lang}&anyid={$anyid}&link_type={$link_type}&com_ok={$com_ok}&show_ok={$show_ok}&link_lang={$link_lang}&search={$search}&webname={$webname}&page=");
    $css_url = $depth . "../templates/css";
    $img_url = $depth . "../templates/images";
    include template('seo/link/link');
    footer();
}

while ($list = $db->fetch_array($result)) {
    $selectlist[] = $list;
}
$serch_sql = " where customerid='{$metinfo_member_name}' and lang='{$lang}' ";
if ($met_fd_classname != "") {
    $serch_sql .= " and exists(select info from {$met_flist} where listid='{$met_feedback}.id' and paraid='{$met_fd_class}' and info='{$met_fd_classname}')";
}
$order_sql = " order by id desc ";
$total_count = $db->counter($met_feedback, "{$serch_sql}", "*");
require_once '../include/pager.class.php';
$page = (int) $page;
if ($page_input) {
    $page = $page_input;
}
$list_num = 20;
$rowset = new Pager($total_count, $list_num, $page);
$from_record = $rowset->_offset();
$page = $page ? $page : 1;
$query = "SELECT * FROM {$met_feedback} {$serch_sql} {$order_sql}  LIMIT {$from_record}, {$list_num}";
$result = $db->query($query);
while ($list = $db->fetch_array($result)) {
    $list[readok] = $list[readok] ? $lang_Yes : $lang_No;
    $feedback_list[] = $list;
}
$page_list = $rowset->link("feedback.php?search={$search}&lang={$lang}&page=");
$mfname = 'feedback';
$pageall = $rowset->pages;
include template('member');
footermember();
# This program is an open source system, commercial use, please consciously to purchase commercial license.
# Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved.

        }
        $visit = $langlist;
        break;
}
/*分页*/
$total_count = count($visit);
$list_num = 15;
require_once $depth . '../include/pager.class.php';
$page = (int) $page;
if ($page_input) {
    $page = $page_input;
}
$rowset = new Pager($total_count, $list_num, $page);
$from_record = $rowset->_offset();
$i = 0;
foreach ($visit as $key => $val) {
    $i++;
    $maxl = $from_record + $list_num;
    if ($i > $from_record and $i <= $maxl) {
        $val['order'] = $i;
        $newvisit[$key] = $val;
    }
}
if ($total_count > $list_num) {
    $page_list = $rowset->link("accept.php?lang={$lang}&anyid={$anyid}&st={$st}&et={$et}&cs={$cs}&field={$field}&visitlan={$visitlan}&labtype={$labtype}&page=");
}
$visit = $newvisit;
include template('app/stat/accept');
footer();
# This program is an open source system, commercial use, please consciously to purchase commercial license.
# Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved.

<?php

# MetInfo Enterprise Content Management System
# Copyright (C) MetInfo Co.,Ltd (http://www.metinfo.cn). All rights reserved.
require_once 'login_check.php';
require_once ROOTPATH . 'member/index_member.php';
$serch_sql = " where customerid='{$metinfo_member_name}' and lang='{$lang}' ";
$order_sql = " order by id desc ";
$total_count = $db->counter($met_message, "{$serch_sql}", "*");
require_once '../include/pager.class.php';
$page = (int) $page;
if ($page_input) {
    $page = $page_input;
}
$list_num = 20;
$rowset = new Pager($total_count, $list_num, $page);
$from_record = $rowset->_offset();
$page = $page ? $page : 1;
$query = "SELECT * FROM {$met_message} {$serch_sql} {$order_sql} LIMIT {$from_record}, {$list_num}";
$result = $db->query($query);
while ($list = $db->fetch_array($result)) {
    $list[readok] = $list[readok] == 1 ? $lang_YES : $lang_NO;
    $message_list[] = $list;
}
$page_list = $rowset->link("message.php?search={$search}&lang={$lang}&page=");
$pageall = $rowset->pages;
$mfname = 'message';
include template('member');
footermember();
# This program is an open source system, commercial use, please consciously to purchase commercial license.
# Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved.

$page = (int) $page;
if ($page_input) {
    $page = $page_input;
}
$list_num = 1;
$rowset = new Pager($total_count, $list_num, $page);
$from_record = $rowset->_offset();
$page = $page ? $page : 1;
$query = "SELECT * FROM {$met_job} where lang='{$lang}'";
$result = $db->query($query);
while ($list = $db->fetch_array($result)) {
    $job_list[$list[id]] = $list[position];
}
$query = "SELECT id,jobid,addtime,customerid,readok FROM {$met_cv} {$serch_sql} order by addtime desc LIMIT {$from_record}, {$list_num}";
$result = $db->query($query);
while ($list = $db->fetch_array($result)) {
    $list['customerid'] = $list['customerid'] == '0' ? $lang_cvID : $list['customerid'];
    if (isset($job_list[$list[jobid]])) {
        $list[position] = $job_list[$list[jobid]];
    } else {
        $list[position] = "<font color=red>{$lang_cvTip4}</font>";
    }
    $cv_list[] = $list;
}
$page_list = $rowset->link("cv.php?search={$search}&page=");
$pageall = $rowset->pages;
$mfname = 'cv';
include template('member');
footermember();
# This program is an open source system, commercial use, please consciously to purchase commercial license.
# Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved.

    $total_count = $db->counter($met_admin_table, "{$serch_sql}", "*");
} else {
    $total_count = $db->counter($met_admin_table, "{$serch_sql}", "*");
}
require_once 'include/pager.class.php';
$page = (int) $page;
if ($page_input) {
    $page = $page_input;
}
$list_num = 16;
$rowset = new Pager($total_count, $list_num, $page);
$from_record = $rowset->_offset();
$query = "SELECT * FROM {$met_admin_table} {$serch_sql} ORDER BY admin_modify_date DESC LIMIT {$from_record}, {$list_num}";
$result = $db->query($query);
$admin_list = array();
while ($list = $db->fetch_array($result)) {
    $list['usertype'] = $menber_array[$list['usertype']];
    $list['checked'] = $list['checkid'] == 1 ? $lang_memberChecked : $lang_memberUnChecked;
    $admin_list[] = $list;
}
$page_list = $rowset->link("index.php?admin_id={$admin_id}&admin_name={$admin_name}&search={$search}&searchall={$searchall}&lang={$lang}&anyid={$anyid}&page=");
$lev = 1;
$menbermanage = 1;
$list_access['access'] = $usertype;
require '../content/access.php';
$css_url = "../templates/" . $met_skin . "/css";
$img_url = "../templates/" . $met_skin . "/images";
include template('member/member');
footer();
# This program is an open source system, commercial use, please consciously to purchase commercial license.
# Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved.

             $modlistnow[] = $list;
         }
     }
     foreach ($modlistnow as $key => $val) {
         $val['url'] = 'index.php?lang=' . $lang . '&id=' . $val['id'] . '&module=' . $module;
         if ($module == 6) {
             $val['url'] = 'index.php?lang=' . $lang . '&id=' . $val['id'] . '&module=' . $module . '&class1=' . $class1;
         }
         if ($metwaphtm == 'metwaphtm') {
             $val['url'] = $fname[$module][1] . $lang . $val['id'] . '.html';
         }
         $wap_list[] = $val;
     }
     if ($metwaphtm == 'metwaphtm') {
         $pagemor = $fname[$module][0] . $lang . $classwap . '_';
         $page_list = $rowset->link($pagemor, '.html');
     } else {
         $pagemor = 'index.php?' . $lang . '&module=' . $module . "&class1={$class1}&class2={$class2}&class3={$class3}&page=";
         $page_list = $rowset->link($pagemor, '');
     }
     $modulename = $db->get_one("select * from {$met_column} where lang='{$lang}' and id = '{$classwap}'");
     $waptitle = $modulename['name'] . '-' . $wap_title;
 } else {
     $show = $db->get_one("select * from {$dbname} where lang='{$lang}' and id = '{$id}'");
     $show['content'] = wap_replace($show['content'], 'img', 'object|script', 'span|strong|table|tr|b|p');
     //$show['content'] =  preg_replace("/<(.*?)>/","",$show['content']);
     $classnow = $show['class3'] ? $show['class3'] : ($show['class2'] ? $show['class2'] : $show['class1']);
     if ($module == 1) {
         $classnow = $id;
     }
     if ($module == 6) {