PHP

laravel create search

public function index(){
      // // we need to show all data from "blog" table
      // $blogs = Blog::all();
      // // show data to our view
      // return view('blog.index',['blogs' => $blogs]);

      $search = Request::get('search');
      $blogs = Blog::where('title','like','%'.$search.'%')->orderBy('id')->paginate(6);
      return view('blog.index',['blogs' => $blogs]);
    }

laravel search query

  // SEARCH QUERY
  if (request()->has('search')){
      $search = trim(request('search'));
      $resumess = $resumess->where(function($query) use ($search){
          $query->where('doc_name', 'LIKE', "%{$search}%");
          $searches = explode(" ",$search);
          foreach($searches as $s){
              $query->orWhere('first_name', 'LIKE', "%{$s}%");
              $query->orWhere('last_name', 'LIKE', "%{$s}%");
              $query->orWhere('position_type', 'LIKE', "%{$s}%");
              $query->orWhere('position_type', 'LIKE', "%{$s}%");
          }
      });
  }

search in laravel 8

public function index(){
      // // we need to show all data from "blog" table
      // $blogs = Blog::all();
      // // show data to our view
      // return view('blog.index',['blogs' => $blogs]);

      $search = Request::get('search');
      $blogs = Blog::where('title','like','%'.$search.'%')->orderBy('id')->paginate(6);
      return view('blog.index',['blogs' => $blogs]);
    }

Laravel Search

// Why do this ..
$users=User :: where(function($query)use($value){
    $query->orWhere('name','like',"{$value)")
          ->orWhere('email','like',"{$value}")
          ->orWhere('title','like',"{$value}")
          ->orWhere('role','like',"{$value}%")
          ->orWhere('status','like',"{$value}%")
})->get();
//...when you can do the same with this?
$users User :: search($value)->get();

search laravel

// Employee Model
public function searchResult($search)
{
  $query = DB::table("employee") ->where('employee_name', 'LIKE', '%'.$search.'%')->get();
  return $query;
}

laravel search query

public function index()
{
  $q = Dog::query();

  if (Input::has('search'))
  {
     // simple where here or another scope, whatever you like
     $q->where('name','like',Input::get('search'));
  }

  if (Input::has('search-breed'))
  {
     $q->searchBreed(Input::get('search-breed'));
  }

  if (Input::has('sex'))
  {
     $q->where('sex', Input::get('sex'));
  }

  if (Input::has('radius'))
  {
     $q->withinRadius(Input::get('radius'));
  }

  $dogs = $q->orderBy(..)->paginate(5);

  // ...

laravel search function

$users = User::has('posts')->withCount('posts')->orderBy('posts_count')->take(50)->get();

$userIndex = $users->search(function($user) {
    return $user->id === Auth::id();
});