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();
}
