public function getPaginated($limit = 1, $fields = null, $sqlQuery = false)
    {
        $sql = $this->buildQuery('select', $fields, ['count'=>null, 'field'=>'num']);
        $result = $this->executeQuery($sql);
        $row = $result->fetch_array(MYSQLI_ASSOC);
        $total = $row['num'];
        if($total == 0 && $sqlQuery == false) {
            return [];
        }
        $this->pagination->initialize($limit, $total);
        return $this->limit($limit, $this->pagination->getStartPoint())->getAll($fields, $sqlQuery);
    }
public function getPaginated($limit = 1, $fields = null, $sqlQuery = false)
    {
        $sql = $this->buildQuery('select', $fields, ['count'=>null, 'field'=>'num']);
        $result = $this->executeQuery($sql);
        $row = $result->fetch_array(MYSQLI_ASSOC);
        $total = $row['num'];
        if($total == 0 && $sqlQuery == false) {
            return [];
        }
        $this->pagination->initialize($limit, $total);
        return $this->limit($limit, $this->pagination->getStartPoint())->getAll($fields, $sqlQuery);
    }
public function getPaginated ( $ limit = 1 , $ fields = null , $ sqlQuery = false ) { $ sql = $ this -> buildQuery ( 'select' , $ fields , [ 'count' => null , 'field' => 'num' ] ) ; $ result = $ this -> executeQuery ( $ sql ) ; $ row = $ result -> fetch_array ( MYSQLI_ASSOC ) ; $ total = $ row [ 'num' ] ; if ( $ total == 0 && $ sqlQuery == false ) { return [ ] ; } $ this -> pagination -> initialize ( $ limit , $ total ) ; return $ this -> limit ( $ limit , $ this -> pagination -> getStartPoint ( ) ) -> getAll ( $ fields , $ sqlQuery ) ; }
Get paginated fields from table

@param  array|null  $limit
@param  string|null  $sqlQuery
@rturn  array
Get paginated fields from table