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

0 vote175 views1 answer
Onde que fica a praia escondida no roblox jo mulher maravilha
PHP
3 votes233 views1 answer
Check file size validation laravel
PHP
0 vote159 views2 answers
Laravel form collective add asterisk
PHP
2 votes165 views2 answers
Laravel many to many update all pivot
PHP
0 vote171 views1 answer
Woocommerce product hooks
PHP
3 votes161 views1 answer
Laravel check if environment is production
PHP
0 vote171 views1 answer
Php extend parent constructor
PHP
1 vote224 views1 answer
How to insert multiple data at a time with create method in laravel
PHP
0 vote177 views1 answer
Laravel relationship retrieve data
PHP
2 votes207 views3 answers
How to get the size of an uploaded file in laravel
PHP Laravel