如何在laravel Eloquent中应用分页和偏移

Question

I am searching user with name and email and below is my body request

{
 "email": "shah",
 "name": "shah",
}

I want to apply pagination & offset in this api which will take two more parameters which offset and paginate which will search accordingly and my body request will be something like this:

{
 "email": "shah",
 "name": "shah",
 "offset": 1,
 "paginate": 1
}

My Code:

$pram = $request->name;
$email= $request->email;
$roleId= $request->role_id;

$results = User::where('email','like', '%' . $email . '%')
    ->WhereHas('userBasicInfo', function ($query) use ($pram) {
        $query->where('first_name', 'like', '%' . $pram . '%')
            ->orWhere('middle_name', 'like', '%' . $pram . '%')
            ->orWhere('last_name', 'like', '%' . $pram . '%');
    })->with(['userBasicInfo' => function ($query) use ($pram) {
        $query->where('first_name', 'like', '%' . $pram . '%')
            ->orWhere('middle_name', 'like', '%' . $pram . '%')
            ->orWhere('last_name', 'like', '%' . $pram . '%');
    }])->get()->toArray();

How can I apply pagination and offset in my above API which takes two more parameters. Your help will be appreciated!

Answer 1

Try this one

$results ['result'] = User::where('email','like', '%' . $email . '%')
    ->WhereHas('userBasicInfo', function ($query) use ($pram) {
    $query->where('first_name', 'like', '%' . $pram . '%')
        ->orWhere('middle_name', 'like', '%' . $pram . '%')
        ->orWhere('last_name', 'like', '%' . $pram . '%');
    })->with(['userBasicInfo' => function ($query) use ($pram) {
    $query->where('first_name', 'like', '%' . $pram . '%')
        ->orWhere('middle_name', 'like', '%' . $pram . '%')
        ->orWhere('last_name', 'like', '%' . $pram . '%');
    }])->paginate(6);

    return view('Your View PHP', $results);