PHP查询提交给自身展示结果并分页为何点击下一页显示全部内容
Jun 23, 2016 pm 01:28 PM 背景:在一ldt.php页面中有同一个form,两个按钮分别在提交的时候给到两个不同页面。一个按钮是插入数据库,一个按钮是查询并提交给自己在本页中展示出结果内容,有分页函数,提交后跳转过来的第一页是正常显示查询条件对应的结果的,但是点击下一页等就会显示数据库全部结果。我觉得应该是分页的时候没有带上参数,但是不知道怎么带,把部分源代码贴上来,请大神修改一下。
1、js提交不同页面:
<script></script>
<script> <br /> function submitit1() <br /> //交由程序1处理 <br /> { <br /> document.myForm.action = "其他.php" <br /> document.myForm.submit(); <br /> } <br /> function submitit2() <br /> //交由本页处理 <br /> { <br /> document.myForm.action = "ldt.php" <br /> document.myForm.submit(); <br /> <br /> } <br /> </script>
2、分页函数:
$page = $_GET["page"];
function Page($rows,$page_size){
global $page,$select_from,$select_limit,$pagenav;
$page_count = ceil($rows/$page_size);
if($page if($page >= $page_count) $page = $page_count;
$select_limit = $page_size;
$select_from = ($page - 1) * $page_size.',';
$pre_page = ($page == 1)? 1 : $page - 1;
$next_page= ($page == $page_count)? $page_count : $page + 1 ;
$pagenav .= "第 $page/$page_count 页 共 $rows 条记录 ";
$pagenav .= "首页 ";
$pagenav .= "前一页 ";
$pagenav .= "后一页 ";
$pagenav .= "末页";
$pagenav.=" 跳到
回复讨论(解决方案)
你贴出的两段代码,基本与解决问题无关
你只需要用某种方法保存下查询时的筛选条件就可以了
保存后赋给谁呢
include 'tof3/header.php'; $_SESSION['hcrdtbj']=$_GET['hcrdtbj'];
$hcrdtbj=$_SESSION['hcrdtbj'];
?>
nbsp;HTML>
<script></script>
<script> <br /> function submitit1() <br /> //交由程序1处理 <br /> { <br /> document.myForm.action = "hcoutinsert.php" <br /> document.myForm.submit(); <br /> } <br /> function submitit2() <br /> //交由程序2处理 <br /> { <br /> document.myForm.action = "ldt.php" <br /> document.myForm.submit(); <br /> <br /> } <br /> </script>
<script></script>
<script></script>
<script><!-- <br /> $(document).ready(function(){ <br /> _w_table_rowspan("#spdata",2); <br /> <br /> }); <br /> // --> <br /> </script>
$page = $_GET["page"];
function Page($rows,$page_size){
global $page,$select_from,$select_limit,$pagenav;
$page_count = ceil($rows/$page_size);
if($page if($page >= $page_count) $page = $page_count;
$select_limit = $page_size;
$select_from = ($page - 1) * $page_size.',';
$pre_page = ($page == 1)? 1 : $page - 1;
$next_page= ($page == $page_count)? $page_count : $page + 1 ;
$pagenav .= "第 $page/$page_count 页 共 $rows 条记录 ";
$pagenav .= "首页 ";
$pagenav .= "前一页 ";
$pagenav .= "后一页 ";
$pagenav .= "末页";
$pagenav.=" 跳到";
if($row['scene']=="VIP耗材"){
echo "";}
else{
echo "";}
echo "";
if($row['dtime'] ==$rowv['dtime'] || $row['dtime'] ==$rowp['dtime'] ) {
echo "";
}
else{
echo "";
}
}
echo "";
mysql_close($conn);
mysql_free_result($rst);
mysql_free_result($rstv);
mysql_free_result($rstp);
?>
用户名 | 归属 | 场景 | 类型 | 明细 | 领用数 | 原因 | 操作人 | 时间 | |
---|---|---|---|---|---|---|---|---|---|
{$row['customer']} | {$row['scene']} | {$row['purpose']} | {$row['catalogue']} | 的库存详情' style='color:white;'/a>{$row['hc']} | 的库存详情'/a>{$row['hc']} | {$row['number']} | {$row['reason']} | {$row['person']} | {$row['dtime']}![]() |
{$row['dtime']} | |||||||||
$pagenav |
1 |
|

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

11 Best PHP URL Shortener Scripts (Free and Premium)

Working with Flash Session Data in Laravel

Simplified HTTP Response Mocking in Laravel Tests

Build a React App With a Laravel Back End: Part 2, React

cURL in PHP: How to Use the PHP cURL Extension in REST APIs

12 Best PHP Chat Scripts on CodeCanyon

Announcement of 2025 PHP Situation Survey
