一个好用的长文章分页类,正在学习看看怎么用!

作者:hesper 日期:2006-07-29

字体大小: 小中大

分页类文件:pageNavigation.php
<?php
/**
* @version $Id: pageNavigation.php,v 1.4 2005/01/06 01:13:29 eddieajau Exp $
* @package Mambo
* @copyright (C) 2000 - 2005 Miro International Pty Ltd
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* Mambo is Free Software
*/

/** ensure this file is being included by a parent file */
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

/**
* Page navigation support class
* @package Mambo
*/
class mosPageNav {
        /** @var int The record number to start dislpaying from */
        var $limitstart = null;
        /** @var int Number of rows to display per page */
        var $limit = null;
        /** @var int Total number of rows */
        var $total = null;

        function mosPageNav( $total, $limitstart, $limit ) {
                $this->total = intval( $total );
                $this->limitstart = max( $limitstart, 0 );
                $this->limit = max( $limit, 0 );
        }
        /**
        * Returns the html limit # input box
        * @param string The basic link to include in the href
        * @return string
        */
        function getLimitBox ( $link ) {
                $limits = array();
                for ($i=5; $i <= 30; $i+=5) {
                        $limits[] = mosHTML::makeOption( "$i" );
                }
                $limits[] = mosHTML::makeOption( "50" );

                // build the html select list
                $link = sefRelToAbs($link.'&limit=\' + this.options[selectedIndex].value + \'&limitstart='.$this->limitstart);
                return mosHTML::selectList( $limits, 'limit',
                'class="inputbox" size="1" onchange="document.location.href=\''.$link.'\';"',
                'value', 'text', $this->limit );
        }
        /**
        * Writes the html limit # input box
        * @param string The basic link to include in the href
        */
        function writeLimitBox ( $link ) {
                echo mosPageNav::getLimitBox( $link );
        }
        /**
        * Writes the html for the pages counter, eg, Results 1-10 of x
        */
        function writePagesCounter() {
                $txt = '';
                $from_result = $this->limitstart+1;
                if ($this->limitstart + $this->limit < $this->total) {
                        $to_result = $this->limitstart + $this->limit;
                } else {
                        $to_result = $this->total;
                }
                if ($this->total > 0) {
                        $txt .= _PN_RESULTS." $from_result - $to_result "._PN_OF." $this->total";
                }
                return $txt;
        }

        /**
        * Writes the html for the leafs counter, eg, Page 1 of x
        */
        function writeLeafsCounter() {
                $txt = '';
                $page = $this->limitstart+1;
                if ($this->total > 0) {
                        $txt .= _PN_PAGE." $page "._PN_OF." $this->total";
                }
                return $txt;
        }

        /**
        * Writes the html links for pages, eg, previous, next, 1 2 3 ... x
        * @param string The basic link to include in the href
        */
        function writePagesLinks( $link ) {
                $txt = '';

                $displayed_pages = 10;
                //if ($this->limit!=0){ 首页链接数如果为0，则出错。该文件的92 93行是不是改成这样好一些？即加上if语句.
                $total_pages = ceil( $this->total / $this->limit );
                $this_page = ceil( ($this->limitstart+1) / $this->limit );
                //}
                $start_loop = (floor(($this_page-1)/$displayed_pages))*$displayed_pages+1;
                if ($start_loop + $displayed_pages - 1 < $total_pages) {
                        $stop_loop = $start_loop + $displayed_pages - 1;
                } else {
                        $stop_loop = $total_pages;
                }

                $link .= '&limit='. $this->limit;

                if ($this_page > 1) {
                        $page = ($this_page - 2) * $this->limit;
                        $txt .= '<a href="'. sefRelToAbs( "$link&limitstart=0" ) .'" class="pagenav" title="first page"><< '. _PN_START .'</a> ';
                        $txt .= '<a href="'. sefRelToAbs( "$link&limitstart=$page" ) .'" class="pagenav" title="previous page">< '. _PN_PREVIOUS .'</a> ';
                } else {
                        $txt .= '<span class="pagenav"><< '. _PN_START .'</span> ';
                        $txt .= '<span class="pagenav">< '. _PN_PREVIOUS .'</span> ';
                }

                for ($i=$start_loop; $i <= $stop_loop; $i++) {
                        $page = ($i - 1) * $this->limit;
                        if ($i == $this_page) {
                                $txt .= '<span class="pagenav">'. $i .'</span> ';
                        } else {
                                $txt .= '<a href="'. sefRelToAbs( $link .'&limitstart='. $page ) .'" class="pagenav"><strong>'. $i .'</strong></a> ';
                        }
                }

                if ($this_page < $total_pages) {
                        $page = $this_page * $this->limit;
                        $end_page = ($total_pages-1) * $this->limit;
                        $txt .= '<a href="'. sefRelToAbs( $link .'&limitstart='. $page ) .' " class="pagenav" title="next page">'. _PN_NEXT .' ></a> ';
                        $txt .= '<a href="'. sefRelToAbs( $link .'&limitstart='. $end_page ) .' " class="pagenav" title="end page">'. _PN_END .' >></a>';
                } else {
                        $txt .= '<span class="pagenav">'. _PN_NEXT .' ></span> ';
                        $txt .= '<span class="pagenav">'. _PN_END .' >></span>';
                }
                return $txt;
        }
}
?>

一个用此分页类的例子:admin.users.php(我有很多地方看不懂,请高手们看完后另提供一个例子,多谢!)
<?php
/**
* @version $Id: admin.users.php,v 1.14 2005/02/16 14:21:00 stingrey Exp $
* @package Mambo
* @subpackage Users
* @copyright (C) 2000 - 2005 Miro International Pty Ltd
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* Mambo is Free Software
*/

/** ensure this file is being included by a parent file */
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

if (!$acl->acl_check( 'administration', 'manage', 'users', $my->usertype, 'components', 'com_users' )) {
        mosRedirect( 'index2.php', _NOT_AUTH );
}

require_once( $mainframe->getPath( 'admin_html' ) );

$task         = trim( mosGetParam( $_REQUEST, 'task', null ) );
$cid         = mosGetParam( $_REQUEST, 'cid', array( 0 ) );
if (!is_array( $cid )) {
        $cid = array ( 0 );
}

switch ($task) {
        case 'new':
                editUser( 0, $option);
                break;

        case 'edit':
                editUser( intval( $cid[0] ), $option );
                break;

        case 'editA':
                editUser( $id, $option );
                break;

        case 'save':
        case 'apply':
                saveUser( $option, $task );
                break;

        case 'remove':
                removeUsers( $cid, $option );
                break;

        case 'block':
                changeUserBlock( $cid, 1, $option );
                break;

        case 'unblock':
                changeUserBlock( $cid, 0, $option );
                break;

        case 'logout':
                logoutUser( $cid, $option, $task );
                break;

        case 'flogout':
                logoutUser( $id, $option, $task );
                break;

        case 'cancel':
                cancelUser( $option );
                break;

        case 'contact':
                $contact_id = mosGetParam( $_POST, 'contact_id', '' );
                mosRedirect( 'index2.php?option=com_contact&task=editA&id='. $contact_id );
                break;

        default:
                showUsers( $option );
                break;
}

function showUsers( $option ) {
        global $database, $mainframe, $my, $acl, $mosConfig_list_limit;

        $filter_type        = $mainframe->getUserStateFromRequest( "filter_type{$option}", 'filter_type', 0 );
        $filter_logged        = $mainframe->getUserStateFromRequest( "filter_logged{$option}", 'filter_logged', 0 );
        $limit                         = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
        $limitstart         = $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 );
        $search                 = $mainframe->getUserStateFromRequest( "search{$option}", 'search', '' );
        $search                 = $database->getEscaped( trim( strtolower( $search ) ) );
        $where                         = array();

        if (isset( $search ) && $search!= "") {
                $where[] = "(a.username LIKE '%$search%' OR a.email LIKE '%$search%' OR a.name LIKE '%$search%')";
        }
        if ( $filter_type ) {
                if ( $filter_type == 'Public Frontend' ) {
                        $where[] = "a.usertype = 'Registered' OR a.usertype = 'Author' OR a.usertype = 'Editor'OR a.usertype = 'Publisher'";
                } else if ( $filter_type == 'Public Backend' ) {
                        $where[] = "a.usertype = 'Manager' OR a.usertype = 'Administrator' OR a.usertype = 'Super Administrator'";
                } else {
                        $where[] = "a.usertype = LOWER( '$filter_type' )";
                }
        }
        if ( $filter_logged == 1 ) {
                $where[] = "s.userid = a.id";
        } else if ($filter_logged == 2) {
                $where[] = "s.userid IS NULL";
        }

        // exclude any child group id's for this user
        //$acl->_debug = true;
        $pgids = $acl->get_group_children( $my->gid, 'ARO', 'RECURSE' );

        if (is_array( $pgids ) && count( $pgids ) > 0) {
                $where[] = "(a.gid NOT IN (" . implode( ',', $pgids ) . "))";
        }

        $query = "SELECT COUNT(*)"
        . "\n FROM #__users AS a"
        . "\n LEFT JOIN #__session AS s ON s.userid = a.id"
        . ( count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : '' )
        ;
        $database->setQuery( $query );
        $total = $database->loadResult();

        require_once( $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php' );
        $pageNav = new mosPageNav( $total, $limitstart, $limit  );

        $query = "SELECT a.*, g.name AS groupname, s.userid AS loggedin"
        . "\n FROM #__users AS a"
        . "\n INNER JOIN #__core_acl_aro AS aro ON aro.value = a.id"        // map user to aro
        . "\n INNER JOIN #__core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id"        // map aro to group
        . "\n INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = gm.group_id"
        . "\n LEFT JOIN #__session AS s ON s.userid = a.id"
        . (count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : "")
        . "\n GROUP BY a.id"
        . "\n LIMIT $pageNav->limitstart, $pageNav->limit"
        ;
        $database->setQuery( $query );
        $rows = $database->loadObjectList();

        if ($database->getErrorNum()) {
                echo $database->stderr();
                return false;
        }

        // get list of Groups for dropdown filter
        $query = "SELECT name AS value, name AS text"
        . "\n FROM #__core_acl_aro_groups"
        . "\n WHERE name != 'ROOT'"
        . "\n AND name != 'USERS'"
        ;
        $types[] = mosHTML::makeOption( '0', '- Select Group -' );
        $database->setQuery( $query );
        $types = array_merge( $types, $database->loadObjectList() );
        $lists['type'] = mosHTML::selectList( $types, 'filter_type', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', "$filter_type" );

        // get list of Log Status for dropdown filter
        $logged[] = mosHTML::makeOption( 0, '- Select Log Status - ');
        $logged[] = mosHTML::makeOption( 1, 'Logged In');
        $logged[] = mosHTML::makeOption( 2, 'Not Logged In');
        $lists['logged'] = mosHTML::selectList( $logged, 'filter_logged', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', "$filter_logged" );

        HTML_users::showUsers( $rows, $pageNav, $search, $option, $lists );
}

function editUser( $uid='0', $option='users' ) {
        global $database, $my, $acl, $adminLanguage;

        $row = new mosUser( $database );
        // load the row from the db table
        $row->load( $uid );

        if ( $uid ) {
                $query = "SELECT * FROM #__contact_details WHERE user_id='". $row->id ."'";
                $database->setQuery( $query );
                $contact = $database->loadObjectList();
        } else {
                $contact         = NULL;
                $row->block = 0;
        }

        // check to ensure only super admins can edit super admin info
        if ( ( $my->gid < 25 ) && ( $row->gid == 25 ) ) {
                mosRedirect( 'index2.php?option=com_users', _NOT_AUTH );
        }

        $my_group = strtolower( $acl->get_group_name( $row->gid, 'ARO' ) );
        if ( $my_group == 'super administrator' ) {
                $lists['gid'] = '<input type="hidden" name="gid" value="'. $my->gid .'" /><strong>'. $adminLanguage->A_COMP_USERS_SUPER_ADMIN .'</strong>';
        } else if ( $my->gid == 24 && $row->gid == 24 ) {
                $lists['gid'] = '<input type="hidden" name="gid" value="'. $my->gid .'" /><strong>Administrator</strong>';
        } else {
                // ensure user can't add group higher than themselves
                $my_groups = $acl->get_object_groups( 'users', $my->id, 'ARO' );
                if (is_array( $my_groups ) && count( $my_groups ) > 0) {
                        $ex_groups = $acl->get_group_children( $my_groups[0], 'ARO', 'RECURSE' );
                } else {
                        $ex_groups = array();
                }

                $gtree = $acl->get_group_children_tree( null, 'USERS', false );

                // remove users 'above' me
                $i = 0;
                while ($i < count( $gtree )) {
                        if (in_array( $gtree[$i]->value, $ex_groups )) {
                                array_splice( $gtree, $i, 1 );
                        } else {
                                $i++;
                        }
                }

                $lists['gid']                 = mosHTML::selectList( $gtree, 'gid', 'size="10"', 'value', 'text', $row->gid );
        }

        // build the html select list
        $lists['block']                 = mosHTML::yesnoRadioList( 'block', 'class="inputbox" size="1"', $row->block );
        // build the html select list
        $lists['sendEmail']         = mosHTML::yesnoRadioList( 'sendEmail', 'class="inputbox" size="1"', $row->sendEmail );

        HTML_users::edituser( $row, $contact, $lists, $option, $uid );
}

function saveUser( $option, $task ) {
        global $database, $my;
        global $mosConfig_live_site, $mosConfig_mailfrom, $mosConfig_fromname, $mosConfig_sitename;

        $row = new mosUser( $database );
        if (!$row->bind( $_POST )) {
                echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
                exit();
        }

        $isNew         = !$row->id;
        $pwd         = '';

        // MD5 hash convert passwords
        if ($isNew) {
                // new user stuff
                if ($row->password == '') {
                        $pwd = mosMakePassword();
                        $row->password = md5( $pwd );
                } else {
                        $pwd = $row->password;
                        $row->password = md5( $row->password );
                }
                $row->registerDate = date( 'Y-m-d H:i:s' );
        } else {
                // existing user stuff
                if ($row->password == '') {
                        // password set to null if empty
                        $row->password = null;
                } else {
                        $row->password = md5( $row->password );
                }
        }

        // save usertype to usetype column
        $query = "SELECT name"
        . "\n FROM #__core_acl_aro_groups"
        . "\n WHERE group_id = $row->gid"
        ;
        $database->setQuery( $query );
        $usertype = $database->loadResult();
        $row->usertype = $usertype;

        if (!$row->check()) {
                echo "<script> alert('".$row->getError()."'); window.history.go(-2); </script>\n";
                exit();
        }
        if (!$row->store()) {
                echo "<script> alert('".$row->getError()."'); window.history.go(-2); </script>\n";
                exit();
        }
        $row->checkin();

        // update the ACL
        if ( !$isNew ) {
                $query = "SELECT aro_id FROM #__core_acl_aro WHERE value='$row->id'";
                $database->setQuery( $query );
                $aro_id = $database->loadResult();

                $query = "UPDATE #__core_acl_groups_aro_map"
                . "\n SET group_id = '$row->gid'"
                . "\n WHERE aro_id = '$aro_id'"
                ;
                $database->setQuery( $query );
                $database->query() or die( $database->stderr() );
        }

        // for new users, email username and password
        if ($isNew) {
                $query = "SELECT email FROM #__users WHERE id=$my->id";
                $database->setQuery( $query );
                $adminEmail = $database->loadResult();

                $subject = _NEW_USER_MESSAGE_SUBJECT;
                $message = sprintf ( _NEW_USER_MESSAGE, $row->name, $mosConfig_sitename, $mosConfig_live_site, $row->username, $pwd );

                if ($mosConfig_mailfrom != "" && $mosConfig_fromname != "") {
                        $adminName = $mosConfig_fromname;
                        $adminEmail = $mosConfig_mailfrom;
                } else {
                        $query = "SELECT name, email FROM #__users WHERE usertype='superadministrator'";
                        $database->setQuery( $query );
                        $rows = $database->loadObjectList();
                        $row = $rows[0];
                        $adminName = $row->name;
                        $adminEmail = $row->email;
                }
                mosMail( $adminEmail, $adminName, $row->email, $subject, $message );
        }

        switch ( $task ) {
                case 'apply':
                        $msg = 'Successfully Saved changes to User: '. $row->name;
                        mosRedirect( 'index2.php?option=com_users&task=editA&hidemainmenu=1&id='. $row->id, $msg );

                case 'save':
                default:
                        $msg = 'Successfully Saved User: '. $row->name;
                        mosRedirect( 'index2.php?option=com_users', $msg );

                        break;
        }
}

/**
* Cancels an edit operation
* @param option component option to call
*/
function cancelUser( $option ) {
        mosRedirect( 'index2.php?option='. $option .'&task=view' );
}

function removeUsers( $cid, $option ) {
        global $database, $acl, $my, $adminLanguage;

        if (!is_array( $cid ) || count( $cid ) < 1) {
                echo "<script> alert(\"". $adminLanguage->A_COMP_CONTENT_SEL_DEL ."\"); window.history.go(-1);</script>\n";
                exit;
        }

        if ( count( $cid ) ) {
                $obj = new mosUser( $database );
                foreach ($cid as $id) {
                        // check for a super admin ... can't delete them
                        $groups         = $acl->get_object_groups( 'users', $id, 'ARO' );
                        $this_group = strtolower( $acl->get_group_name( $groups[0], 'ARO' ) );
                        if ( $this_group == 'super administrator' ) {
                                $msg . $adminLanguage->A_COMP_USERS_CANNOT;
                        } else if ( $id == $my->id ){
                                $msg . $adminLanguage->A_COMP_USERS_NOT_DEL_SELF;
                        } else if ( ( $this_group == 'administrator' ) && ( $my->gid == 24 ) ){
                                $msg . $adminLanguage->A_COMP_USERS_NOT_DEL_ADMIN;
                        } else {
                                $obj->delete( $id );
                                $msg = $obj->getError();
                        }
                }
        }

        mosRedirect( 'index2.php?option='. $option, $msg );
}

/**
* Blocks or Unblocks one or more user records
* @param array An array of unique category id numbers
* @param integer 0 if unblock, 1 if blocking
* @param string The current url option
*/
function changeUserBlock( $cid=null, $block=1, $option ) {
        global $database, $my, $adminLanguage;

        if (count( $cid ) < 1) {
                $action = $block ? 'block' : 'unblock';
                echo "<script> alert(\"". $adminLanguage->A_COMP_SEL_ITEM ." ". $action ."\"); window.history.go(-1);</script>\n";
                exit;
        }

        $cids = implode( ',', $cid );

        $query = "UPDATE #__users SET block='$block' WHERE id IN ($cids)";
        $database->setQuery( $query );
        if (!$database->query()) {
                echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
                exit();
        }

        mosRedirect( 'index2.php?option='. $option );
}

/**
* @param array An array of unique user id numbers
* @param string The current url option
*/
function logoutUser( $cid=null, $option, $task ) {
        global $database, $my;

        $cids = $cid;
        if ( is_array( $cid ) ) {
                if (count( $cid ) < 1) {
                        mosRedirect( 'index2.php?option='. $option, 'Please select a user' );
                }
                $cids = implode( ',', $cid );
        }

        $query = "DELETE FROM #__session WHERE userid IN ($cids)";
        $database->setQuery( $query );
        $database->query();

        switch ( $task ) {
                case 'flogout':
                        mosRedirect( 'index2.php', $database->getErrorMsg() );
                        break;

                default:
                        mosRedirect( 'index2.php?option='. $option, $database->getErrorMsg() );
                        break;
        }
}

function is_email($email){
        $rBool=false;

        if(preg_match("/[\w\.\-]+@\w+[\w\.\-]*?\.\w{1,4}/", $email)){
                $rBool=true;
        }
        return $rBool;
}

?>