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 vote100 views3 answers
Connect php in sql server
PHP
0 vote64 views2 answers
Laravel collection->each
PHP
2 votes119 views1 answer
Laravel asset
PHP Laravel
0 vote111 views1 answer
Laravel handle queryexception
PHP Laravel
0 vote145 views1 answer
HP officejet pro 8720 default password
PHP
1 vote92 views2 answers
Class name laravel
PHP
0 vote137 views1 answer
Cakephp 2.x join
PHP
8 votes106 views4 answers
Woocommerce checkout shortcode
PHP
0 vote101 views1 answer
Presentar la respuesta del conteo de la tabla una tabla en php
PHP
0 vote96 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP