jqueryajaxphp+mysql无刷新分页详细实例_PHP教程
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了jqueryajaxphp+mysql无刷新分页详细实例_PHP教程,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含12594字,纯文字阅读大概需要18分钟。
内容图文
最近在接触jquery和ajax,当前项目也会用到分页,为了用户体验更好一些,就准备用无刷新分页,这个demo很适合新手学习查看,写的比较清晰,话不多说,直接上代码吧。首先是html页面,index.html,代码如下:
<span 1 <span <span DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" <span 2 <span <<span html <span xmlns<span ="http://www.w3.org/1999/xhtml" <span 3 <span <<span head <span 4 <span <<span meta <span http-equiv<span ="Content-Type"<span content<span ="text/html; charset=utf-8" <span 5 <span <<span titlephp+mysql+ajax+jquery分页<span </<span title <span 6 <span 7 <span <<span script <span type<span ="text/javascript"<span src<span ="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"</<span script <span 8 <span <<span script <span type<span ="text/javascript"<span src<span ="ajaxPager.js"</<span script <span 9 <span <<span style <span 10 <span #main<span { <span 11 <span width<span :<span 980px<span ; <span 12 <span margin<span :<span 0px auto<span ; <span 13 <span } <span 14 <span ul <span 15 <span { <span 16 <span list-style<span :<span none<span ; <span 17 <span margin<span :<span 0px<span ; <span 18 <span } <span 19 <span #list li<span { <span 20 <span width<span :<span 220px<span ; <span 21 <span height<span :<span 280px<span ; <span 22 <span float<span :<span left<span ; <span 23 <span margin-left<span :<span 10px<span ; <span 24 <span } <span 25 <span .pager .cur <span { <span 26 <span border-top-color<span :<span rgb(255, 255, 255)<span ; <span 27 <span border<span :<span 1px solid #fff<span ; <span 28 <span background<span :<span 0<span ; <span 29 <span font-weight<span :<span bold<span ; <span 30 <span color<span :<span #000<span ; <span 31 <span } <span 32 <span .pager a, .pager span <span { <span 33 <span margin-top<span :<span 5px<span ; <span 34 <span } <span 35 <span .pager a, .pager span <span { <span 36 <span background<span :<span none repeat scroll 0 0 #fff<span ; <span 37 <span border<span :<span 1px solid #e7ecf0<span ; <span 38 <span color<span :<span #0000cd<span ; <span 39 <span float<span :<span left<span ; <span 40 <span height<span :<span 22px<span ; <span 41 <span line-height<span :<span 22px<span ; <span 42 <span margin-right<span :<span 5px<span ; <span 43 <span overflow<span :<span hidden<span ; <span 44 <span text-align<span :<span center<span ; <span 45 <span text-decoration<span :<span none<span ; <span 46 <span width<span :<span auto<span ; <span 47 <span padding<span :<span 0 8px<span ; <span 48 <span } <span 49 <span .pager span <span { <span 50 <span background<span :<span none repeat scroll 0 0 #fff<span ; <span 51 <span border<span :<span 1px solid #e7ecf0<span ; <span 52 <span color<span :<span #0000cd<span ; <span 53 <span float<span :<span left<span ; <span 54 <span height<span :<span 22px<span ; <span 55 <span line-height<span :<span 22px<span ; <span 56 <span margin-right<span :<span 5px<span ; <span 57 <span overflow<span :<span hidden<span ; <span 58 <span text-align<span :<span center<span ; <span 59 <span text-decoration<span :<span none<span ; <span 60 <span width<span :<span auto<span ; <span 61 <span padding<span :<span 0 8px<span ; <span 62 <span } <span 63 <span .pager <span { <span 64 <span border-top<span :<span 0<span ; <span 65 <span padding<span :<span 12px 0 30px 15px<span ; <span 66 <span float<span :<span left<span ; <span 67 <span } <span 68 <span .clearfix <span { <span 69 <span display<span :<span block<span ; <span 70 <span } <span 71 <span .pager <span { <span 72 <span float<span :<span left<span ; <span 73 <span font-family<span :<span Arial<span ; <span 74 <span font-size<span :<span 13px<span ; <span 75 <span } <span 76 <span .clearfix <span { <span 77 <span zoom<span :<span 1<span ; <span 78 <span } <span 79 <span </<span style <span 80 <span 81 <span 82 <span </<span head <span 83 <span 84 <span <<span body <span 85 <span 86 <span 87 <span <<span div <span id<span ="main" <span 88 <span <<span div <span id<span ="pagecount"<span class<span ="pager clearfix"</<span div<<span div <span id<span ="loading"</<span div <span 89 <span <<span br <span 90 <span <<span br <span 91 <span <<span br <span 92 <span <<span br <span 93 <span <<span div <span id<span ="list" <span 94 <span <<span ul</<span ul <span 95 <span </<span div <span 96 <span </<span div <span 97 <span </<span body <span 98 <span </<span html
样式我随便写的,毕竟我样式写的很差,大家可以自己换样式的。
然后就是js代码了,ajaxPager.js,代码如下:
<span 1 <span var curPage = 1; <span //<span 当前页码 <span 2 <span var<span total,pageSize,totalPage; <span 3 <span //<span 获取数据 <span 4 <span function<span getData(page){ <span 5 <span $.ajax({ <span 6 type: 'POST'<span , <span 7 url: 'pages.php'<span , <span 8 data: {'pageNum':page-1<span }, <span 9 dataType:'json'<span , <span 10 beforeSend:<span function<span (){ <span 11 $("#loading").html(""<span ); <span 12 <span }, <span 13 success:<span function<span (json){ <span 14 $("#loading").html(""<span ); <span 15 $("#list ul"<span ).empty(); <span 16 total = json.total; <span //<span 总记录数 <span 17 pageSize = json.pageSize; <span //<span 每页显示条数 <span 18 curPage = page; <span //<span 当前页 <span 19 totalPage = json.totalPage; <span //<span 总页数 <span 20 <span var li = ""<span ; <span 21 <span var list =<span json.list; <span 22 $.each(list,<span function(index,array){ <span //<span 遍历json数据列 <span 23 li += "
https://www.gxlcms.com/"+array['title'].substring(0,10)+"
因为项目的需要,我这个页面页数显示只能显示几页,比如就这样 << < ... 5 6 7 ... > >>,要改显示的,就在ajaxPager.js里面改。
$.ajax({ 中url: 'pages.php',处理就在pages.php中处理。那么就来看看pages.php中的代码:
<span 1 ('connect.php'
= (['pageNum'
= ("select id from food" = ();
= 8;
= (/);
= * ['total'] = ['pageSize'] = ['totalPage'] = = ("select id,title,pic from food order by id asc limit ," (=( ['list'][] = 'id' => ['id'],
'title' => ['title'],
'pic' => ['pic'],
json_encode( ?>
上面当然还有数据库连接了啦,这个应该很简单吧,还是贴出来connect.php:
<span 1 ('connect.php'
= (['pageNum'
= ("select id from food" = ();
= 8;
= (/);
= * ['total'] = ['pageSize'] = ['totalPage'] = = ("select id,title,pic from food order by id asc limit ," (=( ['list'][] = 'id' => ['id'],
'title' => ['title'],
'pic' => ['pic'],
json_encode( ?>
然后就完成了,具体思路很清晰,点击页数的时候jquery获取rel中的页面值,传进去数据库获取相应数据展现在页面上。
然后还有数据库吧,我的表示这样的:
1 CREATE TABLE IF NOT EXISTS `food` ( 2 `id` int(11) NOT NULL AUTO_INCREMENT, 3 `title` varchar(100) NOT NULL, 4 `pic` varchar(255) NOT NULL, 5 PRIMARY KEY (`id`) 6 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
我这边有一个demo,然后大家可以下载看看。多多指教。
http://pan.baidu.com/share/link?shareid=1518322039&uk=67299903
http://www.bkjia.com/PHPjc/440223.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/440223.htmlTechArticle最近在接触jquery和ajax,当前项目也会用到分页,为了用户体验更好一些,就准备用无刷新分页,这个demo很适合新手学习查看,写的比较清...
内容总结
以上是互联网集市为您收集整理的jqueryajaxphp+mysql无刷新分页详细实例_PHP教程全部内容,希望文章能够帮你解决jqueryajaxphp+mysql无刷新分页详细实例_PHP教程所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。