function getPage($table, $order = "id", $ascdesc, $start = 0, $limit) { $db = Loader::$database; $page = $start * $limit; $sql = "SELECT *\n FROM {$table}\n ORDER BY {$order}\n {$ascdesc}\n LIMIT {$page}, {$limit}"; $stmt = $db->connection->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); $dataObjects = array(); foreach ($result as $results) { array_push($dataObjects, DataObject::getInstance($results)); } return $result ? $dataObjects : false; }
/** * @see IModel::fetchAll() */ public function fetchAll($query, $params = NULL) { if (DB) { if (DEBUG_MODE) { $this->db->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } $stmt = $this->db->connection->prepare($query); $stmt->execute($params); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); $stmt->closeCursor(); $error = $this->db->connection->errorInfo(); if (DEBUG_MODE) { if ($error[0] != "00000") { die(print_r($this->db->connection->errorInfo())); } } $dataObjects = array(); foreach ($results as $result) { array_push($dataObjects, DataObject::getInstance($result)); } //Send all data objects in an array return $results ? $dataObjects : false; } }