PHP 分页种

Jun 13, 2016 pm 12:35 PM
gt quot this

PHP 分页类
下面是我自己的分页类,可适当的修改 

<?php /** 
 * @name Pager's class 
 * @author Refer 
 * @copyright www.phpcq.com 
 * @version Alpha 1.0 
 * @todo 下拉菜单分页---From表单传&#20540;...可以根据自己的情况(采用GET传&#20540;) 
 * 
 */ 
class Pager{ 
    /** 
     * startRow 
     * 
     * @var Int 
     */ 
    public $startRow; 
    /** 
     * 页面的总数 
     * 
     * @var Int 
     */ 
    public $pageTotal; 
    /** 
     *翻页&#20540; 
     * 
     * @var Int 
     */ 
    public $offset; 
    /** 
     * 每页所显示记录数 
     * 
     * @var Int 
     */ 
    public $pageSize; 
    /** 
     * get参数 
     * 
     * @var Int 
     */ 
    public $get; 
    /** 
     * post参数 
     * 
     * @var Int 
     */ 
    public $post; 
    /** 
     * 构造函数--初始化翻页类 (PS:^_^不错的php开发学习交流群:256271784,验证:gole,有兴趣的话可以加入进来一起讨论)
     * 
     * @param Int $total 
     * @param Int $pageSize 
     */ 
    public function __construct($total,$pageSize){ 
        $this->get = (int)$_GET['startRow']; 
        $this->post = (int)$_POST['pageNums']; 
        $this->pageSize = $pageSize; 
        $this->pageTotal = ceil($total / $pageSize); 
        switch ($_GET['method']){ 
            default: 
                $this->startRow = 1; 
                $this->offset = 0; 
            break; 
            case 'first': 
                $this->first(); 
            break;     
            case 'previous': 
                $this->previous(); 
            break;     
            case 'next': 
                $this->next(); 
            break;     
            case 'last': 
                $this->last(); 
            break;     
        } 
    }  
    /** 
     * 首页方法 
     * 
     */ 
    public function first(){ 
        $this->startRow = 1; 
        $this->offset = ($this->startRow - 1) * $this->pageSize;
    } 
    /** 
     * 上一页方法 
     * 
     */ 
    public function previous(){ 
        $this->startRow = $this->get - 1; 
        if ($this->startRow startRow = 1; 
        } 
        $this->offset = ($this->startRow - 1) * $this->pageSize;
    } 
    /** 
     * 下一页方法 
     * 
     */ 
    public function next(){ 
        $this->startRow = $this->get + 1; 
        if ($this->startRow > $this->pageTotal) { 
            $this->startRow = $this->pageTotal; 
        } 
        $this->offset = ($this->startRow - 1) * $this->pageSize;
    } 
    /** 
     * 最后页方法 
     * 
     */ 
    public function last(){ 
        $this->startRow = $this->pageTotal; 
        $this->offset = ($this->startRow - 1) * $this->pageSize;
    } 
    /** 
     * 下拉菜单翻页 
     * 
     * @return Int 
     */ 
    public function numPages(){ 
        if ($this->post) { 
            $pageNums = "<option>$this->post</option>"; 
            $this->startRow = $this->post; 
            $this->offset = ($this->post - 1) * $this->pageSize;
        } 
        for ($i = 1; $i pageTotal;$i++){ 
            if ($i != $this->post) { 
                $pageNums .= "<option>$i</option>"; 
            } 
        } 
        return $pageNums; 
    } 
    /** 
     * 当前是第几页 
     * 
     * @return Int 
     */ 
    public function noncePage(){ 
        if ($this->post) { 
            return $this->startRow = $this->post; 
        } else { 
            return $this->startRow = $this->startRow; 
        } 
    } 
} 
Copy after login


调用方法: 
$total = $total->total();//总记录 
            $pageSize = 15;//每页显示的记录 
            $pager = new Pager($total,$pageSize); 
            if ($pager->post){$startRow = $pager->noncePage();} 
            $startRow = $pager->startRow; 
            $pager->numPages(); 
            $article->query("SELECT * FROM `categories` as c,`articles` as n WHERE c.id = n.pid
                    ORDER BY n.id DESC LIMIT $pager->offset,$pageSize"); 
            while ($article->fetchArray()) { 
                $article->data['content'] = mb_substr(strip_tags($article->data['content']),0,40,'utf-8'); 
                $articleIndex[] = $article->data;             
            } 
            $article->free(); 
        } else { 
            header("location:?act=login"); 
        } 
        $view->view->assign('startRow',$startRow);//caption 
        $view->view->assign('total',$total);//caption 
        $view->view->assign('pageNums',$pager->numPages());//pageNums 
        $view->view->assign('noncePage',$pager->noncePage());//pageNums 
        $view->view->assign('pageTotal',$pager->pageTotal);//pageTotal  
Copy after login


模板页面: 
<!--{if $pageTotal > 1}--> 
 
Copy after login

本文出自 “清源教育” 博客,转载请注明此处,谢谢!欢迎登录清源教育官网,查看更多视频教程。
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What are the differences between Huawei GT3 Pro and GT4? What are the differences between Huawei GT3 Pro and GT4? Dec 29, 2023 pm 02:27 PM

Many users will choose the Huawei brand when choosing smart watches. Among them, Huawei GT3pro and GT4 are very popular choices. Many users are curious about the difference between Huawei GT3pro and GT4. Let’s introduce the two to you. . What are the differences between Huawei GT3pro and GT4? 1. Appearance GT4: 46mm and 41mm, the material is glass mirror + stainless steel body + high-resolution fiber back shell. GT3pro: 46.6mm and 42.9mm, the material is sapphire glass + titanium body/ceramic body + ceramic back shell 2. Healthy GT4: Using the latest Huawei Truseen5.5+ algorithm, the results will be more accurate. GT3pro: Added ECG electrocardiogram and blood vessel and safety

Fix: Snipping tool not working in Windows 11 Fix: Snipping tool not working in Windows 11 Aug 24, 2023 am 09:48 AM

Why Snipping Tool Not Working on Windows 11 Understanding the root cause of the problem can help find the right solution. Here are the top reasons why the Snipping Tool might not be working properly: Focus Assistant is On: This prevents the Snipping Tool from opening. Corrupted application: If the snipping tool crashes on launch, it might be corrupted. Outdated graphics drivers: Incompatible drivers may interfere with the snipping tool. Interference from other applications: Other running applications may conflict with the Snipping Tool. Certificate has expired: An error during the upgrade process may cause this issu simple solution. These are suitable for most users and do not require any special technical knowledge. 1. Update Windows and Microsoft Store apps

How to Fix Can't Connect to App Store Error on iPhone How to Fix Can't Connect to App Store Error on iPhone Jul 29, 2023 am 08:22 AM

Part 1: Initial Troubleshooting Steps Checking Apple’s System Status: Before delving into complex solutions, let’s start with the basics. The problem may not lie with your device; Apple's servers may be down. Visit Apple's System Status page to see if the AppStore is working properly. If there's a problem, all you can do is wait for Apple to fix it. Check your internet connection: Make sure you have a stable internet connection as the "Unable to connect to AppStore" issue can sometimes be attributed to a poor connection. Try switching between Wi-Fi and mobile data or resetting network settings (General > Reset > Reset Network Settings > Settings). Update your iOS version:

php提交表单通过后,弹出的对话框怎样在当前页弹出,该如何解决 php提交表单通过后,弹出的对话框怎样在当前页弹出,该如何解决 Jun 13, 2016 am 10:23 AM

php提交表单通过后,弹出的对话框怎样在当前页弹出php提交表单通过后,弹出的对话框怎样在当前页弹出而不是在空白页弹出?想实现这样的效果:而不是空白页弹出:------解决方案--------------------如果你的验证用PHP在后端,那么就用Ajax;仅供参考:HTML code

Is watch4pro better or gt? Is watch4pro better or gt? Sep 26, 2023 pm 02:45 PM

Watch4pro and gt each have different features and applicable scenarios. If you focus on comprehensive functions, high performance and stylish appearance, and are willing to bear a higher price, then Watch 4 Pro may be more suitable. If you don’t have high functional requirements and pay more attention to battery life and reasonable price, then the GT series may be more suitable. The final choice should be decided based on personal needs, budget and preferences. It is recommended to carefully consider your own needs before purchasing and refer to the reviews and comparisons of various products to make a more informed choice.

How to optimize iPad battery life with iPadOS 17.4 How to optimize iPad battery life with iPadOS 17.4 Mar 21, 2024 pm 10:31 PM

How to Optimize iPad Battery Life with iPadOS 17.4 Extending battery life is key to the mobile device experience, and the iPad is a good example. If you feel like your iPad's battery is draining too quickly, don't worry, there are a number of tricks and tweaks in iPadOS 17.4 that can significantly extend the run time of your device. The goal of this in-depth guide is not just to provide information, but to change the way you use your iPad, enhance your overall battery management, and ensure you can rely on your device for longer without having to charge it. By adopting the practices outlined here, you take a step toward more efficient and mindful use of technology that is tailored to your individual needs and usage patterns. Identify major energy consumers

An article that understands this point and catches up with 70% of front-end people An article that understands this point and catches up with 70% of front-end people Sep 06, 2022 pm 05:03 PM

A colleague got stuck due to a bug pointed by this. Vue2’s this pointing problem caused an arrow function to be used, resulting in the inability to get the corresponding props. He didn't know it when I introduced it to him, and then I deliberately looked at the front-end communication group. So far, at least 70% of front-end programmers still don't understand it. Today I will share with you this link. If everything is wrong If you haven’t learned it yet, please give me a big mouth.

How to use this method in Java How to use this method in Java Apr 18, 2023 pm 01:58 PM

1. this keyword 1. Type of this: Which object is called is the reference type of that object 2. Usage summary 1. this.data;//Access attribute 2. this.func();//Access method 3.this( );//Call other constructors in this class 3. Explanation of usage 1.this.data is used in member methods. Let us see what will happen if this is not added classMyDate{publicintyear;publicintmonth;publicintday; publicvoidsetDate(intyear,intmonth,intday){ye

See all articles