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

PHP Pagenate类代码示例

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


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

示例1: str_replace

    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'email.email';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . EMAIL_TABLE . ' email ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('emails.php', $qs);
$qstr = '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY email.email_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' ' . __('emails');
} else {
    $showing = __('No emails found!');
}
$def_dept_id = $cfg->getDefaultDeptId();
$def_dept_name = $cfg->getDefaultDept()->getName();
$def_priority = $cfg->getDefaultPriority()->getDesc();
?>
<div class="pull-left" style="width:700px;padding-top:5px;">
开发者ID:dmiguel92，项目名称:osTicket-1.8，代码行数:31，代码来源:emails.inc.php

示例2: count

}
$order=$order?$order:'DESC';

if($order_column && strpos($order_column,',')){
    $order_column=str_replace(','," $order,",$order_column);
}
$x=$sort.'_sort';
$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$qselect = 'SELECT log.* ';
$qfrom=' FROM '.SYSLOG_TABLE.' log ';
$total=db_count("SELECT count(*) $qfrom $qwhere");
$page = ($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
//pagenate
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('logs.php',$qs);
$qs += array('order' => ($order=='DESC' ? 'ASC' : 'DESC'));
$qstr = '&amp;'. Http::build_query($qs);
$query="$qselect $qfrom $qwhere ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing().' '.$title;
else
    $showing=__('No logs found!');
?>

<h2><?php echo __('System Logs');?>
    &nbsp;<i class="help-tip icon-question-sign" href="#system_logs"></i>
</h2>
<div id='filter' >
开发者ID:KingsleyGU，项目名称:osticket，代码行数:31，代码来源:syslogs.inc.php

示例3: str_replace

    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'canned.title';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . CANNED_TABLE . ' canned ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('canned.php', $qs);
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY canned.canned_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' ' . _N('premade response', 'premade responses', $total);
} else {
    $showing = __('No premade responses found!');
}
?>
<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php
开发者ID:gizur，项目名称:osticket，代码行数:31，代码来源:cannedresponses.inc.php

示例4: array

$orderWays = array('DESC' => 'DESC', 'ASC' => 'ASC');
//Sorting options...
if ($_REQUEST['sort']) {
    $order_column = $sortOptions[$_REQUEST['sort']];
}
if ($_REQUEST['order']) {
    $order = $orderWays[$_REQUEST['order']];
}
$order_column = $order_column ? $order_column : 'ipaddr';
$order = $order ? $order : 'ASC';
$order_by = " ORDER BY {$order_column} {$order} ";
$total = db_count('SELECT count(*) ' . $from . ' ' . $where);
$pagelimit = 1000;
//No limit.
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, $pagelimit, $trl);
$pageNav->setURL('admin.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
$query = "{$select} {$from} {$where} {$order_by}";
//echo $query;
$result = db_query($query);
$showing = db_num_rows($result) ? $pageNav->showing() : '';
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting..
$deletable = 0;
?>
<div class="msg">API Keys</div>
<hr>
<div><b><?php 
echo $showing;
?>
</b></div>
开发者ID:KingsleyGU，项目名称:OSTicket-Reloaded，代码行数:31，代码来源:api.inc.php

示例5: urlencode

}
if ($_REQUEST['order']) {
    $order = $orderWays[$_REQUEST['order']];
}
if ($_GET['limit']) {
    $qstr .= '&limit=' . urlencode($_GET['limit']);
}
$order_by = $order_by ? $order_by : 'ticket.created';
$order = $order ? $order : 'DESC';
$pagelimit = $_GET['limit'] ? $_GET['limit'] : PAGE_LIMIT;
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$qselect = 'SELECT ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name ' . ',dept_name,status,source,priority_id,ticket.created,ticket.updated,staff.firstname,staff.lastname';
$qfrom = ' FROM (' . TICKET_TABLE . ' ticket' . ' LEFT JOIN ' . DEPT_TABLE . ' dept ON ticket.dept_id=dept.dept_id )' . ' LEFT JOIN ' . STAFF_TABLE . ' staff ON ticket.staff_id=staff.staff_id';
//Pagenation stuff....wish MYSQL could auto pagenate (something better than limit)
$total = db_count('SELECT count(*) ' . $qfrom . ' ' . $qwhere);
$pageNav = new Pagenate($total, $page, $pagelimit);
$pageNav->setURL('view.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qselect .= ' ,count(attach_id) as attachments ';
$qfrom .= ' LEFT JOIN ' . TICKET_ATTACHMENT_TABLE . ' attach ON  ticket.ticket_id=attach.ticket_id ';
$qgroup = ' GROUP BY ticket.ticket_id';
$query = "{$qselect} {$qfrom} {$qwhere} {$qgroup} ORDER BY {$order_by} {$order} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$tickets_res = db_query($query);
$showing = db_num_rows($tickets_res) ? $pageNav->showing() : "";
$results_type = $status ? $ger_status . 'Tickets' : 'Tickets';
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting..
?>

<div class="page-header">
开发者ID:e-gob，项目名称:chilesinpapeleo-soporte，代码行数:31，代码来源:tickets.inc.php

示例6: str_replace

    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ?: 'user.name';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ?: 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(DISTINCT user.id) ' . $from . ' ' . $where);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('users.php', $qs);
$qstr .= '&amp;order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$select .= ', count(DISTINCT ticket.ticket_id) as tickets ';
$from .= ' LEFT JOIN ' . TICKET_TABLE . ' ticket ON (ticket.user_id = user.id) ';
$query = "{$select} {$from} {$where} GROUP BY user.id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$qhash = md5($query);
$_SESSION['users_qs_' . $qhash] = $query;
?>
<h2><?php 
echo __('User Directory');
?>
</h2>
开发者ID:dmiguel92，项目名称:osTicket-1.8，代码行数:31，代码来源:users.inc.php

示例7: ON

    $qfrom.=' LEFT JOIN '.TICKET_COLLABORATOR_TABLE.' collab
        ON (ticket.ticket_id = collab.ticket_id )';


$sjoin='';

if($search && $deep_search) {
    $sjoin.=' LEFT JOIN '.TICKET_THREAD_TABLE.' thread ON (ticket.ticket_id=thread.ticket_id )';
}

//get ticket count based on the query so far..
$total=db_count("SELECT count(DISTINCT ticket.ticket_id) $qfrom $sjoin $qwhere");
//pagenate
$pagelimit=($_GET['limit'] && is_numeric($_GET['limit']))?$_GET['limit']:PAGE_LIMIT;
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total,$page,$pagelimit);

$qstr = '&amp;'.http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('tickets.php', $qs);

//ADD attachment,priorities, lock and other crap
$qselect.=' ,IF(ticket.duedate IS NULL,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)), ticket.duedate) as duedate '
         .' ,CAST(GREATEST(IFNULL(ticket.lastmessage, 0), IFNULL(ticket.closed, 0), IFNULL(ticket.reopened, 0), ticket.created) as datetime) as effective_date '
         .' ,ticket.created as ticket_created, CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team '
         .' ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned '
         .' ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic '
         .' ,cdata.priority as priority_id, cdata.subject, pri.priority_desc, pri.priority_color';

$qfrom.=' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON (ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW()
               AND tlock.staff_id!='.db_input($thisstaff->getId()).') '
开发者ID:KingsleyGU，项目名称:osticketLocal，代码行数:31，代码来源:tickets.inc.php

示例8: str_replace

    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'tpl.name';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . EMAIL_TEMPLATE_GRP_TABLE . ' tpl ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('templates.php', $qs);
$qstr .= '&amp;order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY tpl.tpl_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' ' . _N('template', 'templates', $num);
} else {
    $showing = __('No templates found!');
}
?>

<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php
开发者ID:gizur，项目名称:osticket，代码行数:31，代码来源:templates.inc.php

示例9: str_replace

    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'rule.val';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(DISTINCT rule.id) ' . $from . ' ' . $where);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('banlist.php', $qs);
$qstr .= '&amp;order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$select} {$from} {$where} ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
?>
<h2><?php 
echo __('Banned Email Addresses');
?>
    <i class="help-tip icon-question-sign" href="#ban_list"></i>
    </h2>
<div class="pull-left" style="width:600;padding-top:5px;">
    <form action="banlist.php" method="GET" name="filter">
     <input type="hidden" name="a" value="filter" >
开发者ID:gizur，项目名称:osticket，代码行数:31，代码来源:banlist.inc.php

示例10: ON

    $qfrom.=' LEFT JOIN '.TICKET_COLLABORATOR_TABLE.' collab
        ON (ticket.ticket_id = collab.ticket_id )';


$sjoin='';

if($search && $deep_search) {
    $sjoin.=' LEFT JOIN '.TICKET_THREAD_TABLE.' thread ON (ticket.ticket_id=thread.ticket_id )';
}

//get ticket count based on the query so far..
$total=db_count("SELECT count(DISTINCT ticket.ticket_id) $qfrom $sjoin $qwhere");
//pagenate
$pagelimit=($_GET['limit'] && is_numeric($_GET['limit']))?$_GET['limit']:PAGE_LIMIT;
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total,$page,$pagelimit);
$pageNav->setURL('tickets.php',$qstr.'&sort='.urlencode($_REQUEST['sort']).'&order='.urlencode($_REQUEST['order']));

//ADD attachment,priorities, lock and other crap
$qselect.=' ,IF(ticket.duedate IS NULL,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)), ticket.duedate) as duedate '
         .' ,CAST(GREATEST(IFNULL(ticket.lastmessage, 0), IFNULL(ticket.closed, 0), IFNULL(ticket.reopened, 0), ticket.created) as datetime) as effective_date '
         .' ,ticket.created as ticket_created, CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team '
         .' ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned '
         .' ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic '
         .' ,cdata.priority as priority_id, cdata.subject, pri.priority_desc, pri.priority_color';

$qfrom.=' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON (ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW()
               AND tlock.staff_id!='.db_input($thisstaff->getId()).') '
       .' LEFT JOIN '.STAFF_TABLE.' staff ON (ticket.staff_id=staff.staff_id) '
       .' LEFT JOIN '.TEAM_TABLE.' team ON (ticket.team_id=team.team_id) '
       .' LEFT JOIN '.SLA_TABLE.' sla ON (ticket.sla_id=sla.id AND sla.isactive=1) '
开发者ID:CarlosAvilesMx，项目名称:CarlosAviles.Mx，代码行数:31，代码来源:tickets.inc.php

示例11: __

 <h2><?php 
echo __('Custom Forms');
?>
</h2>
</div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
<b><a href="forms.php?a=add" class="Icon form-add"><?php 
echo __('Add New Custom Form');
?>
</a></b></div>
<div class="clear"></div>

<?php 
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$count = DynamicForm::objects()->filter(array('type__in' => array('G')))->count();
$pageNav = new Pagenate($count, $page, PAGE_LIMIT);
$pageNav->setURL('forms.php');
$showing = $pageNav->showing() . ' ' . _N('form', 'forms', $count);
?>

<form action="forms.php" method="POST" name="forms">
<?php 
csrf_token();
?>
<input type="hidden" name="do" value="mass_process" >
<input type="hidden" id="action" name="a" value="" >
<table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <thead>
        <tr>
            <th width="7">&nbsp;</th>
            <th><?php
开发者ID:dmiguel92，项目名称:osTicket-1.8，代码行数:31，代码来源:dynamic-forms.inc.php

示例12: is_numeric

<div style="width:700;padding-top:5px; float:left;">
 <h2>Currently Installed Plugins</h2>
</div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
 <b><a href="plugins.php?a=add" class="Icon form-add">Add New Plugin</a></b></div>
<div class="clear"></div>

<?php 
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$count = count($ost->plugins->allInstalled());
$pageNav = new Pagenate($count, $page, PAGE_LIMIT);
$pageNav->setURL('forms.php');
$showing = $pageNav->showing() . ' forms';
?>

<form action="plugins.php" method="POST" name="forms">
<?php 
csrf_token();
?>
<input type="hidden" name="do" value="mass_process" >
<input type="hidden" id="action" name="a" value="" >
<table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <thead>
        <tr>
            <th width="7">&nbsp;</th>
            <th>Plugin Name</th>
            <th>Status</td>
            <th>Date Installed</th>
        </tr>
    </thead>
    <tbody>
开发者ID:ed00m，项目名称:osTicket-1.8，代码行数:31，代码来源:plugins.inc.php

示例13: str_replace

    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'page.name';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . PAGE_TABLE . ' page ' . $where);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('pages.php', $qs);
$qstr .= '&amp;order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} {$where} GROUP BY page.id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . _N('site page', 'site pages', $num);
} else {
    $showing = __('No pages found!');
}
?>

<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php
开发者ID:gizur，项目名称:osticket，代码行数:31，代码来源:pages.inc.php

示例14: urlencode

        $qwhere .= ' AND created>=FROM_UNIXTIME(' . $startTime . ')';
        $qstr .= '&startDate=' . urlencode($_REQUEST['startDate']);
    }
    if ($endTime) {
        $qwhere .= ' AND created<=FROM_UNIXTIME(' . $endTime . ')';
        $qstr .= '&endDate=' . urlencode($_REQUEST['endDate']);
    }
}
$qselect = 'SELECT log.* ';
$qfrom = ' FROM ' . SYSLOG_TABLE . ' log ';
//get log count based on the query so far..
$total = db_count("SELECT count(*) {$qfrom} {$qwhere}");
$pagelimit = 30;
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
//pagenate
$pageNav = new Pagenate($total, $page, $pagelimit, $trl);
$pageNav->setURL('admin.php', $qstr);
$query = "{$qselect} {$qfrom} {$qwhere} ORDER BY log.created DESC LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$result = db_query($query);
$showing = db_num_rows($resp) ? $pageNav->showing() : "";
?>
<div class="msg">System Logs</div>
<div id='filter' >
 <form action="admin.php?t=syslog" method="get">
    <input type="hidden" name="t" value="syslog" />
    <div style="padding-left:15px;">
        Date Span:
        &nbsp;From&nbsp;<input id="sd" size=15 name="startDate" value="<?php 
echo Format::htmlchars($_REQUEST['startDate']);
?>
开发者ID:KingsleyGU，项目名称:OSTicket-Reloaded，代码行数:31，代码来源:syslogs.inc.php

示例15: str_replace

    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'topic.topic';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . TOPIC_TABLE . ' topic ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('helptopics.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY topic.topic_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' help topics';
} else {
    $showing = 'No help topic found!';
}
?>
<div style="width:700px;padding-top:5px; float:left;">
 <h2>Help Topics</h2>
 </div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
开发者ID:pkdevboxy，项目名称:osTicket-1.7，代码行数:31，代码来源:helptopics.inc.php


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