SERVER-SIDE PAGINATION LOGIC

SQL SERVER-SIDE PAGINATION
==========================

```php
    $realOffset = 0;
    
    if(!is_null($limit) && $offset > 0) {
        $realOffset = $offset * $limit;
    }
    
    if($offset < 0) {
        $realOffset = 0;
    }
    
    if(!is_null($limit))
        $CI->db->limit($limit, $realOffset);
```    


SERVER-SIDE PAGINATION LOGIC FOR ELASTIC SEARCH
===============================================
```
if(page > 1)
    realOffset = (page * limit) - limit; 

- limit is the same as size or total number of records per page that I want
- page is the page number e.g. 1,2,3,4...
- realOffset is the actual value to pass to the search API as the from key



```