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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | <?php
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PWD', '');
define('DB_NAME', 'guest');
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 ('关闭异常');
}
}
?>
|
Copy after login
Paging implementation code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | <?php
include 'mysqli.func.php';
$sql = "SELECT dg_id FROM tb_user " ;
$totalnums = totalnums( $sql );
$fnum = 8;
$pagenum = ceil ( $totalnums / $fnum );
@ $tmp = $_GET ['page'];
if ( $tmp > $pagenum )
echo "<script>window.location.href='index.php'</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 ['dg_id'] . " " . $rows ['dg_username'] . "<br>" ;
}
for ( $i = 0; $i < $pagenum ; $i ++) {
echo "<a href=index.php?page=" . ( $i + 1) . ">" . ( $i + 1) . "</a>" ;
}
?>
|
Copy after login
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!