Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 关于分页及URL的请问

关于分页及URL的请问

WBOY
Release： 2016-06-13 13:29:12
Original
734 people have browsed it

关于分页及URL的请教
现在遇到的一个关于分页传值的问题，sql语句做了限制条件 $sql="select * from record where searchtime between '$date1' and '$date2'";
当提交这个表单后，刚搜索时结果是正确的，但是进行翻页时就会变为 $sql="select * from record"的第二页

通过在网上查询，得知需要做url传值? 这个不是很明白，能不能在我的这个源码下 详细讲下这方面的知识啊?

源代码如下：

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->


<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>搜索页面</title>
Copy after login
'$date1'"); } else if(!empty($date2)){ $result=mysql_query("select * from record where searchtime '$date1'"; } else if($date2 != ""){ $sql="select * from record where searchtime '; $key.="$page/$pages"; //第几页，共几页 if($page!=1){ $key.="第一页";//第一页 $key.="上一页"; //上一页 } else{ $key.="第一页";//第一页 $key.="上一页";//上一页 } if($pages>$page_len){ //如果当前页小于等于左偏移 if($page=$pages+1){ $init = $pages-$page_len+1; } else{ //左右偏移都存在时的计算 $init = $page-$pageoffset; $max_p =$page+$pageoffset; } } } for($i=$init;$i'.$i.''; } else{ $key.="".$i.""; } } if($page!=$pages){ $key.="下一页"; //下一页 $key.="最后一页"; //最后一页 } else{ $key.="下一页"; //下一页 $key.="最后一页";//最后一页 } $key.=''; ?>
登记 NO. 用户号码 地址 行动 到达时间 出发时间 距离 邮件 接到邮件用时 误发邮件 发信邮箱 机器


















到
Related labels：
bgcolor gt lt page quot
source：php.cn
Previous article： _autoload函数加载的文件夹多，网站流量又大，那么对速度影响大么,该怎么解决 Next article： 关于zend studio的一个有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
How to trigger render (with filter and pagination) on sort method in React? Here is my Sort.js style component: <SortWrapper><SortText>SortBy</SortText...
From 2024-04-06 21:28:37
0
1
2257
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template