About simple implementation of php paging code

This time I will bring you a simple implementation of PHP paging code. The following is the specific content. Follow the editor to take a look.

Database operation class code

<?php
// 数据库连接常量
define(&#39;DB_HOST&#39;, &#39;localhost&#39;);
define(&#39;DB_USER&#39;, &#39;root&#39;);
define(&#39;DB_PWD&#39;, &#39;&#39;);
define(&#39;DB_NAME&#39;, &#39;guest&#39;);

// 连接数据库
function conn()
{
    $conn = mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_NAME);
    mysqli_query($conn, "set names utf8");
    return $conn;
}

//获得结果集
function doresult($sql){
   $result=mysqli_query(conn(), $sql);
   return  $result;
}

//结果集转为对象集合
function dolists($result){
    return mysqli_fetch_array($result, MYSQL_ASSOC);
}

function totalnums($sql) {
    $result=mysqli_query(conn(), $sql);
    return $result->num_rows;
}

// 关闭数据库
function closedb()
{
    if (! mysqli_close()) {
        exit(&#39;关闭异常&#39;);
    }
}

?>

Paging implementation code:

<?php
include &#39;mysqli.func.php&#39;;

// 总记录数
$sql = "SELECT dg_id  FROM  tb_user ";
$totalnums = totalnums($sql);

// 每页显示条数
$fnum = 8;

// 翻页数
$pagenum = ceil($totalnums / $fnum);

// 页数常量
@$tmp = $_GET[&#39;page&#39;];

//防止恶意翻页
if ($tmp > $pagenum)
    echo "<script>window.location.href=&#39;index.php&#39;</script>";

//计算分页起始值
if ($tmp == "") {
    $num = 0;
} else {
    $num = ($tmp - 1) * $fnum;
}

// 查询语句
$sql = "SELECT dg_id,dg_username  FROM  tb_user ORDER BY dg_id DESC LIMIT " . $num . ",$fnum";
$result = doresult($sql);

// 遍历输出
while (! ! $rows = dolists($result)) {
    echo $rows[&#39;dg_id&#39;] . " " . $rows[&#39;dg_username&#39;] . "<br>";
}

// 翻页链接
for ($i = 0; $i < $pagenum; $i ++) {
    echo "<a href=index.php?page=" . ($i + 1) . ">" . ($i + 1) . "</a>";
}
?>

Simple implementation of page turning function, please configure the database structure yourself

The above is the detailed content of About simple implementation of php paging code. For more information, please follow other related articles on the PHP Chinese website!