xxxxxxxxxx
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]);
}
xxxxxxxxxx
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]);
}
xxxxxxxxxx
// 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();
xxxxxxxxxx
// Employee Model
public function searchResult($search)
{
$query = DB::table("employee") ->where('employee_name', 'LIKE', '%'.$search.'%')->get();
return $query;
}