Advertisement
Guest User

Untitled

a guest
Oct 21st, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. class SearchController extends Controller
  2. {
  3.     public function autocomplete(Request $request)
  4.     {
  5.         $term = $request->term;
  6.  
  7.         $queries = DB::table('products') //Your table name
  8.         ->where('product_name', 'like', '%'.$term.'%') //Your selected row
  9.         ->take(6)->get();
  10.  
  11.         die(var_dump($queries));
  12.  
  13.  
  14.         foreach ($queries as $query)
  15.         {
  16.             $results[] = ['value' => $query->product_name, 'id' => $query->id]; //you can take custom values as you want
  17.         }
  18.         return response()->json($results);
  19.     }
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement