public function refresh() { $commentTable = M('table2comment'); $count = $commentTable->count(); $page = new AjaxPage($count, 10, 'refresh'); $pageData = $page->show(); $commentData = $commentTable->limit($page->firstRow, $page->listRows)->order('commenttime desc')->select(); foreach ($commentData as $rowNum => $rowData) { date_default_timezone_set('PRC'); $commentData[$rowNum]['commenttime'] = date("Y年m月d日 H:i:s", $commentData[$rowNum]['commenttime']); $condition['username'] = $commentData[$rowNum]['username']; $userData = M('table2user')->field('imgnum,webpage')->where($condition)->select(); $commentData[$rowNum]['imgnum'] = $userData[0]['imgnum']; $commentData[$rowNum]['webpage'] = $userData[0]['webpage']; } $commentData['pagedata'] = $pageData; $this->ajaxReturn($commentData, 'json'); }
/** * 新闻 * */ public function news() { header("Content-type:text/html;charset=utf-8"); if (!access(C('FM_content'))) { $this->error(C('access_error')); return; } $id = $_GET['id']; $Column = M('Column'); $column = $Column->where('id=' . $id)->find(); $Content = M('Content'); // $content = $Content->where('columnid='.$id)->select(); $count = $content = $Content->where('columnid=' . $id)->count(); $limitRows = 5; // 设置每页记录数 $p = new AjaxPage($count, $limitRows, "news"); //第三个参数是你需要调用换页的ajax函数名 $limit_value = $p->firstRow . "," . $p->listRows; $data = $Content->where('columnid=' . $id)->order('addtime desc')->limit($limit_value)->select(); // 查询数据 $page = $p->show(); // 产生分页信息,AJAX的连接在此处生成 if (IS_AJAX) { $this->assign("content", $data); // 赋值数据集 $this->assign('page', $page); // 赋值分页输出 $html = $this->display('Content:newsAjax'); // var_dump($html); // echo "".$html; // $this->ajaxReturn("heloo"); // exit; return; } $this->assign("column", $column); $this->assign("content", $data); $this->assign('page', $page); // 赋值分页输出 $this->display(); }