Laravel search query with multiple conditions add simple “where” clauses to your search queries Example with Like Operator.
laravel search query
The database table stores firstname and lastname as separate fields. the following tables write a SQL query to find the First Name and Last Name.
Example 1:
Laravel Controller Code:
<?php
namespace App\Http\Controllers;
use App\Models\Member;
use DB;
class PakaController extends Controller
{
/**
* Write code on Method
* created by Pakainfo.com
* @return response()
*/
public function index()
{
$search = "Ridham Ka";
$members = Member::select("id", "first_name", "last_name")
->orWhere(DB::raw("concat(first_name, ' ', last_name)"), 'LIKE', "%".$search."%")
->get();
dd($members);
}
}
Result
Array
(
[0] => Array
(
[id] => 127
[first_name] => Ridham
[last_name] => Kakadiya
)
)
Don’t miss : laravel group by
Example 2 :
Laravel Controller Code:
<?php
namespace App\Http\Controllers;
use App\Models\Member;
class PakaController extends Controller
{
/**
* Write code on Method
* created by Pakainfo.com
* @return response()
*/
public function index()
{
$search = "Ridham Ka";
$members = Member::select("id", "first_name", "last_name")
->whereRaw("concat(first_name, ' ', last_name) like '%" .$search. "%' ")
->get();
dd($members);
}
}
Result
Array
(
[0] => Array
(
[id] => 127
[first_name] => Ridham
[last_name] => Kakadiya
)
)
Example 3:
Laravel Controller Code:
<?php
namespace App\Http\Controllers;
use App\Models\Member;
class PakaController extends Controller
{
/**
* Write code on Method
* created by Pakainfo.com
* @return response()
*/
public function index()
{
$search = "Ka";
$members = Member::select("id", "first_name", "last_name")
->where(function ($q) use ($search) {
$q->orWhere('first_name', 'like', "%{$search}%")
->orWhere('last_name', 'like', "%{$search}%");
})
->get();
dd($members);
}
}
Result
Array
(
[0] => Array
(
[id] => 127
[first_name] => Ridham
[last_name] => Kakadiya
)
)
I hope you get an idea about laravel search query.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.