public static function getData($tableName, $page = 1, $page_size = 0, $where = null, $order = null, $select = null) { if (!$tableName) { return false; } $total = self::getCounts($tableName, $where); if (!$page_size) { $page_size = 30; } $total_page = ceil($total / $page_size); if ($page < 1) { $page = 1; } if ($page > $total_page) { $page = $total_page; } if ($page < 1) { $page = 1; } self::$_page = $page; self::$_page_siez = $page_size; self::$_total_page = $total_page; $count = ($page - 1) * $page_size; if (!$where) { $where = "id>0"; } if (!$order) { $order = " ORDER BY id DESC"; } else { $order = " ORDER BY " . $order; } if (!$select) { $select = '*'; } $options['condition'] = $where; $options['offset'] = $count; $options['size'] = $page_size; $options['order'] = $order; $options['select'] = $select; //DB::Debug(); $data = DB::LimitQuery($tableName, $options); self::$_data = $data; return $data; }