/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

0 vote134 views1 answer
Laravel echo server
PHP Laravel
2 votes136 views2 answers
Laravel get public path url
PHP Laravel
0 vote138 views4 answers
Share var in a maser layout laravel
PHP Laravel
11 votes137 views6 answers
Laravel create resource
PHP Laravel
19 votes130 views6 answers
Laravel Route Group
PHP Laravel
12 votes130 views6 answers
Run seeder in migration laravel
PHP Laravel
5 votes130 views3 answers
How get some parameter from request in laravel
PHP Laravel
0 vote135 views1 answer
Snactum laravel
PHP Laravel
6 votes138 views3 answers
Laravel foreach loop index from 1
PHP Laravel
5 votes132 views1 answer
Laravel model method like foreach parts of
PHP Laravel