Laravel, autocomplete using database












0















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 AppCustomer;
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










share|improve this question

























  • Okay. What's the question?

    – Mozammil
    Dec 29 '18 at 16:18











  • code seems correct. so what's problem?

    – num8er
    Dec 29 '18 at 16:19











  • I am not getting auto complete.. not sure how can I even debug it to check if the AJAX request is being sent.

    – Abdul
    Dec 29 '18 at 16:21






  • 1





    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
    Dec 29 '18 at 16:22











  • so I am getting the following error in my Network tab: Can't find variable: $

    – Abdul
    Dec 29 '18 at 16:36


















0















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 AppCustomer;
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










share|improve this question

























  • Okay. What's the question?

    – Mozammil
    Dec 29 '18 at 16:18











  • code seems correct. so what's problem?

    – num8er
    Dec 29 '18 at 16:19











  • I am not getting auto complete.. not sure how can I even debug it to check if the AJAX request is being sent.

    – Abdul
    Dec 29 '18 at 16:21






  • 1





    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
    Dec 29 '18 at 16:22











  • so I am getting the following error in my Network tab: Can't find variable: $

    – Abdul
    Dec 29 '18 at 16:36
















0












0








0








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 AppCustomer;
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










share|improve this 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 AppCustomer;
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







php laravel






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Dec 29 '18 at 16:20







Abdul

















asked Dec 29 '18 at 16:15









AbdulAbdul

1191212




1191212













  • Okay. What's the question?

    – Mozammil
    Dec 29 '18 at 16:18











  • code seems correct. so what's problem?

    – num8er
    Dec 29 '18 at 16:19











  • I am not getting auto complete.. not sure how can I even debug it to check if the AJAX request is being sent.

    – Abdul
    Dec 29 '18 at 16:21






  • 1





    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
    Dec 29 '18 at 16:22











  • so I am getting the following error in my Network tab: Can't find variable: $

    – Abdul
    Dec 29 '18 at 16:36





















  • Okay. What's the question?

    – Mozammil
    Dec 29 '18 at 16:18











  • code seems correct. so what's problem?

    – num8er
    Dec 29 '18 at 16:19











  • I am not getting auto complete.. not sure how can I even debug it to check if the AJAX request is being sent.

    – Abdul
    Dec 29 '18 at 16:21






  • 1





    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
    Dec 29 '18 at 16:22











  • so I am getting the following error in my Network tab: Can't find variable: $

    – Abdul
    Dec 29 '18 at 16:36



















Okay. What's the question?

– Mozammil
Dec 29 '18 at 16:18





Okay. What's the question?

– Mozammil
Dec 29 '18 at 16:18













code seems correct. so what's problem?

– num8er
Dec 29 '18 at 16:19





code seems correct. so what's problem?

– num8er
Dec 29 '18 at 16:19













I am not getting auto complete.. not sure how can I even debug it to check if the AJAX request is being sent.

– Abdul
Dec 29 '18 at 16:21





I am not getting auto complete.. not sure how can I even debug it to check if the AJAX request is being sent.

– Abdul
Dec 29 '18 at 16:21




1




1





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
Dec 29 '18 at 16:22





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
Dec 29 '18 at 16:22













so I am getting the following error in my Network tab: Can't find variable: $

– Abdul
Dec 29 '18 at 16:36







so I am getting the following error in my Network tab: Can't find variable: $

– Abdul
Dec 29 '18 at 16:36














1 Answer
1






active

oldest

votes


















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>





share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53971193%2flaravel-autocomplete-using-database%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    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>





    share|improve this answer




























      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>





      share|improve this answer


























        1












        1








        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>





        share|improve this answer













        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>






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Dec 29 '18 at 16:41









        AbdulAbdul

        1191212




        1191212






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53971193%2flaravel-autocomplete-using-database%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Monofisismo

            Angular Downloading a file using contenturl with Basic Authentication

            Olmecas