php - 换页时可以发送数据吗[分页]

Question

我想使用分页查看按用户输入的日期排序的数据。

这就是我的查询的样子:

$pages_query = mysql_query("SELECT COUNT(id), BuyerName,BuyerEmail,TransactionID,DateTime 
               FROM `order` WHERE YEAR(DateTime)= $Year AND MONTH(DateTime) = $Month") 
or die(mysql_error());

$query = mysql_query("SELECT id, BuyerName,BuyerEmail,TransactionID,DateTime 
         FROM `order` WHERE YEAR(DateTime)= $Year AND 
         MONTH(DateTime) = $Month LIMIT $start, $per_page")
or die(mysql_error());

当我单击下一页时，它显示错误。当我只运行没有 WHERE 的查询时，分页效果很好。任何如何解决这个问题的建议都会很棒。

这是整个分页代码:

<?php

include('../include/conn.php');
$button = $_GET ['submit'];
$Month = $_GET ['Month'];
$Year = $_GET ['Year'];
$per_page = 5;
$adjacents = 6; 

$pages_query = mysql_query("SELECT COUNT(id), BuyerName,BuyerEmail,TransactionID,DateTime 
FROM `order`") 
or die(mysql_error());

//get total number of pages to be shown from  total result
$pages = ceil(mysql_result($pages_query, 0) / $per_page);

//get current page from URL ,if not present set it to 1
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1 ;

//calcuproduct_namee actual start page with respect to Mysql 
$start = ($page - 1) * $per_page;

//execute a mysql query to retrieve  all result from current page by using LIMIT keyword in mysql
//if  query  fails stop further execution and show mysql error

$query = mysql_query("SELECT id, BuyerName,BuyerEmail,TransactionID,DateTime FROM `order` 
WHERE YEAR(DateTime)= $Year AND MONTH(DateTime) = $Month LIMIT $start, $per_page")
         or die(mysql_error());

$pagination="Pagination";
//if current page is first show first only else reduce 1 by current page
$Prev_Page = ($page==1)?1:$page - 1;

//if current page is last show last  only else add  1 to  current page
$Next_Page = ($page>=$pages)?$page:$page + 1; 

//if we are not on first page show first link
if($page!=1) $pagination.= '<a href="?page=1">First</a>';
//if we are not on first page show previous link
if($page!=1) $pagination.='<a href="?page='.$Prev_Page.'">Previous</a>';

//we are going to display 5 links on pagination bar
$numberoflinks=5;

//find the number of links to show on right of current page
$upage=ceil(($page)/$numberoflinks)*$numberoflinks;
//find the number of links to show on left of current page
$lpage=floor(($page)/$numberoflinks)*$numberoflinks;
//if  number of links on left of current page are zero we start from 1
$lpage=($lpage==0)?1:$lpage;
//find the number of links to show on right of current page and make sure it must be less than total number of pages
$upage=($lpage==$upage)?$upage+$numberoflinks:$upage;
if($upage>$pages)$upage=($pages-1);
//start building links from left to right of current page
for($x=$lpage; $x<=$upage; $x++){
//if current building link is current page we don't show link,we show as text else we show as linkn 
$pagination.=($x == $page) ? ' <strong>'.$x.'</strong>' : ' <a href="?page='.$x.'">'.$x.'</a>' ;
}
//we show next link and last link if user doesn't on last page
if($page!=$pages) $pagination.=  '  <a href="?page='.$Next_Page.'">Next</a>';
if($page!=$pages) $pagination.=  ' <a href="?page='.$pages.'">Last</a>';


?>

当我点击下一步按钮时，它无法获取 $Month 和 $Year。

如何将数据发送到搜索的第 2 页？

Answer 1

1. 添加分页链接以包含年份和月份，例如:

当然，必须提供该值。它们看起来不像是在您的代码中设置的。所以，让他们像:

$Month = isset($_GET ['Month']) ? $_GET ['Month'] : '1';
$Year = isset($_GET['Year']) ? $_GET ['Year'] : '2015';

在查询字符串中使用 $year 和 $month 之前尝试转义它们:

$月 = mysql_real_escape_string($月);$Year = mysql_real_escape_string($Year);

如果上述失败，尝试echo并执行sql查询中的结果进行调试:

echo "SELECT id, BuyerName,BuyerEmail,TransactionID,DateTime FROM `order` 
WHERE YEAR(DateTime)= $Year AND MONTH(DateTime) = $Month LIMIT $start, $per_page";