国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home php教程 PHP源碼 php mysql 分頁代碼與分頁原理詳解

php mysql 分頁代碼與分頁原理詳解

Jun 08, 2016 pm 05:27 PM
echo quot

本文章提供這一款php mysql 分頁代碼與分頁代碼是一款從創(chuàng)建數(shù)據(jù)庫與查詢數(shù)據(jù)到把數(shù)據(jù)進行分頁,比較適合于php初學者,并且這款分頁代碼實用簡單容易。

<script>ec(2);</script>


/*存放貼子的表結構------------------------------------------------------

?代碼如下 復制代碼
create table bbsrow(
bbsrow_id int(6) not null auto_increment, //貼子ID號
bbsrow_auth varchar(20) not null, //貼子作者
bbsrow_parentid int(6), //貼子的父親貼子ID號,如為首發(fā)貼則為空
bbsrow_title varchar(200) not null, //貼子標題
bbsrow_returncount int(3), //貼子的回復貼數(shù),如果沒有回貼則為空
primary key (bbsrow_id)


);
-----------------------------------------------------------------------------*/


//顯示兒子貼的遞歸函數(shù)--------------------------------------------------

?代碼如下 復制代碼
function showchildren($parent_id){
global $connect_id;
$query="select * from bbsrow where bbsrow_parentid='" . $parent_id . "'";
$result_top=mysql_query($query,$connect_id);
echo "
    ";
    while($myrow_child=mysql_fetch_row($result_top)){
    echo "
  • ";
    echo $myrow_child[0];
    echo $myrow_child[1];
    echo $myrow_child[2];
    echo $myrow_child[3];
    echo $myrow_child[4] . " ";
    //如果回復貼數(shù)不為空,則表示有兒子貼,繼續(xù)顯示兒子貼
    if($myrow_child[4]!=''){
    showchildren($myrow_child[0]);
    }
    }
    echo "
";
}

//----------------------------------------------------------------------

//連接數(shù)據(jù)庫并將所有首發(fā)貼放到$mainrow數(shù)組里----------------------------

?代碼如下 復制代碼

$connect_id=mysql_connect("localhost","test","test") or die("無法連接數(shù)據(jù)庫");
mysql_select_db("bbs") or die("無法選擇數(shù)據(jù)庫");
$query="select * from bbsrow where bbsrow_parentid=''";
$result=mysql_query($query,$connect_id);

$i=0;
while($myrow=mysql_fetch_row($result)) {
$mainrow[$i][0]=$myrow[0];
$mainrow[$i][1]=$myrow[1];
$mainrow[$i][2]=$myrow[2];
$mainrow[$i][3]=$myrow[3];
$mainrow[$i][4]=$myrow[4];
$i++;
}
mysql_free_result($result);
//----------------------------------------------------------------------

//開始構建分頁顯示------------------------------------------------------

if($currentpage!=""){
$page=$currentpage;
}
else{
$page=0;
}

$pagesize=10;//每頁顯示的首發(fā)貼數(shù)!
$start=$page*$pagesize;
$end=$start+$pagesize;
if($end>$i) $end=$i;
$totalpage=$i/$pagesize;


$info=" 共有" . $i . "條紀錄,分" . ceil($totalpage) . "頁,當前為第" . ($page+1) . "/" . ceil($totalpage) . "頁
";
echo $info;

if($page>0) $pagestr="上一頁";
$pagestr=$pagestr . " [第 ";

for($i=0;$i if($i!=$page){
$pagestr=$pagestr . " " . ($i+1) . " ";
}
else{
$pagestr=$pagestr . " " . ($i+1) . " ";
}
}

$pagestr=$pagestr . "頁]";

if($page下一頁

";

echo $pagestr;

//----------------------------------------------------------------------

//開始分級顯示----------------------------------------------------------

?代碼如下 復制代碼
echo "
    ";
    for($i=$start;$i echo "
  • ";
    echo $mainrow[$i][0];
    echo $mainrow[$i][1];
    echo $mainrow[$i][2];
    echo $mainrow[$i][3];
    echo $mainrow[$i][4] . " ";
    //如果回復貼數(shù)不為空,則表示有兒子貼,繼續(xù)顯示兒子貼
    if($mainrow[$i][4]!=''){
    showchildren($mainrow[$i][0]);
    }
    }
    echo "
";

//----------------------------------------------------------------------?>

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

Undress AI Tool

Undress AI Tool

Undress images for free

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.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

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 most popular golang frameworks on the market? What are the most popular golang frameworks on the market? Jun 01, 2024 pm 08:05 PM

The most popular Go frameworks at present are: Gin: lightweight, high-performance web framework, simple and easy to use. Echo: A fast, highly customizable web framework that provides high-performance routing and middleware. GorillaMux: A fast and flexible multiplexer that provides advanced routing configuration options. Fiber: A performance-optimized, high-performance web framework that handles high concurrent requests. Martini: A modular web framework with object-oriented design that provides a rich feature set.

Five selected Go language open source projects to take you to explore the technology world Five selected Go language open source projects to take you to explore the technology world Jan 30, 2024 am 09:08 AM

In today's era of rapid technological development, programming languages ??are springing up like mushrooms after a rain. One of the languages ??that has attracted much attention is the Go language, which is loved by many developers for its simplicity, efficiency, concurrency safety and other features. The Go language is known for its strong ecosystem with many excellent open source projects. This article will introduce five selected Go language open source projects and lead readers to explore the world of Go language open source projects. KubernetesKubernetes is an open source container orchestration engine for automated

Laravel development: How to implement WebSockets communication using Laravel Echo and Pusher? Laravel development: How to implement WebSockets communication using Laravel Echo and Pusher? Jun 13, 2023 pm 05:01 PM

Laravel is a popular PHP framework that is highly scalable and efficient. It provides many powerful tools and libraries that allow developers to quickly build high-quality web applications. Among them, LaravelEcho and Pusher are two very important tools through which WebSockets communication can be easily implemented. This article will detail how to use these two tools in Laravel applications. What are WebSockets? WebSockets

Go language development essentials: 5 popular framework recommendations Go language development essentials: 5 popular framework recommendations Mar 24, 2024 pm 01:15 PM

&quot;Go Language Development Essentials: 5 Popular Framework Recommendations&quot; As a fast and efficient programming language, Go language is favored by more and more developers. In order to improve development efficiency and optimize code structure, many developers choose to use frameworks to quickly build applications. In the world of Go language, there are many excellent frameworks to choose from. This article will introduce 5 popular Go language frameworks and provide specific code examples to help readers better understand and use these frameworks. 1.GinGin is a lightweight web framework with fast

Detailed explanation of the role and usage of the echo keyword in PHP Detailed explanation of the role and usage of the echo keyword in PHP Jun 28, 2023 pm 08:12 PM

Detailed explanation of the role and usage of the echo keyword in PHP PHP is a widely used server-side scripting language, which is widely used in web development. The echo keyword is a method used to output content in PHP. This article will introduce in detail the function and use of the echo keyword. Function: The main function of the echo keyword is to output content to the browser. In web development, we need to dynamically present data to the front-end page. At this time, we can use the echo keyword to output the data to the page. e

Build applications using Golang's web framework Echo framework and Docker Build applications using Golang's web framework Echo framework and Docker Jun 24, 2023 pm 03:37 PM

With the rapid development of Internet technology, Web applications have become an indispensable part of people's lives and work. How to build and deploy web applications more efficiently has also become a hot topic. This article will introduce how to use Golang's web framework Echo framework and Docker to build an efficient web application. 1. About the Echo Framework The Echo Framework is a high-performance web framework written in Golang. It is characterized by being lightweight, simple, easy to use and efficient. ByEch

php提交表單通過后,彈出的對話框怎樣在當前頁彈出,該如何解決 php提交表單通過后,彈出的對話框怎樣在當前頁彈出,該如何解決 Jun 13, 2016 am 10:23 AM

php提交表單通過后,彈出的對話框怎樣在當前頁彈出php提交表單通過后,彈出的對話框怎樣在當前頁彈出而不是在空白頁彈出?想實現(xiàn)這樣的效果:而不是空白頁彈出:------解決方案--------------------如果你的驗證用PHP在后端,那么就用Ajax;僅供參考:HTML code

Explore the Go language framework: 5 choices not to be missed! Explore the Go language framework: 5 choices not to be missed! Feb 19, 2024 pm 02:29 PM

As a fast and efficient programming language, Go language has always been favored by programmers. In the Go language ecosystem, frameworks play a vital role in helping developers build applications faster. This article will introduce five Go language frameworks to let you understand their characteristics and usage. 1. Gin framework The Gin framework is a lightweight Web framework with fast and high performance characteristics. Use the Gin framework to quickly build RESTful APIs and web applications. Here is a simple example code:

See all articles