本文整理汇总了PHP中Question::findAll方法的典型用法代码示例。如果您正苦于以下问题:PHP Question::findAll方法的具体用法?PHP Question::findAll怎么用?PHP Question::findAll使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Question
的用法示例。
在下文中一共展示了Question::findAll方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: actionIndex
/**
* 首页
*/
public function actionIndex()
{
$bagecmsQuestionModel = new Question();
$bagecmsQuestionCriteria = new CDbCriteria();
$bagecmsQuestionCriteria->condition = 'status_is=:status';
$bagecmsQuestionCriteria->params = array('status' => 'Y');
$bagecmsQuestionCriteria->order = 't.id DESC';
$bagecmsQuestionCount = $bagecmsQuestionModel->count($bagecmsQuestionCriteria);
$bagecmsQuestionPages = new CPagination($bagecmsQuestionCount);
$bagecmsQuestionPages->pageSize = 10;
$bagecmsQuestionPageParams = XUtils::buildCondition($_GET, array());
$bagecmsQuestionPageParams['#'] = 'list';
$bagecmsQuestionPages->params = is_array($bagecmsQuestionPageParams) ? $bagecmsQuestionPageParams : array();
$bagecmsQuestionCriteria->limit = $bagecmsQuestionPages->pageSize;
$bagecmsQuestionCriteria->offset = $bagecmsQuestionPages->currentPage * $bagecmsQuestionPages->pageSize;
$bagecmsQuestionList = $bagecmsQuestionModel->findAll($bagecmsQuestionCriteria);
$this->_seoTitle = '留言咨询 - ' . $this->_conf['site_name'];
$this->render('index', array('bagecmsQuestionList' => $bagecmsQuestionList, 'pages' => $bagecmsQuestionPages));
}
示例2: run
public function run()
{
$model = new Question();
//条件
$criteria = new CDbCriteria();
$realname = trim(Yii::app()->request->getParam('realname'));
$question = trim(Yii::app()->request->getParam('question'));
$question && $criteria->addSearchCondition('question', $question);
$realname && $criteria->addSearchCondition('realname', $realname);
$criteria->order = 't.id ASC';
$count = $model->count($criteria);
//分页
$pages = new CPagination($count);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
//查询
$result = $model->findAll($criteria);
$this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages));
}
示例3: actionIndex
/**
* 首页
*/
public function actionIndex()
{
$model = new Question();
$criteria = new CDbCriteria();
$condition = '1';
$realname = trim($this->_request->getParam('realname'));
$question = trim($this->_request->getParam('question'));
$question && ($condition .= ' AND question LIKE \'%' . $question . '%\'');
$realname && ($condition .= ' AND realname LIKE \'%' . $realname . '%\'');
$criteria->condition = $condition;
$criteria->order = 't.id DESC';
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 15;
$pageParams = $this->buildCondition($_GET, array('site_name'));
$pages->params = is_array($pageParams) ? $pageParams : array();
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
$this->render('index', array('datalist' => $result, 'pagebar' => $pages));
}