php分页？刷新

Question

或者：我在查询(b.php）中同时实现分页，问题是：我按下一页的时候，b.php中的$query,和传进来的查询条件都为空？还有表头内容也不能输出？

Answer 1

(productquery.php)部分代码
<script>
function gettable(callback,pos)
{
productkey=document.getElementById("productkey").value;
StartDate=document.getElementById("StartDate").value;
EndDate=document.getElementById("EndDate").value;
//alter(productkey);
 jQuery.post("table.php",
{pos:pos,productkey:productkey,StartDate:StartDate,EndDate:EndDate},
function (data){
callback(data)
}
);
} function callback_blur( data )
{
document.getElementById("kk").innerHTML=data
}
</script>
 <div id="menuContainerB" > <form action="" method="post" >
    <table border="0" bgcolor="#CCCCCC" align="center">
<tr align="center">
         <td>料號： </td>
            <td> <input type="text" name="productkey" align="left" size="10" id="productkey"> </td>
<td>請輸入查詢時間： </td>
            <td><input type="text" name="StartDate" size="15" id="StartDate"></td>
            <td>&nbsp; to  &nbsp; </td>
            <td> <input type="text" name="EndDate" size="15" id="EndDate"> </td>
            <td colspan="2"> <input value="查詢" type="button" id="query" onclick="gettable(callback_blur,1)"/> 
            </td>
            </tr>
    </table> </form>
       
      <div  id="kk"></div>
  
<?php
require_once('page.php');
?>

Answer 2

<table.php >代码
<?php
require_once('inc.php');
//require_once('pagefy.php');
session_start();
$pos=$_POST["pos"];
$productkey=$_POST["productkey"];
$StartDate=$_POST["StartDate"];
$EndDate=$_POST["EndDate"];
$productkey=trim($productkey);
$_SESSION['productkey']=$productkey;
$_SESSION['StartDate']=$StartDate;
$_SESSION['EndDate']=$EndDate;

$page=isset($_GET['page'])?intval($_GET['page']):1; //獲取page的值
//$page=$_POST["fenye"];
$page_size=20;
$query="SELECT p.ProductKey,p.Name,b.OutStock,b.Department,b.ToStock,b.Inv_Id,b.`Date`,b.nature,
b.Check_,b.Warehouse, b.Unit FROM  products AS p ,st2009 AS b 
WHERE p.ProductKey = b.ProductKey  and  (b.`date` between '".$StartDate."' and '".$EndDate."') 
and p.productkey=".$productkey;$result=$db->query($query);
$total=mysql_num_rows($result); //總紀錄數
$url='ProductQuery.php';//本頁url
$page_num=ceil($total/$page_size);//總頁數，也是最後一頁
$page=min($page,$page_num);//獲取首頁
$prepg=$page-1;//上一頁
$nextpg=($page==$page_num?0:$page+1);//下一頁
$offset=($page-1)*$page_size;
$pagenav="显示第 <B>".($total?($offset+1):0)."</B>-<B>".min($offset+$page_size,$total)."</B> 条记录，共 $total 条记录 ";
$pagenav.=" <a href=$url?page=1;>首页</a> ";
if($prepg) $pagenav.=" <a href=$url?page=$prepg>前页</a> "; else $pagenav.=" 前页 ";
if($nextpg) $pagenav.=" <a href=$url?page=$nextpg>后页</a> "; else $pagenav.=" 后页 ";
$pagenav.=" <a href=$url?page=$page_num>尾页</a> ";
$pagenav.="共 $page_num 页"; //假如传入的页数参数大于总页数，则显示错误信息
if($page>$page_num)
{
        echo "Error : Can Not Found The page ".$page;
        exit;
}
echo '<br/><hr color="red">';
echo '<table width="100%" border="1" align="center" bground="#ccccff">';
      echo' <tr><th scope="col" bgcolor="#CCCCCC" width="8%" align="center"><strong>料號</strong></th>';
     echo' <th scope="col" bgcolor="#CCCCCC" width="12%" align="center"><strong>品名規格</strong></th>';
      echo' <th scope="col" bgcolor="#CCCCCC" width="8%" align="center"><strong>單號 </strong></th>';
      echo '<th scope="col" bgcolor="#CCCCCC" width="8%" align="center"><strong>部門 </strong></th>';
        echo'<th  scope="col" bgcolor="#CCCCCC" width="9%" align="center"><strong >出庫 </strong></th>';
        echo' <th scope="col" bgcolor="#CCCCCC" width="9%" align="center"><strong >入庫 </strong></th>';
        echo' <th scope="col" bgcolor="#CCCCCC" width="8%" align="center"><strong>單位 </strong></th>';
        echo'<th scope="col" bgcolor="#CCCCCC" width="8%" align="center"><strong >摘要 </strong></th>';
        echo'<th scope="col" bgcolor="#CCCCCC" width="10%" align="center"><strong >倉位 </strong></th>';
        echo'<th scope="col" bgcolor="#CCCCCC" width="8%" align="center"><strong >核准</strong></th>';
        echo'<th scope="col" bgcolor="#CCCCCC" width="12%" align="center"><strong>時間</strong></th> </tr>';

$num=($page_num>1?$page_size:$total);
for($i=0;$i<$num;$i++)
{
$row=mysql_fetch_array($result,MYSQL_ASSOC);
echo '<tr><td >';
echo ($row['ProductKey']);
echo '</td><td>';
echo ($row['Name']);
echo '</td><td>';
echo ($row['Inv_Id']);
echo '</td><td>';
echo ($row['Department']);
echo '</td><td>';
echo ($row['ToStock']);
echo '</td><td>';
echo ($row['OutStock']);
echo '</td><td>';
echo ($row['Unit']);
echo '</td><td>';
echo ($row['nature']);
echo '</td><td>';
echo ($row['Warehouse']);
echo '</td><td>';
echo ($row['Check_']);
echo '</td><td>';
echo ($row['Date']);
echo '</td></tr>';
}
echo '</table><br/>';
if($page_num>1) echo'<div>'.$pagenav.'</div>';