網頁設計實驗室

 
      <?php
          // 假設已建立資料庫連線 $conn

          // 每頁顯示的記錄數
          $records_per_page = 10;

          // 取得當前頁數 (若沒有傳遞，則設為 1)
          $page = isset($_GET['page']) ? $_GET['page'] : 1;

          // 計算起始記錄
          $start_from = ($page-1) * $records_per_page;

          // 查詢總記錄數
          $result = $conn->query("SELECT COUNT(*) AS total_records FROM your_table");
          $row = $result->fetch_assoc();
          $total_records = $row['total_records'];

          // 計算總頁數
          $total_pages = ceil($total_records / $records_per_page);

          // 執行分頁查詢
          $sql = "SELECT * FROM your_table LIMIT $start_from, $records_per_page";
          $result = $conn->query($sql);

          // 顯示查詢結果 (這裡用迴圈遍歷並顯示每一行資料)
          while($row = $result->fetch_assoc()) {
              echo $row["column1"] . " " . $row["column2"] . "<br>";
          }

          // 顯示分頁連結
          echo "<a href='?page=1'>第一頁</a> ";
          for ($i=1; $i<=$total_pages; $i++) {
              echo "<a href='?page=$i'>$i</a> ";
          }
          echo "<a href='?page=$total_pages'>最後一頁</a>";
          ?>