Laravel eloquent dynamic query with where 1

Question

I am building a dynamic query in eloquent. i matching patterns if pattern doesnt match then i want WHERE 1. Basically my question is how to write WHERE 1 in eloquent

if (preg_match('/pattern/', $request->input('user_search'))) {

  $filter="'email','{$request->input('user_search')}'";

} elseif (preg_match('/pattern/', $request->input('user_search'))) {
  
  $filter="'mobile','{$request->input('user_search')}'";

} elseif (preg_match('/pattern/', $request->input('user_search'))) {
  
  $filter="'name','like','%{$request->input('user_search')}%'";

} else {
  $filter=' I want WHERE 1 here';
  The question how to write WHERE 1
}

$user = User::where($filter)->orderBy('created_at', 'DESC')->paginate(50);

why do you need WHERE 1? and what version of Laravel and PHP are you using? also all those "filters" are strings, the where method works on columns and values — lagbox
– lagbox, Commented Nov 28, 2020 at 13:36

lagbox · Accepted Answer · 2020-11-28 14:05:15Z

1

Since you want to define what is passed to where in one statement and not using multiple variables for the arguments, you can use an array:

if (preg_match('/pattern/', $request->input('user_search'))) {
    $filter = [['email', $request->input('user_search')]];
} elseif (preg_match('/pattern/', $request->input('user_search'))) {
    $filter = [['mobile', $request->input('user_search')]];
} elseif (preg_match('/pattern/', $request->input('user_search'))) {
    $filter = [['name', 'like', '%'. $request->input('user_search') .'%']];
} else {
    $filter = [];
}

$users = User::where($filter)->orderBy('created_at', 'DESC')->paginate(50);

If you pass an empty array to where it does not add a WHERE condition.

edited Nov 28, 2020 at 14:05

answered Nov 28, 2020 at 13:41

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel eloquent dynamic query with where 1

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related