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 vote337 views4 answers
Laravel collection find
PHP Laravel
48 votes338 views3 answers
Php cli display errors
PHP
0 vote361 views1 answer
Get post id contact form 7
PHP
0 vote318 views1 answer
Php array extract value
PHP
3 votes347 views4 answers
Laravel cors enable
PHP
0 vote317 views1 answer
Laravel blade image
PHP
3 votes302 views1 answer
Laravel foreach index
PHP
2 votes395 views1 answer
Wordpress custom fields variable dump
PHP
0 vote351 views1 answer
Php array_diff_assoc
PHP
1 vote483 views1 answer
Symfony call another controller
PHP Symfony