我试图从数据库中列出一个数据,我想列出特定的类别,所以我使用WHERE语句。我得到正确的结果在第一页,但当我点击第二页它显示什么
<?php
include('dbconfig.inc.php');
$id=$_GET['id'];
$query = "SELECT * FROM distdb WHERE BANK_ID = '$id'";
$records_per_page=10;
$newquery = $paginate->paging($query,$records_per_page);
$paginate->dataview($newquery);
$paginate->paginglink($query,$records_per_page);
?>
和my Pagination.php
<?php
class paginate
{
private $db;
function __construct($dbh)
{
$this->db = $dbh;
}
public function dataview($query)
{
$stmt = $this->db->prepare($query);
$stmt->execute();
if($stmt->rowCount()>0)
{
while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{
$bank = $row['BANK'];
$ifsc = $row['IFSC'];
$branch= $row['BRANCH'];
$micr = $row['MICR_CODE'];
$address = $row['ADDRESS'];
$contact = $row['CONTACT'];
$city = $row['CITY'];
$district = $row['DISTRICT'];
$state = $row['STATE'];
$bankcode=$row['IFSC'];
$brcode = substr($bankcode, -6);
?>
<tr>
<td width="21%"><?=$bank?></td>
<td width="20%"><?=$branch?></td>
<td width="20%"><b>IFSC:</b><?=$ifsc?> <br /><b>MICR:</b><?=$micr?><br /><b>Branch Code:</b><?=$brcode?></td>
<td width="24%"><?=$address?><br /> <b>City :</b><?=$city?> <br /> <b>District :</b><?=$district?> <br /> <b>State:</b> <?=$state?></td>
<td width="15%"><?=$contact?></td>
</tr>
<?php
}
}
else
{
?>
<tr>
<td>Nothing here...</td>
</tr>
<?php
}
}
public function paging($query,$records_per_page)
{
$starting_position=0;
if(isset($_GET["page_no"]))
{
$starting_position=($_GET["page_no"]-1)*$records_per_page;
}
$query2=$query." limit $starting_position,$records_per_page";
return $query2;
}
public function paginglink($query,$records_per_page)
{
$self = $_SERVER['PHP_SELF'];
$stmt = $this->db->prepare($query);
$stmt->execute();
$total_no_of_records = $stmt->rowCount();
if($total_no_of_records > 0)
{
?><tr><td colspan="3"><?php
$total_no_of_pages=ceil($total_no_of_records/$records_per_page);
$current_page=1;
if(isset($_GET["page_no"]))
{
$current_page=$_GET["page_no"];
}
if($current_page!=1)
{
$previous =$current_page-1;
echo "<a href='".$self."?page_no=1'>First</a> ";
echo "<a href='".$self."?page_no=".$previous."'>Previous</a> ";
}
for($i=1;$i<=$total_no_of_pages;$i++)
{
if($i==$current_page)
{
echo "<strong><a href='".$self."?page_no=".$i."' style='color:red;text-decoration:none'>".$i."</a></strong> ";
}
else
{
echo "<a href='".$self."?page_no=".$i."'>".$i."</a> ";
}
}
if($current_page!=$total_no_of_pages)
{
$next=$current_page+1;
echo "<a href='".$self."?page_no=".$next."'>Next</a> ";
echo "<a href='".$self."?page_no=".$total_no_of_pages."'>Last</a> ";
}
?></td></tr><?php
}
}
}
?>
它的工作很好,当我只使用下面的语句,但我想用Where
过滤数据$query = "SELECT * FROM distdb";
在您的分页中,您只传递了您的页码,但没有银行id。因此,在您的第二个和其他页面将获得$id=$_GET['id']为NULL。你的查询将看起来像:
$query = "SELECT * FROM distdb WHERE BANK_ID = ''";
,你会得到一个空白的结果或一些空白BANK_ID的结果。
public function paginglink($query,$records_per_page)
{
$self = $_SERVER['PHP_SELF'];
$id=$_GET['id'];
$self .= '?id=' . $id;
$stmt = $this->db->prepare($query);
$stmt->execute();
$total_no_of_records = $stmt->rowCount();
if($total_no_of_records > 0)
{
?><tr><td colspan="3"><?php
$total_no_of_pages=ceil($total_no_of_records/$records_per_page);
$current_page=1;
if(isset($_GET["page_no"]))
{
$current_page=$_GET["page_no"];
}
if($current_page!=1)
{
$previous =$current_page-1;
echo "<a href='".$self."&page_no=1'>First</a> ";
echo "<a href='".$self."&page_no=".$previous."'>Previous</a> ";
}
for($i=1;$i<=$total_no_of_pages;$i++)
{
if($i==$current_page)
{
echo "<strong><a href='".$self."&page_no=".$i."' style='color:red;text-decoration:none'>".$i."</a></strong> ";
}
else
{
echo "<a href='".$self."&page_no=".$i."'>".$i."</a> ";
}
}
if($current_page!=$total_no_of_pages)
{
$next=$current_page+1;
echo "<a href='".$self."&page_no=".$next."'>Next</a> ";
echo "<a href='".$self."&page_no=".$total_no_of_pages."'>Last</a> ";
}
?></td></tr><?php
}
}
可以使用OFFSET
吗?对于简单的$offset = ($_GET['page'] - 1) * $per_page;
,并将其添加到查询末尾:YOUR-QUERY OFFSET $offset
。如果$offset
为空(或零),您不需要添加它。
将您的查询替换为以下查询
$query="SELECT * FROM distdb WHERE BANK_ID = $id"
因为$id
是一个变量而不是字符串