Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php+mysql 查询结果分页显示解决方案

php+mysql 查询结果分页显示解决方案

WBOY
Release： 2016-06-13 10:07:45
Original
1603 people have browsed it

php+mysql 查询结果分页显示
在a.html中，由用户填写查询表单数据，表单内容很多，以POST方式传递。
b.php接受来自a.html的表单数据，并根据表单数据查询mysql数据库。
由于查询结果可能很多，我想实现分页显示，于是就先查了总数，然后调用c.php返回页面导航和链接，然后利用limit 来实现分页显示，可是经过实践，发现第一页是可以正确显示，点击下一页或者其他页的时候，就会没有任何信息，后来发现原因是点击第二页的时候，其实是调用了

HTML code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--><a href="b.php?page=2"></a>
Copy after login
，这样原来的POST表单数据就丢失了，只传递了一个GET方式的page值，因此也就什么也不显示了，我如何才能保证在没有新的表单数据提交进来前，保持原有的表单数据。
  其实说白了，就像现在的google和百度搜索引擎一样，提交查询后，不会因为翻页而丢失原来用户提交数据的丢失，请教各位大虾，有没有什么比较好的办法可以实现这一点呢？

------解决方案--------------------
1.用get方式提交表单
2.把用post方式提交的数据保存到session
------解决方案--------------------
你试一下CSDN的高级搜索：
http://so.csdn.net/advanced_search.aspx
这个就是用get方式传数据的
没啥不好的
Related labels：
get html mysql php post
source：php.cn
Previous article：html post信息出现&符号如何转义 Next article：PHP怎么用正则表达式匹配圆括号
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
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
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