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 vote174 views1 answer
Laravel post index method
PHP
0 vote172 views1 answer
How to auto increment id after delete value in php mysql
PHP
2 votes240 views2 answers
How to add data to the request object in laravel
PHP Laravel
0 vote188 views1 answer
Write if and else in one line laravel
PHP
20 votes180 views4 answers
Strupper php
PHP
0 vote206 views1 answer
Laravel find or create new
PHP Laravel
6 votes179 views2 answers
Create migration model and seeder laravel at once
PHP
0 vote181 views1 answer
Php preplace
PHP
12 votes211 views4 answers
Laravel call controller method from another controller
PHP
1 vote183 views1 answer
Get today date magento 2 object manager
PHP