This is code search name or email is lowercase with pagination
Mã:
use App\Models\User;
/**
* @param search_val
*
*
* @return App\Models\User with pagination
*/
public function getUserBySearch($search_val)
{
$users = User::all();
if(!empty($search_val)){
$users = $users->where('name', 'ilike', "%{$search_val}%")->orWhere('mail', 'ilike', "%{$search_val}%");
}
$users = $users->orderBy('submit_date', 'DESC')->paginate(10);
return $users;
}