javascript - 简化表格分页ajax php mysql

Question

新手在这里。我需要一些帮助来简化我的分页表。这是我目前的分页。

但我想做这样的。

可以通过对我的代码进行细微更改来实现吗？

在这里我附上我的分页代码以供参考。

帖子.php

<?php
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(404);
    echo "<h1>404 Page Not found!</h1>";
    exit;
}

require 'db_connection.php';

if(isset($_POST['page'])) {
    $page_num = filter_var($_POST['page'], FILTER_VALIDATE_INT,[
        'options' => [
            'default' => 1,
            'min_range' => 1
        ]
    ]); 
    
} else { $page_num = 1; }

$page_limit = 5;
$page_offset = $page_limit * ($page_num - 1);

function showPosts($conn, $current_page_num, $page_limit, $page_offset){
    $query = mysqli_query($conn,"SELECT * FROM users LIMIT $page_limit OFFSET $page_offset");
    if(mysqli_num_rows($query) > 0) {
        while($row = mysqli_fetch_array($query)) { 
            echo '<li><b>'.$row['firstname']." / ".$row['lastname'].'</b><p>'.$row['email'].'</p></li>';
        }
        $total_posts = mysqli_num_rows(mysqli_query($conn,"SELECT * FROM users"));
        $total_page = ceil($total_posts / $page_limit);
        $next_page = $current_page_num+1; 
        $prev_page = $current_page_num-1; 
        
       echo "<li>";
        if($current_page_num > 1) {
           echo '<a href="'.$prev_page.'" class="page_link">Prev</a>';
        }
        for($i = 1; $i <= $total_page; $i++) {
            if($i == $current_page_num){
                echo '<a href="'.$i.'" class="page_link active_page">'.$i.'</a>';
            }else{
                echo '<a href="'.$i.'" class="page_link">'.$i.'</a>';
            }
            
        }
        if($total_page+1 != $next_page) {
           echo '<a href="'.$next_page.'" class="page_link">Next</a>';
        }
        echo "</li>";
    } else { echo "No Data found !"; }
}
showPosts($conn, $page_num, $page_limit, $page_offset);
?>

标签： javascriptphphtmlmysqlpagination