search
HomeBackend DevelopmentPHP TutorialRegarding the two paging styles of digital paging and text paging in php, mysql, and html for your reference_PHP tutorial

Please do not pirate, please add the source when reprinting http://blog.csdn.net/yanlintao1

Please do not pirate, please add the source when reprinting http://blog.csdn.net/yanlintao1

First of all, I hope it will be helpful to show you the style, and I also hope you can give me your opinions and suggestions:

The first type: digital paging

Second: Paginate text


php paging function (I wrote it in the common.inc.php public file introduced below):

/*
 *_page()分页的相关参数
 *@param int $_pagesize 每页存有几个好友
 *@param $_sql 获取所有字段
 * */
function _page($_sql,$_size){
    global $_pagenum,$_pagesize,$_pageabsolute,$_num,$_page;
    //分页模块以及容错处理
    //第几页
    if(isset( $_GET['page'])){
        $_page = $_GET['page'];
        if(empty($_page)||$_page<0||!is_numeric($_page)){
            $_page = 1;
        }else{
            $_page = intval($_page);
        }
    }else{
        $_page = 1;
    }
    //每页有几个好友
    $_pagesize = $_size;
    //得到所有数据综合
    $_num = _num_rows(_query($_sql));
    //ceil见大于等于1就进位,计算有多少页
    if($_num == 0){
        $_pageabsolute = 1;
    }else{
        $_pageabsolute = ceil($_num/$_pagesize);
    }
    if($_page>$_pageabsolute){
        $_page=$_pageabsolute;
    }
    //从数据库的第几条数据开始
    $_pagenum = ($_page-1)*$_pagesize;
}
/*
 * _paging分页函数
 * @access public 表示函数对外公开
 * @param int $_type 若为1则按数字分页,若为2按文本形式分页
 * $_pageabsolute 共多少页
 * $_page 第几页
 * $_num 一共有多少条数据
* */
function _paging($_type){
    global $_pageabsolute,$_page,$_num;
    if($_type==1){
        echo &#39;<div id="page_num">&#39;;
        echo &#39;<ul>&#39;;       
        for($i=0;$i<$_pageabsolute;$i++){
            if($_page==($i+1)){
                echo &#39;<li>&#39;.($i+1).&#39;</li>&#39;;
            }else{
                echo &#39;<li>&#39;.($i+1).&#39;</li>&#39;;
            }
        }
        echo &#39;</ul>&#39;;
        echo &#39;</div>&#39;;
    }elseif($_type==2){
       echo &#39;<div id="page_text">&#39;;
       echo &#39;<ul>&#39;;
       echo &#39;<li>&#39;.$_page.&#39;/&#39;.$_pageabsolute.&#39;页    |</li>&#39;;
       echo &#39;<li>共有<strong>&#39;.$_num.&#39;</strong>条数据    |</li>&#39;; 
       if($_page==1){
           echo &#39;<li>首页    |</li>&#39;;
           echo &#39;<li>下一页    |    </li>&#39;;
           echo &#39;<li>尾页    |    </li>&#39;;
       }elseif($_page==$_pageabsolute){
           echo &#39;<li>首页    |    </li>&#39;;                   	   
           echo &#39;<li>上一页    |    </li>&#39;;
           echo &#39;<li>尾页    |</li>&#39;;
       }else{
           echo &#39;<li>首页    |    </li>&#39;;
           echo &#39;<li>上一页    |    </li>&#39;;
           echo &#39;<li>下一页    |    </li>&#39;;
           echo &#39;<li>尾页    |    </li>&#39;;
        }             
        echo &#39;</ul>&#39;;  
        echo &#39;</div>&#39;;
        
    }
}

html code:

*/
//引入公共文件
require &#39;./includer/common.inc.php&#39;;
//分页模块,第一个参数获取总条数,第二个参数获得每页有几个好友
global $_pagenum,$_pagesize;
_page("SELECT tg_id FROM tg_guest", 2);
//从数据库中取数据,按照注册时间顺序排列
$_result = _query("SELECT tg_username,tg_sex,tg_face,tg_id FROM tg_guest ORDER BY tg_reg_time DESC LIMIT $_pagenum,$_pagesize");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>博友</title>
  <?php 
    require ROOT_PATH.&#39;includer/title.inc.php&#39;;
  ?> 
  <script type="text/javascript" src="js/blog_message.js"></script>
</head>
<body>

   <?php 
    require ROOT_PATH.&#39;includer/header.inc.php&#39;;
  ?>
    <div id="blog">
       <h2 id="博友界面">博友界面</h2>
       <?php 
       while(!!$_rows=_fetch_array_list($_result,MYSQL_ASSOC)){
           $_html = array();
           $_html[&#39;tg_username&#39;] = $_rows[&#39;tg_username&#39;];
           $_html[&#39;tg_face&#39;] = $_rows[&#39;tg_face&#39;];
           $_html[&#39;tg_sex&#39;] = $_rows[&#39;tg_sex&#39;];
           $_html[&#39;tg_id&#39;] = $_rows[&#39;tg_id&#39;];
           $_html = _html($_html);
        ?>
       <dl>
           <dt class="user"><?php echo $_html[&#39;tg_username&#39;]?>(<?php echo $_html[&#39;tg_sex&#39;]?>)</dt>
           <dt><img  src="http://blog.csdn.net/yanlintao1/article/details/<?php echo $_html[?x-oss-process=image/resize,p_40'tg_face']? alt="Regarding the two paging styles of digital paging and text paging in php, mysql, and html for your reference_PHP tutorial" >" alt="<?php echo $_html[&#39;tg_username&#39;]?>"></img></dt>
           <dd class="message">">发消息</dd>
           <dd class="friend">加好友</dd>
           <dd class="guest">写留言</dd>
           <dd class="flower">送鲜花</dd>      
       </dl>  
       <?php }?>
       <?php 
           //销毁结果集
           _free_result($_result);
           //1为数字分页,2为文本分页
           _paging(2);
       ?>
    </div>
   <?php 
    require ROOT_PATH.&#39;includer/footer.inc.php&#39;;    
  ?>

</body>
Please do not pirate, please add the source when reprinting http://blog.csdn.net/yanlintao1

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/802114.htmlTechArticlePlease do not pirate, please add the source for reprinting http://blog.csdn.net/yanlintao1 Please do not pirate, Please add the source when reprinting: http://blog.csdn.net/yanlintao1 First, let’s show the style. I hope it will be helpful to everyone...
Statement
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
Beyond the Hype: Assessing PHP's Role TodayBeyond the Hype: Assessing PHP's Role TodayApr 12, 2025 am 12:17 AM

PHP remains a powerful and widely used tool in modern programming, especially in the field of web development. 1) PHP is easy to use and seamlessly integrated with databases, and is the first choice for many developers. 2) It supports dynamic content generation and object-oriented programming, suitable for quickly creating and maintaining websites. 3) PHP's performance can be improved by caching and optimizing database queries, and its extensive community and rich ecosystem make it still important in today's technology stack.

What are Weak References in PHP and when are they useful?What are Weak References in PHP and when are they useful?Apr 12, 2025 am 12:13 AM

In PHP, weak references are implemented through the WeakReference class and will not prevent the garbage collector from reclaiming objects. Weak references are suitable for scenarios such as caching systems and event listeners. It should be noted that it cannot guarantee the survival of objects and that garbage collection may be delayed.

Explain the __invoke magic method in PHP.Explain the __invoke magic method in PHP.Apr 12, 2025 am 12:07 AM

The \_\_invoke method allows objects to be called like functions. 1. Define the \_\_invoke method so that the object can be called. 2. When using the $obj(...) syntax, PHP will execute the \_\_invoke method. 3. Suitable for scenarios such as logging and calculator, improving code flexibility and readability.

Explain Fibers in PHP 8.1 for concurrency.Explain Fibers in PHP 8.1 for concurrency.Apr 12, 2025 am 12:05 AM

Fibers was introduced in PHP8.1, improving concurrent processing capabilities. 1) Fibers is a lightweight concurrency model similar to coroutines. 2) They allow developers to manually control the execution flow of tasks and are suitable for handling I/O-intensive tasks. 3) Using Fibers can write more efficient and responsive code.

The PHP Community: Resources, Support, and DevelopmentThe PHP Community: Resources, Support, and DevelopmentApr 12, 2025 am 12:04 AM

The PHP community provides rich resources and support to help developers grow. 1) Resources include official documentation, tutorials, blogs and open source projects such as Laravel and Symfony. 2) Support can be obtained through StackOverflow, Reddit and Slack channels. 3) Development trends can be learned by following RFC. 4) Integration into the community can be achieved through active participation, contribution to code and learning sharing.

PHP vs. Python: Understanding the DifferencesPHP vs. Python: Understanding the DifferencesApr 11, 2025 am 12:15 AM

PHP and Python each have their own advantages, and the choice should be based on project requirements. 1.PHP is suitable for web development, with simple syntax and high execution efficiency. 2. Python is suitable for data science and machine learning, with concise syntax and rich libraries.

PHP: Is It Dying or Simply Adapting?PHP: Is It Dying or Simply Adapting?Apr 11, 2025 am 12:13 AM

PHP is not dying, but constantly adapting and evolving. 1) PHP has undergone multiple version iterations since 1994 to adapt to new technology trends. 2) It is currently widely used in e-commerce, content management systems and other fields. 3) PHP8 introduces JIT compiler and other functions to improve performance and modernization. 4) Use OPcache and follow PSR-12 standards to optimize performance and code quality.

The Future of PHP: Adaptations and InnovationsThe Future of PHP: Adaptations and InnovationsApr 11, 2025 am 12:01 AM

The future of PHP will be achieved by adapting to new technology trends and introducing innovative features: 1) Adapting to cloud computing, containerization and microservice architectures, supporting Docker and Kubernetes; 2) introducing JIT compilers and enumeration types to improve performance and data processing efficiency; 3) Continuously optimize performance and promote best practices.

See all articles

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)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function