我有將資料庫提取到 html 表中的代碼。它很大，所以我想把它分成幾頁——比如說每頁 10 行。有什么好的方法可以做到嗎？請幫忙，我在編碼方面不是很有經驗。謝謝！
<html>
<head>
<title></title>
<style>
<?php include 'style.css'; ?>
</style>
</head>
<body>
<?php
$conn = mysqli_connect("localhost","root","","table_data");
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($conn, "SELECT id, user, userurl FROM table ORDER BY id ASC LIMIT 100");
$i = 0;
$table_grid = '<table border="0" cellpadding="0">';
while($row = mysqli_fetch_array($result)){
$id = $row['id'];
$owner = $row['user'];
$userurl = $row['userurl'];
if($i % 10==0){
$table_grid .= '<tr><td>
<h3>'.$id.'</h3>
<h3>'.$user.'</h3>
<h3>'.$userurl.'</h3>
</td>';
}else{
$table_grid .='<td>
<h3>'.$id.'</h3>
<h3>'.$user.'</h3>
<h3>'.$userurl.'</h3>
</td>';
}
$i ;
}
$table_grid .= '</tr></table>';
?>
<?php echo $table_grid; ?>
</body>
</html>
uj5u.com熱心網友回復：
你應該為你的代碼設定一個分頁。您可以在前端代碼中使用它，也可以使用ANDdatatable.js使用服務器端分頁。OFFSETLIMIT
1-資料表（前端分頁）：
將這些添加到您的代碼（資料表和 jquery）中：
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.js" integrity="sha512-n/4gHW3atM3QqRcbCn6ewmpxcLAHGaDjpEBu4xZd47N0W2oQ 6q7oc3PXstrJYXcbNU1OHdQ1T7pAP gi5Yu8g==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<link href="//cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css" rel="stylesheet" media="all">
<script src="//cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script>
$(document).ready( function () {
$('table').DataTable();
} );
</script>
2-后端：
更改您的查詢，例如：
<?php
/* start pagination codes */
$perpage = 5;
if(isset($_GET["page"])){
$page = intval($_GET["page"]);
}
else {
$page = 1;
}
$calc = $perpage * $page;
$start = $calc - $perpage;
$conn = mysqli_connect("localhost","root","","table_data");
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($conn, "SELECT id, user, userurl FROM table ORDER BY id ASC Limit $start, $perpage");
?>
然后使用：
<?php
if(isset($page))
{
$result = mysqli_query($conn,"select Count(*) As Total from table");
$rows = mysqli_num_rows($result);
if($rows)
{
$rs = mysqli_fetch_assoc($result);
$total = $rs["Total"];
}
$totalPages = ceil($total / $perpage);
if($page <=1 ){
echo "<span id='page_links' style='font-weight: bold;'>Prev</span>";
}
else
{
$j = $page - 1;
echo "<span><a id='page_a_link' href='?page=$j'>< Prev</a></span>";
}
for($i=1; $i <= $totalPages; $i )
{
if($i<>$page)
{
echo "<span><a id='page_a_link' href='?page=$i'>$i</a></span>";
}
else
{
echo "<span id='page_links' style='font-weight: bold;'>$i</span>";
}
}
if($page == $totalPages )
{
echo "<span id='page_links' style='font-weight: bold;'>Next ></span>";
}
else
{
$j = $page 1;
echo "<span><a id='page_a_link' href='?page=$j'>Next</a></span>";
}
}
?>
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/454712.html
下一篇：正則運算式拆分年、月和周