php - 将 PHP 中的引导分页限制为 5 页
问题描述
我正在尝试在显示 5 个页面的 PHP 中创建分页。
在第一页上,我们有:
[1]
[2][3][4][5] ...[325][>>]
单击 [325] 将带您到该页面(最后一条记录),单击向右箭头将带您到页面 [2]。
在第二页时,我们有: [<<][1]... [2]
[3][4][5][6] ...[325][>>]
当在最后一页时,我们有:
[<<][1]...[321][322][323][324][325]
我一直在研究如何在没有太多运气的情况下做到这一点。我想我知道当我们在除第一页或最后一页之外的任何页面上时,我需要在活动页面的每一侧创建一个相邻页面为 2 的数组。我还需要创建一个<li><a href="site_members.php?Page=1">1</a></li>
和
<li><a href="site_members.php?Page=<?php echo $last_record; ?>"><?php echo $last_record; ?></a></li>
当用户在除第一条或最后一条记录之外的任何地方时。
我的以下代码效果很好,但是当我们开始获取大量记录时,分页计数变得荒谬。
<ul class="pagination pull-left pagination-md">
<?php
// Creates back button in pagination
if(isset($page)) {
if($page > 1) {
$page_minus = $page-1;
echo "<li><a href='blog.php?page=$page_minus'> « </a></li>";
}
}
?>
<?php
global $con;
$q_pagination = mysqli_prepare($con, "SELECT COUNT(*) FROM admin_panel WHERE ");
$q_pagination->execute();
$result_pagination = $q_pagination->get_result();
$rows_result = $result_pagination->fetch_array();
$total_rows = array_shift($rows_result);
$post_per_page = $total_rows/15;
$post_per_page = ceil($post_per_page);
for($i = 1; $i <= $post_per_page; $i++) {
if(isset($page)){
if($i == $page) {
echo "<li class='active'><a href='blog.php?page=$i'>$i</a></li>";
}
else {
echo "<li><a href='blog.php?page=$i'>$i</a></li>";
}
}
}
// Creates the forward button in pagination
if(isset($page)){
if($page+1 <= $post_per_page) {
$page_plus = $page+1;
echo "<li><a href='blog.php?page=$page_plus'> » </a></li>";
}
}
?>
</ul>
我承认,在研究并尝试完成这项工作之后,我只是在逻辑上被扭曲了。有没有人对如何最好地解决这个问题有任何想法?线索、当前示例等。我发现的大部分内容都过时、不完整或冗长。
解决方案
<?php
session_start();
包括“mysqli_connect.php”;
$companyID = $_SESSION['compid'];
$db = new Database();
$dbc = $db->getConnection();
$display = 3; //number of records per page
$pages;
$dbb = new Database();
$dbcb = $dbb->getConnection();
$stat = "select * from reservationStatus where resStatId = '$companyID' ";
$r = mysqli_query($dbcb, $stat);
//variable for sorting - default is for registration date
$sort = (isset($_GET['sort'])) ? $_GET['sort'] : 'rd';
switch ($sort)
{
case 'ln':
$orderby = 'uniquenumber ASC';
break;
case 'fn':
$orderby = 'status ASC';
break;
case 'rd':
$orderby = 'resId ASC';
break;
case 'em' :
$orderby = 'resDate ASC';
break;
default:
$orderby = 'resId ASC';
break;
}
if(isset($_GET['p']) ) //already calculated
{
$pages=$_GET['p'];
}
else
{
//get the total number of records from the table
$q = "select count(resId) from reservation where companyID = '$companyID'";
$r = mysqli_query($dbc, $q);
$row = mysqli_fetch_array($r, MYSQLI_NUM);
$records=$row[0];
if($records > $display ) //$display is the number of records per page
//ceil rounds fractions up to integer value
$pages=ceil($records/$display);
else
$pages = 1;
}
//now determine where in the database to start
if(isset($_GET['s']) ) //already calculated
$start=$_GET['s'];
else
$start = 0;
//$q = "select * from users LIMIT $start, $display";
$q = "select * from reservation where companyID = '$companyID' order by $orderby LIMIT $start, $display";
$r = mysqli_query($dbc, $q);
if($r)
{
echo '<br />';
//display a table of results
echo '<div class="container">';
echo '<h1> Your Orders </h1>';
echo '<table align="center" class="table table-bordered table-striped" width="60%">';
echo '<tr bgcolor="#87CEEB">
<td><b>View</b></td>
<td><b>Change Status</b></td>
<td><b><a href="viewOrdersForCompanies.php?sort=fn"> Reference Number</a></b></td>
<td><b><a href="viewOrdersForCompanies.php?sort=ln">Status</a></b></td>
<td><b><a href="viewOrdersForCompanies.php?sort=em">Date</a></b></td>
<td><b><a href="viewOrdersForCompanies.php?sort=rd">Total Price</a></b></td></tr>';
//above is the header
//loop below adds the user details
//use the following to set alternate backgrounds
$bg = '#eeeeee';
while($row = mysqli_fetch_array($r))
{
$stat = "select * from reservationStatus where resStatusId = $row[7] ";
$rr = mysqli_query($dbcb, $stat);
$roww = mysqli_fetch_array($rr);
$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee');
echo '<tr bgcolor="' . $bg. '">
<td><a href="viewTaskForCompany.php?did=' .$row[0]. '">View</a></td>
<td><a href="changeOrderStatus.php?id=' . $row[0].'">Change Status </a></td>
<td>'.$row[2].'</td>
<td>'.$roww[1].'</td>
<td>'.$row[1]. ' ' . $row[8].'</td>
<td>'.$row[3].'</td>
</tr>';
}
echo '</table></div>';
}
else
{
echo '<p class="error">' . $q . '</p>';
echo '<p class="error"> Oh dear. There was an error</p>';
echo '<p class="error">' . mysqli_error($dbc) .'</p>';
}
mysqli_free_result($r);
//makes links to other pages if required
if($pages > 1)
{
echo '<br /><p> ' ;
//find out what page we are on
$currentpage = ($start/$display)+1;
//need a previous button if not first page
if($currentpage != 1)
{
echo ' <a href="viewOrdersForCompanies.php?$s=' . ($start - $display) .
'&p=' .$pages . '&sort='.$sort.'"> Previous </a>';
}
//create the numbered pages
for($i = 1; $i <= $pages; $i++)
{
if($i != $currentpage)
{
//the 's' paramater is used in the link to determine which the value
// in the LIMIT clause used in the select statement near the top of the page
echo '<a href="viewOrdersForCompanies.php?s=' . (($display * ($i-1))) . '&p='
. $pages . '&sort='.$sort.'"> ' . $i . ' </a>';
}
//  is a character to insert a whitespace
}
//if not last page create next button
if($currentpage != $pages)
{
echo '<a href="viewOrdersForCompanies.php?s=' . ($start+$display) . '&p=' . $pages
. '&sort='.$sort.'"> Next </a>';
}
echo '</p>';
}
?>
推荐阅读
- javascript - 如何重新选择列表框中的项目?
- python - 有没有办法将日期与可以将其分类为三个类别之一的表格进行比较?
- python - 使用 iterrows() 时修改数据不起作用
- unetstack - unetsim:是否有通过仅指定坐标而不是速度或方向来将节点从一个坐标移动到另一个坐标的功能?
- java - OpenCV:眼睛的矩形从面部 ROI 移位
- python - 将不可接受的单元格转换为“”(空白或跳过)
- r - 在 selectInput 中添加水平滚动条
- python-3.x - 在烧瓶应用程序中设置上传图像的目标路径
- windows-embedded-compact - wince 7开机黑屏
- python - 将数组附加到一个更大的数组,然后返回它