Php – Laravel Eloquent orWhere Query

eloquentlaravelphpwhere

Can someone show me how to write this query in Eloquent?

SELECT * FROM `projects` WHERE `id`='17' OR `id`='19'

I am thinking

Project::where('id','=','17')
        ->orWhere('id','=','19')
        ->get();

Also my variables (17 and 19) in this case are coming from a multi select box, so basically in an array. Any clues on how to cycle through that and add these where/orWhere clauses dynamically?

Thanks.

Best Solution

You could do in three ways. Assume you've an array in the form

['myselect' => [11, 15, 17, 19], 'otherfield' => 'test', '_token' => 'jahduwlsbw91ihp'] which could be a dump of \Input::all();

   Project::where(function ($query) {
      foreach(\Input::get('myselect') as $select) {
         $query->orWhere('id', '=', $select);
      }
   })->get();

   Project::whereIn('id', \Input::get('myselect'))->get();

   $sql = \DB::table('projects');
   foreach (\Input::get('myselect') as $select) {
       $sql->orWhere('id', '=', $select);
   }
   $result = $sql->get();

Related Solutions

Php – Laravel – Eloquent or Fluent random row

Laravel >= 5.2:

User::inRandomOrder()->get();

or to get the specific number of records

// 5 indicates the number of records
User::inRandomOrder()->limit(5)->get();
// get one random record
User::inRandomOrder()->first();

or using the random method for collections:

User::all()->random();
User::all()->random(10); // The amount of items you wish to receive

Laravel 4.2.7 - 5.1:

User::orderByRaw("RAND()")->get();

Laravel 4.0 - 4.2.6:

User::orderBy(DB::raw('RAND()'))->get();

Laravel 3:

User::order_by(DB::raw('RAND()'))->get();

Check this article on MySQL random rows. Laravel 5.2 supports this, for older version, there is no better solution then using RAW Queries.

edit 1: As mentioned by Double Gras, orderBy() doesn't allow anything else then ASC or DESC since this change. I updated my answer accordingly.

edit 2: Laravel 5.2 finally implements a wrapper function for this. It's called inRandomOrder().

Php – Laravel 4 Eloquent Query Using WHERE with OR AND OR

Make use of Parameter Grouping (Laravel 4.2). For your example, it'd be something like this:

Model::where(function ($query) {
    $query->where('a', '=', 1)
          ->orWhere('b', '=', 1);
})->where(function ($query) {
    $query->where('c', '=', 1)
          ->orWhere('d', '=', 1);
});

Best Solution

Related Solutions

Php – Laravel – Eloquent or Fluent random row

Php – Laravel 4 Eloquent Query Using WHERE with OR AND OR

Related Question