PHP Page::create_arr Examples

Example #1

File: Model.php Project: gzwyufei/sr

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