/PHP/Laravel/Laravel eloquent search query 2020

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 vote108 views2 answers
Laravel add attribute to model
PHP Laravel
1 vote108 views1 answer
Config clear laravel
PHP Laravel
2 votes100 views3 answers
Laravel get file size uploaded
PHP Laravel
1 vote113 views1 answer
Laravel clone row
PHP Laravel
2 votes116 views2 answers
Laravel validation unique email except self
PHP Laravel
1 vote222 views1 answer
How laravel return the old value
PHP Laravel
0 vote111 views1 answer
Get where different laravel
PHP Laravel
0 vote122 views1 answer
Laravel vreeze
PHP Laravel
0 vote123 views1 answer
Laravel share on whatsapp link
PHP Laravel
0 vote115 views1 answer
Create laravel project 8.16.1
PHP Laravel