Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "email": "shah",
- "name": "shah",
- }
- {
- "email": "shah",
- "name": "shah",
- "offset": 1,
- "paginate": 1
- }
- $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();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement