public function getAll($sql, $pageCondition = false) { if (is_array($pageCondition)) { $pageCondition['page'] = ($page = functions::uint($pageCondition['page'])) ? $page : 1; $pageCondition['pagesize'] = ($pagesize = functions::uint($pageCondition['pagesize'])) ? $pagesize : 20; $resource = odb::db()->getAll($sql); $rows = count($resource); $pageInfo = functions::pageInfo($rows, $pageCondition['pagesize'], $pageCondition['page']); } $startRow = ($pageCondition['page'] - 1) * $pageCondition['pagesize']; $sql = is_array($pageCondition) ? $sql . " LIMIT {$startRow}, {$pageCondition['pagesize']}" : $sql; $list = odb::db()->getAll($sql, MYSQL_ASSOC); if (is_array($pageCondition)) { $response = array('list' => $list, 'pageInfo' => $pageInfo); return $response; } return $list; }
public function findAll($noPrint = true) { extract(self::$_rcdata); $sql = "SELECT {$field} FROM {$table} {$join} {$where} {$order} {$limit}"; if (!$noPrint) { echo $sql; exit; } self::$_rcdata['lastsql'] = $sql; $list = $this->getAll($sql, MYSQL_ASSOC); if (self::$_rcdata['page'] && !empty($list)) { $sql = "SELECT COUNT(*) AS count FROM {$table} {$join} {$where} {$order}"; $rows = $this->getOne($sql, MYSQL_ASSOC); $rows = $rows['count']; $list = array('aList' => $list, 'pageInfo' => functions::pageInfo($rows, self::$_rcdata['limit_get']['pagesize'], self::$_rcdata['limit_get']['page'])); } $this->__freeMemory(); return $list; }