public function actionLoadMoreTest() { $db = Yii::app()->db; // $comm = $db->createCommand() // ->select('*') // ->from('pls_user_test') // ->group('course_id') // // ->having('COUNT(DISTINCT course_id)') // // ->leftJoin('pls_course t2','t.course_id= t2.id') // ->where('status > 0'); // $data_user_test = $comm->queryAll(); // var_dump($data_user_test); // $comm = $db->createCommand(); // ->select('*') // ->from('pls_user_test') // // ->group('course_id') // // ->having('COUNT(DISTINCT course_id)') // // ->leftJoin('pls_course t2','t.course_id= t2.id') // ->where('status > 0'); // $tesst = $comm->queryAll(); // var_dump($data_user_test); // $data_user_test = json_decode(json_encode($data_user_test)); $data = array(); if (isset($_POST["page"])) { $page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH); } else { $page_number = 0; } //throw HTTP error if page number is not valid if (!is_numeric($page_number)) { header('HTTP/1.1 500 Invalid page number!'); $this->redirect('/'); } //get current starting point of records $position = $page_number * Params::$coursePerPage; // vị trí = số trang* số bản ghi của 1 trang $testuser = new WUserTest(); $results = $testuser->getUserTestCourse($position, Params::$coursePerPage); $data = $this->renderPartial('_loadmore', array('testuser' => $results), true); echo $data; }