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

6 votes321 views4 answers
Woocommerce get product category name by id
PHP
0 vote238 views1 answer
Phpoffice create excel and download
PHP
0 vote243 views1 answer
Wordpress featured image show
PHP
7 votes344 views1 answer
Laravel db seed specific class
PHP Laravel
-1 vote296 views1 answer
Ziparchive laravel not found
PHP Laravel
0 vote257 views1 answer
Disable sidebar widget wordpress 5.8
PHP
1 vote279 views2 answers
How to get data from a table in laravel
PHP
1 vote275 views1 answer
Linux php script create directory if doesn't exist
PHP
0 vote292 views1 answer
Laravel pivot select fields
PHP Laravel
0 vote262 views1 answer
Convert time to 24 hour format laravel
PHP