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 vote154 views1 answer
Php value to javascript variable laravel blade
PHP
0 vote159 views1 answer
Laravel form in 24 hours format
PHP
1 vote147 views1 answer
Composer require laravel/ui not working laravel 8
PHP Laravel
6 votes166 views2 answers
How to uninstall php7.4 version in nginx
PHP
7 votes167 views4 answers
Php create Hmac sha256
PHP
0 vote190 views1 answer
Phpmyadmin mysql execution time
PHP
4 votes213 views2 answers
How to rename a table element in laravel
PHP Laravel
0 vote161 views1 answer
Httpd.exe: Syntax error on line 186 of C:/Apache24/conf/httpd.conf: Can't locate API module structure `php_module' in file C:/php7.4.27/php7apache2_4.dll: No error
PHP
0 vote194 views1 answer
Laravel route not calling function of controller
PHP Laravel
0 vote200 views1 answer
Laravel check if api request
PHP Laravel