public function paginate($RowsPerPage)
{
// count data
$sql = "select count(*) as nbRows from " . $this->name;
$var = Database::read($sql);
$this->RowsPerPage = $RowsPerPage;
$this->nbRows = $var[0]['nbRows'];
$this->nbPages = ceil($this->nbRows / $RowsPerPage);
//if isset get
$this->CurrentPage = 1;
if (isset($_GET[Config::get('view.pagination_param')]) && !empty($_GET[Config::get('view.pagination_param')])) {
if ($_GET[Config::get('view.pagination_param')] > 0 && $_GET[Config::get('view.pagination_param')] <= $this->nbPages) {
$this->CurrentPage = Res::get(Config::get('view.pagination_param'));
}
}
//get Data
$r = array();
$sql = "select * from " . $this->name . " Limit " . ($this->CurrentPage - 1) * $this->RowsPerPage . ",{$this->RowsPerPage}";
$this->data = Database::read($sql);
//
return $this;
}
public function paginate($num)
{
//
// count data
$sql = "select count(*) as nbRows from " . $this->table;
$var = Database::read($sql);
$nbRows = $var[0]['nbRows'];
$nbPages = ceil($nbRows / $num);
//
//if isset get
$page = 1;
if (isset($_GET[Config::get('view.pagination_param')]) && !empty($_GET[Config::get('view.pagination_param')])) {
if ($_GET[Config::get('view.pagination_param')] > 0 && $_GET[Config::get('view.pagination_param')] <= $nbPages) {
$page = Res::get(Config::get('view.pagination_param'));
}
}
//
$r = array();
//
$sql = "select * from " . $this->table . " Limit " . ($page - 1) * $num . ",{$num}";
$var = Database::read($sql);
foreach ($var as $key => $value) {
//echo $value[0];
$o = new self($value[0], $this->table);
//print_r(get_object_vars($o));
array_push($r, $o);
}
//
// call the data array
$g = new DataArray($r, true, $nbRows, $num, $page);
return $g;
}
