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