- Paginating Eloquent Results
- Displaying Pagination Results
- Paginator Instance Methods
- Customizing the Pagination Links View

Laravel frammework has a paginator system integrated with the query builder and Eloquent ORM, and provides an easy-to-use pagination system of database results.

Paginating Query Builder Results

The simplest way to paginate database results is by using the paginate() method on the query builder or an Eloquent query.
The paginate() method takes one argument: the number of items you would like displayed "per page". Then, it automatically sets the proper limit and offset based on the current page.
The current page with paginating results is detected by the value of the query string argument on the HTTP request, which is automatically inserted into pagination links.

- Example of a controller that displays 20 items per page:
namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;

class PagesController extends Controller{
  //Shows paginated results
  //@return a view
  public function index(){
    $pages = DB::table('table_name')->paginate(20);

    return view('pages.index', ['pages'=>$pages]);
- You may call paginate() after setting other parameters on the query, such as where() clauses or DB:raw().
$pages = DB::table('table_name')->where('visits', '>', 100)->paginate(20);

$pages = DB::table('table_name')->select(DB::raw('*, DATE_FORMAT(dtreg, "%Y-%m-%d") as dtreg'))->paginate(20);

Paginating Eloquent Results

You may also paginate Eloquent queries. The syntax is nearly identical to paginating query builder results:
$users = App\User::paginate(20);

$users = User::where('votes', '>', 100)->paginate(20);

Displaying Pagination Results

The result set with data returned by the paginate() method may be looped as an array, (for example with foreach()).
To display the automatically created pagination links, use the $pages->links() method (Here, $pages is the object returned by the paginate() method).
You may display the results and render the page links using Blade template:
<div class="container">
@foreach($pages as $page)
  {{ $page->id }} - {{ $page->title }}

{{ $pages->links() }}
- The $pages->links() method returns a <ul> list with pagination links, compatible with the Bootstrap CSS framework.

simplePaginate() method

If you only need to display simple "Next" and "Previous" links in your pagination view (without links for each page number), you may use the simplePaginate() method to perform a more efficient query.
//with query builder
$users = DB::table('users')->simplePaginate(20);
$users = DB::table('users')->where('votes', '>', 100)->simplePaginate(20);

//with Eloquent
$users = User::simplePaginate(20);
$users = User::where('votes', '>', 100)->simplePaginate(20);

Customizing the Paginator URI

If you want the paginator to generate links like: //example.com/custom/url?page=N, use the withPath() method, with the "custom/url" string as argument.
Route::get('pages', function(){
  $pages = DB::table('table_name')->paginate(20);

- Then, use the {{ $pages->links() }} in your view.

To append strings to each pagination link, use the appends() method.
- For example, to append "sort=votes" to each pagination link, you may use the following code:
{{ $pages->appends(['sort' => 'votes'])->links() }}
If you wish to append a "hash fragment" to the paginator's URLs, you may use the fragment() method.
- For example, to append '#bip' to the end of each pagination link, use the following code:
{{ $pages->fragment('bip')->links() }}

Paginator Instance Methods

Each paginator instance (returned by the paginate() method) provides additional pagination informations via the following methods:

Pagination results object as JSON

To return the results of the paginate() method in JSON format, you can use the toJson() method:
public function index(){
  $pages = DB::table('table_name')->paginate(15);

  return $pages->toJson();
The JSON from the paginator will include meta information such as total, current_page, last_page, and more.
The actual result objects will be available via the "data" key in the JSON array.
- The above code will return a JSON like this:
  "total": 50,
  "per_page": 15,
  "current_page": 1,
  "last_page": 4,
  "next_page_url": "http://coursesweb.net?page=2",
  "prev_page_url": null,
  "from": 1,
  "to": 15,
      // Result Object of first item
      // Result Object of second item

Customizing the Pagination Links View

By default, the returned HTML code with pagination links are compatible with the Bootstrap CSS framework.
To define your own HTML code for these links, create a view file: resources/views/pagination/default.blade.php with custom pagination code, and pass the view name ('pagination.default') as the first argument to the links() method.
- For example, this is the default Laravel pagination view:
  <ul class="pagination">
    {{-- Previous Page Link --}}
      <li class="disabled"><span>&laquo;</span></li>
      <li><a href="{{ $paginator->previousPageUrl() }}" rel="prev">&laquo;</a></li>

    {{-- Pagination Elements --}}
    @foreach($elements as $element)
      {{-- "Three Dots" Separator --}}
        <li class="disabled"><span>{{ $element }}</span></li>

      {{-- Array Of Links --}}
        @foreach($element as $page => $url)
          @if($page == $paginator->currentPage())
            <li class="active"><span>{{ $page }}</span></li>
            <li><a href="{{ $url }}">{{ $page }}</a></li>

    {{-- Next Page Link --}}
      <li><a href="{{ $paginator->nextPageUrl() }}" rel="next">&raquo;</a></li>
      <li class="disabled"><span>&raquo;</span></li>
- Create a php file: resources/views/pagination/default.blade.php, and copy the code above in that file. Modify the "pagination/default.blade.php" however you want.
- Then, display the pagination links using this code:
You may also pass data to the pagination view:
{{$results->links('pagination.default', ['name'=>$value])}}
Another way to customize the pagination views is by exporting them to resources/views/vendor/ directory using the vendor:publish command:
php artisan vendor:publish --tag=laravel-pagination
This command will place the views in the "resources/views/vendor/pagination/" directory. Then, edit the "default.blade.php" file to modify the pagination HTML.
- The "simple-default.blade.php" file is for pagination links returned by the simplePaginate() method.

- Documentation: Laravel - Database: Pagination

Daily Test with Code Example

Which tag is used to add definition lists into a <dl> element?
<dt> <dd> <li>
  <dd> - Hyper Text Markup Language</dd>
  <dd> - Language for web pages</dd>
Which CSS property can hide an element on page, letting an empty space in its place?
display position visibility
#id {
  visibility: hidden;
Click on the event which is triggered when the mouse clicks on an object.
onclick onmouseover onfocus
document.getElementById("id").onclick = function(){
Indicate the PHP variable that contains the contents of both $_GET, $_POST, and $_COOKIE arrays.
if(isset($_REQUEST["id"])) {
  echo $_REQUEST["id"];
Laravel - MySQL Query Builder: Database Pagination

Last accessed pages

  1. Bubbles3 (34780)
  2. Penalty Fever (443)
  3. Zuma Deluxe (33019)
  4. Sport Games (4720)
  5. Number Lines (3985)

Popular pages this month

  1. Bubbles3 (3058)
  2. Butterfly Kyodai (2670)
  3. Zuma Deluxe (1976)
  4. Qwop (1247)
  5. Backgammon (1166)