/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

4 votes180 views5 answers
Laravel storage folder permissions
PHP Laravel
3 votes209 views1 answer
Laravel validation greater than or equal to
PHP Laravel
1 vote167 views3 answers
Required_if laravel
PHP Laravel
0 vote192 views1 answer
Laravel 8 clear compiled class files
PHP Laravel
0 vote193 views5 answers
Laravel tricks and tips
PHP Laravel
0 vote214 views1 answer
How to call function in blade laravel
PHP Laravel
24 votes194 views2 answers
How to use join in laravel 5.4
PHP Laravel
2 votes185 views1 answer
Laravel delete confirm link
PHP Laravel
5 votes187 views2 answers
Throwexception laravel
PHP Laravel
5 votes240 views5 answers
Laravel file permissions
PHP Laravel