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

44 votes210 views2 answers
Laravel version command
PHP
4 votes183 views1 answer
Aravel 8 how to order by using eloquent orm
PHP
80 votes197 views6 answers
Php explode
PHP
3 votes197 views1 answer
Laravel remove controller
PHP
26 votes200 views5 answers
Get the number of days between two dates in PHP
PHP
32 votes178 views2 answers
Php array check value exists
PHP
0 vote156 views1 answer
Show phpinfo just modules
PHP
0 vote220 views1 answer
Laravel toastr option
PHP Laravel
0 vote188 views1 answer
Laravel sanctum Provoking tokens
PHP
0 vote216 views1 answer
Laravel Secured Password
PHP Laravel