任何人都可以帮我尝试以下代码的分页...！

debugcn 发表于 Dev

玛尼·坎丹（Mani Kandan）

在下面，我附上了表格结构，请仔细检查一下它。

我想获得序列号作为我的第一列，后跟id和name。序列号应该继续进行分页，而不是从1日开始。提前致谢..

表结构是

create table departments (

 id INT(20) AUTO_INCREMENT PRIMARY KEY, 

name VARCHAR(30) NOT NULL);

<html>
<head>
<?php
    $db_connection = new mysqli("localhost","root","","emp_app");
    if($db_connection->connect_error)
        die("connection failed".$db_connection->connect_error); 
?>
</head>
<body>
    <table>
        <tr>
            <th>Serial no </th>
            <th>id</th>
            <th>name</th>
        </tr>
        <?php
        $sql_query = "select * from departments";
        $result = $db_connection->query($sql_query);
        if($result->num_rows > 0){
            while($rows = $result->fetch_assoc()){
                 echo "<tr>";
                 echo "<td>".$rows["id"]."<td>";
                 echo "<td>".$rows["name"]."<td>";
                 echo "<tr>";
            }
        }
        ?>
    </table>
</body>

MKD

这里是一个很好的例子，如何添加分页在PHP在PHP分页 Refrence链接是使用depricated MySQL查询你需要用mysqli的查询，以取代

 $num_rec_per_page=10;

    if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
    $start_from = ($page-1) * $num_rec_per_page; 
    $sql = "SELECT * FROM departments LIMIT $start_from, $num_rec_per_page"; 
    $rs_result = $db_connection->query ($sql); //run the query
$serial=1;
    while ($row = $result->fetch_assoc) { 
          //code here 
echo $serial;
$serial++;
    }; 

    $sql = "SELECT * FROM departments";  //select query for total records
    $rs_result = $db_connection->query($sql); //run the query
    $total_records =$rs_result->num_rows;  //count number of records
    $total_pages = ceil($total_records / $num_rec_per_page); 

    echo "<a href='pagination.php?page=1'>".'|<'."</a> "; // Goto 1st page  

    for ($i=1; $i<=$total_pages; $i++) { 
                echo "<a href='pagination.php?page=".$i."'>".$i."</a> "; 
    }; 
    echo "<a href='pagination.php?page=$total_pages'>".'>|'."</a> "; // Goto last page
    ?>

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。