search in array laravel code example
Example 1: laravel where in array
$items = DB::table('items')->whereIn('id',[1,2,..])->get();
Example 2: search query in laravel
$searchTerm ='milad zamir Abc';
$reservedSymbols = ['-', '+', '<', '>', '@', '(', ')', '~'];
$searchTerm = str_replace($reservedSymbols, ' ', $searchTerm);
$searchValues = preg_split('/\s+/', $searchTerm, -1, PREG_SPLIT_NO_EMPTY);
$res = User::where(function ($q) use ($searchValues) {
foreach ($searchValues as $value) {
$q->orWhere('name', 'like', "%{$value}%");
$q->orWhere('family_name', 'like', "%{$value}%");
}
})->get();
Example 3: laravel where in array
$items = Item::whereIn('id', [1,2,..])->get();