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 vote287 views1 answer
Laravel model find one
PHP
22 votes335 views2 answers
Where status is null sql in laravel
PHP
0 vote297 views1 answer
Laravel - Add conditional where clause in query
PHP
1 vote292 views1 answer
How to go to another folder in php
PHP
5 votes300 views3 answers
How to execute cmd command in php
PHP
0 vote286 views1 answer
Php exception message
PHP
0 vote314 views1 answer
Check if constant is defined php
PHP
1 vote309 views1 answer
Wordpress get id from page title
PHP
0 vote297 views2 answers
Laravel form collective add asterisk
PHP
-2 votes266 views1 answer
Timestamp property in laravle
PHP