/PHP/Laravel/Laravel eloquent search query 2020

Laravel eloquent search query 2020

$result = Marriage::where('name','LIKE','%'.$email_or_name.'%')
                ->orWhere('email','LIKE','%'.$email_or_name.'%')
                ->get();

Source: stackoverflow.com

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();

Similar codes

0 vote181 views1 answer
Laravel token logout
PHP Laravel
12 votes172 views4 answers
Laravel auth setup
PHP Laravel
19 votes165 views6 answers
Laravel Route Group
PHP Laravel
16 votes179 views5 answers
Get user auth in laravel
PHP Laravel
22 votes166 views6 answers
Php artisan make:auth laravel 8
PHP Laravel
4 votes167 views4 answers
Laravel sum relationship column
PHP Laravel
0 vote175 views1 answer
Laravel looping checking if last record has reached
PHP Laravel
0 vote205 views1 answer
Laravel create registration bootstrap
PHP Laravel
1 vote135 views1 answer
Trim laravel
PHP Laravel
0 vote195 views3 answers
GetClientOriginalExtension laravel
PHP Laravel