php:
public function actionForumlist(){ $uid = $this->user_id; $page = I('page', 1) - 1; $size = 10; $offset = $page * $size; $limit = ' LIMIT ' . $offset . ',' . $size; $sql = "select f.*,s.user_picture,s.nick_name from dsc_forum AS f LEFT JOIN dsc_users AS s ON s.user_id = f.user_id WHERE f.user_id=".$uid." ORDER BY f.add_time desc" . $limit; $next = $this->db->getAll($sql); foreach ($next as $k=>$v){ $next[$k]['add_time']=date('Y-m-d H:i:s',$v['add_time']); } $sql = "select COUNT(*) from dsc_forum WHERE user_id =".$uid." ORDER BY add_time desc"; $count = $this->db->getOne($sql); $count ? $count : 0; exit(json_encode(array('info' => $next, 'uid' => $uid, 'totalPage' => ceil($count / $size)))); } public function actionForum() { $this->display(); }
html:
{include file="page_header"} <div class="con"> <!--圈列表1--> <section class="dis-team-list "> <div class="team-info"> <script id="j-product" type="text/html"> <%if totalPage > 0%> <%each info as key %> <a href="{url('user/index/forumdata',array('forum_id'=>key.forum_id))}"> <ul class="dis-box padding-all b-color-f"> <li class="box-flex"> <div class="com-adm-box pt-05"> <h4 style="color: #0c0c0c;">内容:<font color="#999" size="2.5px"><%key.content%></font></h4> <p><img src="<%if key.user_picture %><%key.user_picture%><%else%> {elixir('img/no_image.jpg')} <%/if%>" style="width: 1.7rem;border-radius: 100%;"> 用户名:<%key.nick_name%> <span style="float: right">时间:<%key.add_time%></span></p> </div> </li> </ul> </a> <%/each%> <%else%> <div class="no-div-message"> <i class="iconfont icon-biaoqingleiben"></i> <p>亲,此处没有东西~!</p> </div> <%/if%> </script> </div> </section> </div> <input type="hidden" name="user_id" value="{$next_id}"> <!--快捷导航--> {include file="no_search_nav"} <li> <a href="{url('drp/user/index')}"> <i class="iconfont icon-fenxiao"></i> <p>{$custom}中心</p> </a> </li> <li> <a href="{url('rank_list')}"> <i class="iconfont icon-shangchengxitongtubiaozitihuayuanwenjian41"></i> <p>{$custom}排行</p> </a> </li> {include file="float_nav_footer"} <script> var url="{url('user/index/forumlist')}"; var user_id = $("input[name=user_id]").val(); var infinite = $('.team-info').infinite({url: url, params:'user_id='+user_id, template: 'j-product'}); </script> </body> </html>