public function myreplyAction()
{
$page = $this->getRequest()->getParam('page');
$account = $_COOKIE["account"];
$usertable = new UserModel();
$db1 = $usertable->getAdapter();
$answertable = new AnswerModel();
$db3 = $answertable->getAdapter();
//查找当前用户ID
$result = $usertable->fetchRow($db1->quoteInto('email = ?', $account))->toArray();
$uid = $result['id'];
$num = $db3->query('SELECT COUNT(*) as num FROM answer,User WHERE answer.userid = User.id and User.id =? order by time desc', $uid)->fetchAll()[0][num];
$pages = ceil($num / 3);
if ($page == "") {
$page = 0;
}
if ($page < 3) {
if ($pages > 3) {
$set = array(1, 2, 3, 4);
} else {
$set = array();
for ($i = 1; $i <= $pages; $i++) {
$set[] = $i;
}
}
} else {
if ($page >= 3) {
if ($page + 3 <= $pages) {
$set = array($page, $page + 1, $page + 2, $page + 3);
} else {
$set = array();
for ($i = $page; $i <= $pages; $i++) {
$set[] = $i;
}
}
}
}
$count = 6;
$offset = $page * 6;
$select = $db3->select();
$select->from('answer', '*');
$select->join('question', 'answer.questionid=question.id', '*');
$select->where('answer.userid=?', 7)->limit($count, $offset);
$sql = $select->__toString();
$questions = $db3->fetchAll($sql);
// print_r($questions);
/*
$where = $db3->quoteInto('userid = ?', 7);
$order = 'begin by time desc';
$count = 6;
$offset =$page*6;
$questions = $answertable->fetchAll($where, $order, $count, $offset)->toArray();
*/
$this->view->results = $questions;
$this->view->user = $result;
$this->view->page = $page;
$this->view->count = $set;
}
