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