Found this was answered on stack overflow,
http://stackoverflow.com/questions/27632236/laravel-eloquent-orwhere-query
for reference and searching,
Damien Pirsy:
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();
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community