public function show_page($sql, $page = 1, $page_size = 10, $cfg = array(), $count_sql = '') { $count_sql = $count_sql == '' ? 'SELECT count(*) ' : $count_sql; $from_index = strpos($sql, 'FROM'); $c_sql = $count_sql . substr($sql, $from_index); $data = array(); $num = $this->db->getOne($c_sql); if ($num > 0) { if (strtolower(GROUP_NAME) == 'home') { $cfg['rewrite'] = REWRITE; } $page = new Page($page, $num, $page_size, $cfg); if (strtolower(GROUP_NAME) == 'home' && DEFAULT_LANG == 'en_us') { $page->set_lang(array('first_page' => 'First', 'next_page' => 'Next', 'pre_page' => 'Pre', 'last_page' => 'Last')); } $page->create_arr(); $sql = $sql . ' LIMIT ' . $page->select_from . $page->select_limit; $data['result'] = $this->db->getAll($sql); $data['page'] = $page->html_page(); } return $data; }