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 vote348 views1 answer
Pentationic scale jazzzz
PHP
0 vote402 views2 answers
Curl post laravel
PHP
0 vote363 views1 answer
Sub() vs substr in php
PHP
1 vote329 views1 answer
Laravel word count utf8
PHP
0 vote314 views1 answer
Fetch method and class in codeigniter
PHP
1 vote331 views2 answers
Join multiple query in laravel
PHP
13 votes336 views6 answers
Php array_diff
PHP
2 votes308 views2 answers
Php location header not working
PHP
1 vote405 views1 answer
Php begintag
PHP
3 votes346 views2 answers
Laravel collection concat
PHP Laravel