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