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 vote126 views1 answer
Current time input field in laravel form
PHP
0 vote224 views1 answer
Yii 1 clear cache
PHP Yii
5 votes117 views3 answers
Laravel display error message
PHP
0 vote135 views1 answer
Wpdb->prepare
PHP
0 vote106 views1 answer
Laravel eloquent mass assignments
PHP Laravel
0 vote116 views1 answer
PHP Warning: Module 'soap' already loaded in Unknown on line 0
PHP
18 votes130 views5 answers
If else statement in laravel blade
PHP
0 vote181 views1 answer
How to use attempt in laravel
PHP Laravel
15 votes135 views3 answers
Pass data to blade laravel
PHP Laravel
15 votes116 views4 answers
Compare dates datetime php
PHP