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

1 vote189 views4 answers
Php boolean to string
PHP
0 vote254 views1 answer
Cloudinary laravel
PHP
6 votes212 views6 answers
Php return a json response
PHP
0 vote323 views1 answer
Laravel inline if else if
PHP Laravel
0 vote221 views1 answer
WhereJsonContains laravel
PHP Laravel
27 votes196 views4 answers
Php key exists
PHP
1 vote214 views1 answer
Copy env example to .env in laravel
PHP Laravel
0 vote197 views2 answers
Warning: parameter 2 to search_by_title() expected to be a reference, value given inwp-includes\class-wp-hook.php on line 287
PHP
0 vote179 views1 answer
Switch php version ubuntu 20.04 site:stackoverflow.com
PHP
2 votes225 views1 answer
Proper permission webserver laravel
PHP