Paginating Query Builder Results
There are several ways to paginate items. The simplest is by using the paginate
method on the query builder or an Eloquent query. The paginate
method automatically takes care of setting the proper limit and offset
based on the current page being viewed by the user. By default, the
current page is detected by the value of the page
query string argument on the HTTP request. This value is automatically
detected by Laravel, and is also automatically inserted into links
generated by the paginator.
In this example, the only argument passed to the paginate
method is the number of items you would like displayed "per page". In this case, let's specify that we would like to display 15
items per page:
<?php
namespace App\Http\Controllers;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;
class UserController extends Controller
{
/**
* Show all of the users for the application.
*
* @return Response
*/
public function index()
{
$users = DB::table('users')->paginate(15);
return view('user.index', ['users' => $users]);
}
}