Level 2
what 's problem in my question ??
Aug 24, 2015
7
Level 2
pagination with union in Laravel
i have problem when try pagination tow union table
$page = Input::get('page', 1);
$paginate = 10;
$members = DB::table("members")
->select("id", "first_name", "last_name", "email", "created_at")
->where("site_id", $id);
$users = DB::table("users")
->select("id", "first_name", "last_name", "email", "created_at")
->where("site_id", $id)
->union($members)
->get();
$slice = array_slice($users, $paginate * ($page - 1), $paginate);
$data = Paginator::make($slice, count($users), $paginate);
return View::make('your_view_name',compact('data'));
this error appear
Class Illuminate\Support\Facades\Paginator does not exist
Level 41
Are you using Laravel 5? I don't think the make() function exists anymore. Check out the docs on manually creating a paginator:
http://laravel.com/docs/master/pagination#manually-creating-a-paginator
Level 2
@thomaskim yes use laravel 5.1 i want example
Level 41
@nazar1987 First, choose between Paginator and LengthAwarePaginator. Think of Paginator as simplePaginate and LengthAwarePaginator as regular paginate.
For Paginator, you can do something as...
// $slice = the sliced array of results. You used the variable $slice for this in your example
// $paginator = the number of results on that page. You used the variable $paginator in your example
$data = new Paginator($slice, $paginator);
I'd suggest reading the docs and taking a look at the source code to understand them better.
Level 1
Sí se puede
Ya lo probé y funciona bien
$q1 = Model::createByMe(); // some condition
$q2 = Model::createByMyFriend(); // another condition
$q2->union($q1);
$querySql = $q2->toSql();
$query = Model::from(DB::raw("($querySql) as a"))->select('a.*')->addBinding($q2->getBindings());
$paginated_data = $query->paginate();
Level 75
Please stop that slice nonsense.
https://laracasts.com/discuss/channels/guides/length-aware-paginator
Level 13
If you would like to get the user to paginate you can use as like below.
$user = User::oldest()->paginate(10);
Please or to participate in this conversation.