Laravel, autocomplete using database

Question

I am trying to do an ajax request to autocomplete the customer name, so far here's what I have: create.index.blade

    <div class="form-group">
                <strong>Customer id:</strong>
              <input class="typeahead form-control" type="text" name="customer_id"  placeholder="Customer id">
            </div>
<script type="text/javascript">
    var path = "{{ route('autocomplete') }}";
    $('input.typehead').typeahead({
        source:  function (query, process) {
        return $.get(path, { query: query }, function (data) {
                return process(data);
            });
        }
    });
</script>

here is my Assignee controller where the search route is:

use App\Customer;
public function autocomplete(Request $request)
      {
          $data = Customer::select("name")
                  ->where("name","LIKE","%{$request->input('query')}%")
                  ->get();

          return response()->json($data);
      }

here is my routes.php

Route::get('autocomplete', 'AssigneeController@autocomplete')->name('autocomplete');

I have a customer who's name is "test" whenever I am typing "tes" I am not getting prompted to auto complete it with test

I am not getting auto complete.. not sure how can I even debug it to check if the AJAX request is being sent. — Abdul
– Abdul, Commented Dec 29, 2018 at 16:21
Take a look at your Network tab in Dev Tools. Additionally, could you console.log(data) to see what kind of response you are getting? — Mozammil
– Mozammil, Commented Dec 29, 2018 at 16:22
so I am getting the following error in my Network tab: Can't find variable: $ — Abdul
– Abdul, Commented Dec 29, 2018 at 16:36

Abdul · Accepted Answer · 2018-12-29 16:41:33Z

1

I forgot to add the typeahead bootstrap files. added it using the following link:

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-3-typeahead/4.0.1/bootstrap3-typeahead.min.js"></script>

answered Dec 29, 2018 at 16:41

Abdul

1,6072 gold badges15 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel, autocomplete using database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related