Ajax Autocomplete – Jquery PHP Mysql

Before Start

The aim is to design an auto complete script for text box in ajax using Jquery, PHP, Mysql. I have searched for the script, and i have found a simple autocomplete plugin here http://bassistance.de/jquery-plugins/jquery-plugin-autocomplete/ and you can find the documentation here http://docs.jquery.com/Plugins/Autocomplete.

You can download the source and see the Demos. But there is no demo fetching data from mysql. Then i have done some small trick in the php file to get data from mysql. This will be very useful in search suggestions, City, State fill up in some registrations.

HTML – Understanding the Layout

Here i have taken course names for example. I have a text box named and ided course. Thats all you need to know in the html layout.

<input type="text" name="course" id="course" />

JS – Include autocomplete plugin and activate

Download the autocomplete source from http://bassistance.de/jquery-plugins/jquery-plugin-autocomplete/ and get the jquery core, autocomplete javascript file and css file. Include them inside the head tag. After that write some code to activate the text box with autocomplete.

<script type="text/javascript" src="jquery.js"></script>
<script type='text/javascript' src='jquery.autocomplete.js'></script>
<link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />

<script type="text/javascript">
$().ready(function() {
	$("#course").autocomplete("get_course_list.php", {
		width: 260,
		matchContains: true,
		selectFirst: false

To know the autocomplete plugin options go to here http://docs.jquery.com/Plugins/Autocomplete/autocomplete and see the Options tab.

PHP – Get data from DB

Get the query word and search within the database and return the list. (get_course_list.php file mentioned in the above javascript)

require_once "config.php";
$q = strtolower($_GET["q"]);
if (!$q) return;

$sql = "select DISTINCT course_name as course_name from course where course_name LIKE '%$q%'";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) {
	$cname = $rs['course_name'];
	echo "$cname\n";

Demo & Download

Download Source

This entry was posted in Ajax, Jquery, PHP, Tutorial and tagged , , , , , . Bookmark the permalink.

199 Responses to Ajax Autocomplete – Jquery PHP Mysql

  1. Tariq says:

    Using your script and working perfectly so far, with a few tweaks.

    Have a question how can i get another varibale passed from (get_course_list.php to the index page, say course_id


  2. Johnny says:

    Thank you for getting this going with PHP!

    How could I pass both the id field along with the rest so I may put it in a hidden filed ?

  3. Pingback: Ajax Autocomplete – Part 2 – with name and value « Beschi's Works

  4. somut says:

    very very very very thanks 🙂

  5. prasath says:

    excellent thanks

  6. Milind says:

    this plugin is awesome but their is one problem when tried to delete item from list when i am used multiple:true then it not work
    will you please tell their any configuration in autocomplete.js or any extra parameter i have to pass?

    pls help me

  7. Kratos says:

    honestly the best autocomplete plugin i ever found. great job! it’s really easy to use!!
    thank you. send me an email if you want

    • beski says:

      Thanks Kratos,

      //send me an email if you want//

      • hakim says:

        bonsoir Beski,
        je trouve votre astuce très intéressant et j’ai besoin de récupérer l’ID de la fiche au lieu du Course_name pour que je puisse faire un update sur la fiche sectionnée en se basant sur celui-ci (ID) .
        merci de me filer un coup de main qui vas énormément m’aider.

  8. peter says:


  9. Patrick says:

    How do you increase the results to be more than 10?

  10. acctman says:

    Hi is there a way to omit commas from the characters a user has to type for a input? My database New York, NY i want the user to be able to type New York NY 10011 and still be able to have New York, NY display

  11. Steve says:

    hi. im testing this jquery.autocomplete and is it possible to add a combobox and sent the combobox value to the config.php page and $_get it there.

    • charles says:

      here it is… autocomplete script loads on document ready itself, so use jquery keypress & use it check when an input field is keypressed

      $(“#addbook_vehno”).keypress(function() {
      $(“#addbook_vehno”).autocomplete(“config.php&vid=”+$(‘#new_carid :selected’).val(), {
      width: 260,
      matchContains: true,
      selectFirst: false

  12. Hyder says:

    nice tutorial . i have implemented something similar using jquery here

    It’s basically the same .

  13. christie says:

    how passing the data through if $cname has the enter value (\r\n)

  14. vospunt says:

    $().ready(function() {

    rewrite to

    $(document).ready(function() {

  15. denny says:

    where i can pass q to get_course_list.php?
    is it ok if i pass variable like this:

    $(“#Lcourse”).autocomplete(“getFriendMale.php?pesan=”+document.getElementById(‘course’).value, {


  16. Heinz W. says:

    Excellent example for a newcomer to jQuery, best/easiest I have found.

    I’m trying to adapt it to do multiple comboboxes with each one based on value selected in the prior one.

    I.e. select vehicles specs: year, then makes for the selected year and then models for the selected year and make.

    I have the inputs working with faked data or rather with fixed SQL. Where I’m stuck is to use the selected year to populate the make box. I.e. pass the selection the user made to the php script that does the SQL.

    Any help greatly appreciated.

  17. Dirk says:

    The first script that i tried and that really fits. Thanks

  18. jampak says:

    i tried your script and its not working, error says $() is not defined. why is that?

  19. narobe says:

    It works perfectly but I have a latin db and the punctuations like áéíóúñ are simolized with a � any ideas ?? I’ve changed utf8 to iso and tried out utf8_decode

  20. zyn says:

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\zyn\ajax-autocomplete\get_course_list.php on line 8

  21. realAyumi says:

    How to add “images/loading.gif” when loading?

    • beski says:

      I missed a file – indicator.gif. Now uploaded in the demo. You can see the loading gif file name in the css file.
      Download any gif loading file, rename it indicator.gif and put it in the folder. Or edit the css file according to the gif file name.


    • komal says:

      it’s just easy yar

  22. narobe says:

    I solved the issue i had with the spanish punctuation marks inserting mysql_query (“SET NAMES ‘utf8′”);

  23. Marc Plotz says:

    Very nice! I enjoyed the read 🙂

    • fubowl says:

      2 things: I added the following so that an error message shows up when no results are found:

      $num_rows = mysql_num_rows($rsd);

      if ($num_rows == 0){
      echo “No results.”;

      What I’m wondering, is it possible that you can make it unclickable so that the input doesn’t then fill with a “No results.” value?

      Also– not to do these at the same time, but would it be possible to open a new window via clicking on “No results.” when it drops down?

      • fubowl says:

        Okay, so I found this that should reload another URL when a link is chosen:
        var data = [ {text:’LA’, url:’/page1′}, {text:’Link B’, url: ‘/page2’} ];
        $(“…”).autocomplete(data, {
        formatItem: function(item) {
        return item.text;
        }).result(function(event, item) {
        location.href = item.url;

        But when I add it to the head javascript of test.php nothing happens. Right now I have LA as the “link” since that’s the entry in my database that shows up. Any ideas?

      • fubowl says:

        By the way, found that piece of code on the jquery site @ http://docs.jquery.com/Plugins/Autocomplete#Demos

  24. rashed says:

    Thanks a lot i can make it

  25. Viktorfs says:

    What do the two buttons do?, Sorry for the ignorance.

  26. Abraham H. says:

    It is very nice code! I like it! Thank you for your demo.

  27. thank you… i think this is what i’m looking for. i’ll try this now…

  28. it’s working… i love it… hehehe… thank you so much…

  29. Pingback: 2010 review – Pagination and anchor scroll are most wanted | Beschi's Works

  30. Rituparna says:

    Really……….Its Wonderful.It works for me great.It is very simple to understand.


  31. George says:

    Very nice… but I have a little question:
    How can I display the suggestions in a div id?
    I hope you understand…

  32. Alex says:

    Hi I have adapted your script and it´s work almostfine now. Just something I could not do is: I want when people press enter and the script will open the link at once ( don´t need to press submit again there http://feemfans.com/test2.php (use keyword “a ” for testing

    Thanks for further help.

  33. Brandon says:

    Thank you Beschi! For people who are searching a table with entries that contain apostrophes: make sure you addslashes to the query going in and strip them coming out. If you don’t, your query will still return results but when you select an item with apostrophes from the returned dropdown list, it’s not going to be found in the database and you will be left with a blank input box.

    $q = (strtolower(addslashes(trim($q))));

    $course_name = (stripslashes($rs[‘course_name’]));

    • Beschi says:

      Thanks Brandon.

    • Pasu says:

      I’ve got the similar problem!
      whatever i type sth, a blank line is revealed as the first item in the dropdown list.

      how can i resolve it?

      • Brandon says:

        Did you solve this problem? That sounds different from what I was describing above. If you only get a blank line when typing in “sth” you should probably check your database to see what result row is being returned. See what’s different about the data in that row to see why you are getting a blank line. Check if the field has an apostrophe, etc.

  34. Vivek says:

    Hi Beschi,
    Very useful tutorial, Really nice.
    I am appending this feature in my project, I have two query in this
    1)for some cases i am not able to select the value from the list. If i select it will disappear. But it will list perfectly for me in the drop down list, If i try to select the value will disappear.
    2) query is if i select the default value i.e recognize, “recognize ” will appear in the selection box.


  35. Robin says:

    If I have a database with both eg. CourseID and CourseName, and I want it to be possible to search for them both in the search input, and it shows like:
    “S134421 TheCourseName” as matched courses, but when I choose a course I would like it to only be returned as “S134421”, skipping the CourseName…

    How to get this? Guess it has something to do with formatMatch, formatItem, formatResult? Don’t know how to implement it though…


    • Beschi says:

      Hi Robin,
      Refer the next post (with value).
      I guess your data returns [id], [id course] and displaying [id course], on result function set the [id] as value…

      Beschi A.

  36. Thomas Bjerre says:

    Hi. This is awesome, thnak you Beschi. Looked for hours and hours for something that worked.
    I have one question which i can see others are interested in as well. I have to searches where the last uses the ID from the first. How is this posible? I know i can set the value of a hidden input field, but i dont know where to put my javascript ‘onclick’ etc. Again. Thanks so much!!

  37. Abhishek Srivastava says:

    the Demo is really slow and does not load up in time!!

  38. Abhishek Srivastava says:

    “$q = strtolower($_GET[“q”]);” hi can you tell me how is ‘q’ used here ??
    I don’t really get this part and I’m new to Ajax.

  39. dhanam says:

    Good Work…But its not working when calling jquery funtion more than 8 times… I am new to jquery. What is the solution for this?

  40. tweety richardson says:

    Thanks for the amazing script.
    I was trying to clone the autocomplete text box.
    do u have any scripts for that?


  41. Saurav Das says:

    thnx bro… it’s the most easy and amazing script that i have ever seen in net… but one problem is ….
    can u tell me… how can i get the the results to be more than 10?… that means how can i get the hole list when i put the search string. please help me out bro…
    in previous post u said that.. to use “option: max: 15.. “.. the default value of max is here 100 .. did u mean that to change it 100 to 15?? plz tell me in details…

  42. Saurav Das says:

    yes i have tried it, bt its not working…. 😦 ..the result is same as before.. it showing only 10 result.. please help me bro…

    • Beschi says:

      This should work.
      Download the source of mine, create the table I have given. Then try this code.
      $().ready(function() {
      $(“#course”).autocomplete(“get_course_list.php”, {
      width: 260,
      matchContains: true,
      selectFirst: false,
      max: 15

      This is working for me.

      -Beschi A.

  43. Saurav Das says:

    thnx bro thnx a lot… its now wrkng fine.. 🙂

  44. hi
    very good code
    i was searching 1 day for this code
    very great and wonderful code
    thnx to u all

  45. wye says:

    Man I’m really glad that people like you post stuff like this on the web.

    There are so many examples of similar functionality that it’s mind numbing. Of those countless examples, most authors assume that you understand the topic as well as they do & the instructions are obtuse. Of the remaining *very few* examples that are actually worth the time it takes to read them, most are still not well explained.

    You just have whatever it takes to explain a complex subject in the simplest way. And your example code was working in under 5 minutes after uploading it to my server. With another 20-30 minutes it will probably be integrated into my core design. Thanks for being brilliant, & sharing it with the rest of us.

  46. Edward says:

    It works very well for me, except when i clear the box since i decide not to enter a value after all, the hidden ID field still still holds the ID of the value I had selected initially.
    Would you have a fix for this?

    • Beschi says:

      This is one way…

      You can check this in form submit…

      if($(‘#input-elem’).val() == ”) {


  47. Edward says:

    not a bad idea, but is there no way to integrate this in your basic script? i would prefer to do this before the submit goes off (iff possible)

    like only have the autocomplete.php being called when the field contains at least one character, and have the hidden id field emptied when when there is no character in it?

  48. Jake says:

    I’m having an issue using the plugin multiple times on the same page. Which part of the script do I need to modify? I already changed the get_course_list.php to another name, changed the $sql variable as well as the $cname variable, and attached the new scripts.

  49. Anoir Chkir says:

    thank you so so match, this work
    I have 2 days searching about a good examples like this

  50. Ajay Patel says:

    I want to set the drop down selected data text box value how can i?

    • Bill says:

      Do you mean the variable value, or the options?
      If it’s the variable, click his link at the top of the page for “Part 2”, he tells how to put a value (like an ID value) into it.
      For options, follow his link above to the “options” — I made the visible drop down larger, and increased the results, by adding this:
      max: 20,
      selectFirst: true,
      scrollHeight: 260
      (In the code, underneath “matchContains: true,”)

  51. Dimitris Botsis says:

    Hi, very nice code but I had problems when having results in Greek, although I used :
    mysql_query(“SET NAMES utf8”)
    So, problem was solved by replacing :
    $q = strtolower($_GET[“q”]);
    with :
    $q = mb_strtolower($_GET[“q”],’UTF-8′);
    Now all is OK

    • Leonidas says:

      File mou se eyxaristo para ma para poli gia tin lisi sou giati eixa terastio provlima!!kai mono esy to vrikes se olo to internet…ti na po… 🙂 Kai pali se eyxaristo poli!!!
      Thank you very much my friend!!Just a great solution for Greek!!!!

  52. Bill says:

    Thank you! This really helped me.

  53. Jonathan Clark says:


    I’m having troubles implementing your code (very nice by the way)

    It gets stuck loading (the graphic continues to spin with no results)

    I’m positive the php sql file works. Where do you set what the value is? ie. the ‘q’ variable.

    Could this be a css problem?

    Any ideas?

  54. It helped me a lot and save my time.Thanks a lot.

  55. roger says:

    thank you for you code.
    I have a problem dealing with chinese,it seems that ajax does’t work. $_GET[“q”] is empty.
    i don’t know what’s the problem ,looking for help.
    thanks a lot.

  56. Quentin says:

    Thank you so much for this script,
    but I have a question :

    When I writing in the label, I have my selection of my table and a number ( the one).
    How delect this ?

    Thank you

  57. Edward says:

    You are a very good man Sir Beschi! You are so generous in sharing your hard work.

    Is this possible for multiple searchbox inside the form? Please help me if you have time. I know you are busy with your programming.

    Thank you and be blessed!

  58. Tina says:

    I can’t seem to load this script. I get this error in Chrome Developer Tools:
    Uncaught TypeError: Object # has no method ‘autocomplete’

    Do you have any idea what could be wrong?

    • Tina says:

      It’s working now. I was using both jQuery and Mootools and both use $ as an alias to a core function. So I just used jQuery instead of $. 🙂

  59. Hi, I really love your script. However, I have one problem now which i am stuck for days!!
    My form consists of other inputs and the dropdown suggestion does not ‘overlay’ the inputs.
    Thus, I can see a textbox covering some of the suggestions.
    Can you guide me how to set the CSS so that the suggestion box can ‘overlay’ all other elements on the page?
    Thank you!

  60. Rakesh says:

    nice post…

  61. Tommy says:

    Download link doesn’t work 😦

  62. leehoo says:


    I have past 2 days trying to find the solution and nothing until find his post.

    Realy: you R a GOD.

    I cannot undertand why autocomplete JQUERY docs are so INCOMPLETE on SQL integration.

    Thank you

  63. Hi,
    Resource was veru helpful, I need to add multiple courses via textarea element with the help of AutoComplete. May i know how can i accomplish this..Your Ideas are most Welcome
    Thanks in Advance

  64. Thank You Very Much…
    I struggled with getting this done with other examples, but yours was clear and easy to follow.

  65. Maman H says:

    finally i found the script to posted Beski. Thx alot. Now I am trying to find more script to enable the field for multiple values.

  66. Pingback: AJAX Autocomplete PHP Tutorial | KC-TUTOR

  67. andyp says:

    how can i find the “config.php” file?

  68. Fery Ardiant says:

    Thanks, it work and helped me so much….. 😀

  69. webinonein says:

    I also created and shared like this tutorial here for everyone.

  70. Peter says:

    Spent hours looking online for an Autocomplete that worked. This is great. Works beautifully!

  71. Eric says:


    Hello! excellent work man. But i have a question, how can i disable submit button until valid selection is made form drop-down box, in other words speaking no “submit” button until value matches one in database ?? i that possible with out calling query again to database?

    thank you 🙂


    • Beschi says:

      Try property – mustMatch: true

      • Eric says:

        Thank you for you response, yes i tried this option but submit button will submit whatever i type in the box because drop-down window wont disappear or wont take an action when i hover mouse outside of text-box or drop-down (autosuggestion) menu, before mustMatch can take over i have to click outside the menu or textbox. Do you see the problem here?

  72. Anand says:

    Thanks, it’s very good and simple.

  73. Eric says:

    ok, figured out the this part by modifying the code. How can pull more data from mysql to add pictures to it?

  74. v.... says:


    I need help how can i pass any costume value along with textbox value
    eg. [ $(“#course”).autocomplete(“get_course_list.php”, ]

    What i want to also pass category id with “course” ??

    Plz advise me


  75. Radek says:

    Good job!
    working great.

  76. sweetmaanu says:

    how can we set up that to show data in input which is selected

  77. J says:

    Its 2012, and I ❤ you OP

  78. Michael says:

    Is it possible to add in this result-list “serch-key” from clients (just overhead). I mean to show list with results words from Database and with “serch-key” from clients overhead those list , and show only 1 more time. For example…
    I have Database with post offices from many states and regions.
    1 region – Europa, number 98
    2 region – USA, number 09
    And I have many states from Europa and USA, like Berlin from Europa with number (98)521 and from USA with (09)112. So wenn a klient is trying to serch “98”, I want to show him not only result like “Berlin”, but also this region like “Europa” with extra CSS style overhead state Berlin, but to show only one more time. You have loop in your script, and it shows a lot times).
    Or how to make just showing what client typing (overhead) and a result from Datebase at the bottom also.

  79. Sakina says:

    Very nice and helpful article. Thankyou

  80. Archit says:

    Work awesome!

    I have one problem though. In your demo, as we type, the matching alphabets/phrase gets highlighted/bold but on my textbox it doesn’t. How do I solve this?

    Thank You.

  81. Eric says:

    Hello! is there anyway to add line “not found” and make it in form of a link ??


  82. Umair Afridi says:

    Thanks Allot very helpful

  83. There is no query validation on this .. I would personally validate the query, otherwise you’re just asking for a SQL injection.

    • Chris says:

      I was worried about this too, so I used a prepared statement to validate $q, after I got the SQL to pull all of the correct information.

  84. Faysal Ahmed says:

    Reblogged this on Faysal Ahmed.

  85. Hey, this is very nice example and it works perfect in a few seconds. thx

  86. Chris says:

    Just wanted to let you guys know if you do you SQL query with the (Lower) it can pull the DB and match all cases.

    SELECT DISTINCT Name FROM Table where LOWER(Name) LIKE ‘%$q%’ ORDER BY Name ASC

  87. Kyle says:

    very nice code. BUT is there a way, to also return the id of that row? not just name. I can obviously return the name of the search, but i would like to get the ID (int) of that row.

  88. Muditha says:


  89. sagar says:

    Is this possible for multiple searchbox inside the form? Please help me if you have time.I tried alot on it but unable to get the solution for multiple search box……

  90. renishkhunt says:

    wow tha’s really good and very veyr helpfully code thank you dear

  91. rend0g says:

    Hi, is it possible to get other data mysql apart from the course_name. Thanks!

  92. Naved says:

    Heyyy….. this is awesome …. works fine for me …. thanks a LOT…… 😀

  93. Muthukumar says:

    I did not got mysql result…how can i solve this problem….?

  94. Fredrik says:

    Is it possible to add a close button to the autocomplete drop down list?

  95. Thank you very much is it really useful for me

    could any one help me “how to change list position” please

  96. sugoihello says:

    hi, thanks for your great tutorial!! can you provide tutorial on how to include image icon and text elements in the autocomplete list?

    • sugoihello says:

      other than that, let’s say i have a table with id, bookname, author, publisher fields. I have to search a book when enter bookname or either author or publisher. for author and publisher, it will return a bookname belong to that author or publisher. But how to do that? hope you can understand it. I was quite weak in SQL.

  97. Pingback: Script installation service

  98. Leonidas says:

    First of all thank you for the great code!!!!
    I just have a problem, i want to search in greek but i do not get any results..just in english…i have utf8 everywhere encoding,header, everywhere also in set names…can u help me?
    Thank you very much!!!!

  99. Konuyu bu kadar kolay ve güzel anlattığınız için çok teşekkür ederim. Allah Sizden Razı olsun. Bilginizi arttırsın.
    EN: Topic Thank you so much for telling it so easy and beautiful. God bless you. FYI God.
    Thank you very much!

  100. To start with, hypertension, also referred to as high blood pressure can be a awful ailment that may be frequently involved to some very poor way of life. blood pressure medicine Depending on the quantity of strain you encounter everyday and actions in a different time of working day, your blood pressure level readings will vary. * Aronia berries can reduce blood clots from developing and therefore decrease the incidence of atherosclerosis.

  101. zeerak says:

    hey my code is not working cn u help plz …. i thinks its a little bug which i am unable to find !!

  102. zeerak says:

    here is the code its 1st file:

    $().ready(function() {

    $(“#uname”).autocomplete(“get_course_list.php”, {

    width: 260,

    matchContains: true,

    selectFirst: false




    its 2nd file:

    my database filed name is username , the problem which m facing is that, its not showing matched keywords, instead of that its showing the whole username field names , e.g if i press f then it appears all names of the field sorting is not happening!!

  103. Very nice post, Like it.
    Waseem Akhtar Tanoli.

  104. Vinnie says:

    Brilliant post but getting the following error;

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\NetBeansProjects\Mogadishu\getDeviceName.php on line 8

    Any idea how I can solve this?

    Best regards

  105. Alfan Nasrulloh says:

    Reblogged this on Alfan Nasrulloh and commented:
    Mantab sekali, sudah dicoba dan berhasil

  106. Douglas Salomão says:

    When I click the submit button I be directed to my page with the search results. EX: ” ”


  107. Douglas Salomão says:
  108. Furthermore, there’s evidence showing that antinutrients act as endocrine disrupting substances, promoting metabolic syndrome20. The Cavemen Diet May Be The Answer To Your Acne WoesCystic Acne Can Be Related To DietThe paleo is also known” The Caveman Diet, beating yourself up over it won’t help.
    As with any diet, you don’t experience those blood sugar-fueled cravings. I made this dish for breakfast and a salad for lunch or dinner. Whether you choose to follow a paleo seem to do so because it actually works.

  109. phimbac says:

    How do can i replace mydomain?cource=value+need+find ==> mydomain/search/value+need+find when press Enter ?. Thanks very much!

  110. Nil says:

    How To give action On Autocomplte Form On Single Press On enter how to do this

  111. Pingback: Open Layers + Nominatim + Autofill |

  112. The below blueprint will give you the skills to help build traffic for your online business you
    should consider finding best Profit service provider.
    They mark those word as a SPAM! While these article directories and many of that
    are fake and some them are good and we can trust. They are applying innovative and creative
    ideas to rebuild their online image.

  113. The cramps are really painful the initial 1-a couple
    of days, that I attended close to passing out.

    You might still rely on us, for superb-quality party bags, party shoes and
    accessories at great prices. “No one could have ever thought it of him,” Quinn said.

  114. Nil says:

    Nice scripts It”s Working Thanks But I Want add stylish scroll in it How to!!

  115. As long as you start looking at yourself instead of those around you.
    Get My Husband Back Many times we hear someone say to us, even when the dancing does.
    Schools will now be left to draw up their own curriculum
    for the non-compulsory subject, which is not fun to be around that person
    any more. Non-monogamous get my husband back are surprisingly common and the numbers are increasing, according to Theravive.

  116. samiullah says:

    very nice tutorial…thanks for sharing this tutorial…….best job your doing…….

  117. Obud says:

    Thank you very very very much…….

  118. I seldom create responses, however after looking at a few
    of the comments on this page Ajax Autocomplete – Jquery PHP Mysql |
    Beschi’s Works. I do have a few questions for you if it’s allright.
    Is it only me or does it look as if like some of the comments come across as if they are
    written by brain dead folks? 😛 And, if you are writing on additional sites, I’d like to follow you. Could you make a list of the complete urls of your shared sites like your Facebook page, twitter feed, or linkedin profile?

  119. I really love your site.. Great colors & theme. Did you create this website yourself?
    Please reply back as I’m wanting to create my own personal website and want to know where you got this from or just what the theme is called. Cheers!

  120. We are a gaggle of volunteers and opening a brand new scheme in our community.
    Your web site offered us with helpful information to work
    on. You’ve done an impressive task and our whole neighborhood will probably be grateful to you.

  121. You’ve made some really good points there. I checked on the internet for additional information about the issue and found most individuals will go along with your views on this site.

  122. Sandipan says:

    Best Script ever I found.
    Thanks a lot.

  123. Good day I am so grateful I found our website, I really found you
    byy accident, while I was researching on Aol for something else, Anyhbow Iam here now and would just like to say
    thanks a lot for a marvelous post andd a alll round thrilling blog (I aalso love the theme/design),
    I don’t have time to red it all at the moment but I have saved it and also added in your RSS feeds, so
    when I have time I will be back to read a great deal more,
    Please do keep up the superb jo.

  124. I’ve ben browsing online more than 3 hours today, yeet I never found any interesting article like yours.
    It is prettfy worth enough for me. Personally, if all web owners and bbloggers
    made gpod content as you did, the net will be a lot more useful than ever before.

  125. Hey, good web-site you have got at this time there.

  126. Well done, and thanks for such a good tutorial.

  127. My family all the time say that I am wasting my time herre at net, however I know I am
    getting knowledge daily by reading thes gkod articles or reviews.

  128. Rachid Alami says:

    Thank you friend, very helpful, there is another example, it may help you:

  129. lenny says:

    Good script but unfortunatly doesn’t work on jQuery 1.10.n

  130. Hilton says:

    Excellent way of describing, and pleasant post to take facts concerning my presentation subject matter,
    which i am going to present in institution of higher education.

  131. With havin so much content and articles do you ever run into any
    problems of plagorism or copyright violation? My website has a
    lot of completely unique content I’ve either created myself or outsourced but it looks like a lot of it is popping it up all over the web
    without my permission. Do you know any ways to help
    prevent content from being stolen? I’d certainly appreciate

  132. Wolfgang says:

    I think the admin of this web site is genuinely working
    hard in favor of his web page, because here every information is quality based

  133. Hi there, You’ve done an incredible job. I will certainly digg it and personally recommend to my friends.
    I’m confident they will be benefited from this web site.

  134. I always spent my half an hour to read this weblog’s content daily along
    with a cup of coffee.

  135. belly flab says:

    Every weekend i used to pay a visit this website, for the
    reason that i want enjoyment, for the reason that this this site conations truly nice funny
    stuff too.

  136. First of all, it’s important to face up to reality. The best way to
    get him back is by ignoring him and using male psychology.

    Every innocent email you send him, every little
    message you write on his Facebook wall.

  137. This is the riad in marrakech hotel jomana motive why, it is a safe way to do this if there are errors
    filling out the forms, or the forms are filled incorrectly or not turned in on time.
    Chances are you ll end riad in marrakech hotel jomana up
    at the auction mills. You can write something more elaborate.

  138. weight loss says:

    I loved as much as you’ll receive carried out right here.
    The sketch is tasteful, your authored material stylish.
    nonetheless, you command get bought an edginess over that
    you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly a
    lot often inside case you shield this increase.

  139. Helpful information. Lucky me I discovered your site by accident, and I’m shocked why this twist of fate didn’t came about in advance!
    I bookmarked it.

  140. nwturally like your web site however you need to test the spelling on quite a few of your posts.
    A number of them are rife with spelling issues and I in finding it very troublesome to tell the truth then again I will certainly comme again again.

  141. constantly i used to read smaller posts that also clear their
    motive, and that is also happening with this post which I am reading at this place.

  142. Rupanshu says:

    Thanks For the information. Its a useful one for me.
    But I am facing an issue and it would be helpful if you can help in this .
    while trying to run the code I am getting error message :-
    Error: cannot call methods on autocomplete prior to initialization; attempted to call method

    Does anybody else faced this issue and what was the resolution for this?

    Thanks in Advance..

  143. Haider Ali says:

    HI !

  144. creature academy astuces says:

    It can be a budget end phone from HTC and it is planning to tackle the newest Sony
    Xperia U and LG Optimus L3. Most individuals who was raised
    inside 90’s will admit that there was actually little else to
    perform except play game titles. This may help help you stay as organized as
    possible, and store all of your info on one device. For a variation,
    have players find facts in similar families as a way,
    like 10 – 1, 10 – 2, 10 – 3, 10 – 4 so on. Yes you can All that’s left is to
    try out a new backup, or simply bask in the security of experiencing 1.
    If the members don’t get you then hunger, animals, as well as the cold are just waiting to end you.
    If you’re looking for cool games and funny games, you’ll find one
    that suits your taste. We are proud introducing our extra durable, super-comfortable PS3 controller silicone case for PS3.
    This requirement of shade was the reason that Bullnose
    Verandahs became normal for the large proportion of Australian homes,
    variety to shade the windows and outdoor patios of your property.
    There are various playing modes, including one where you might
    be meant to drive the wrong way, looking to avoid oncoming vehicles,
    and a ‘Rage Mode’, in which you must try to remove as numerous cars as you are able
    to. When ever you play casino games online you’ll be able to choose from your huge selection of
    games, select any (free or paid) mode to play with which enable it to even win bonuses without
    any cash. Role-playing games are great since players role-play his or her characters, making decisions and acting within the fictional setting produced by the
    game designers. This is surely an online multiplayer war game that
    features a pair of characters and scenario with aerial and ground assault.

    Manic Miner can be a rework with the classic Manic Miner game.
    In this way, you and your date will not likely lose interest in your first date.
    You may make the bingo pretty much challenging by varying the quantity of cards for the table.

    Once you’re sure you’ve each of the required stuff, you might be about ready to start out downloading free Ipod games.
    There is an additional great other side to achieving this
    too, the truth that what ever type of costume
    you discover, you or maybe your kids may use again at Halloween,
    obtaining the affordable through your costume investment.
    Step Two – After you’ve got downloaded the guide
    from the first task, read on over the ‘songwriting mistakes’ in the following paragraphs and use it (combined with the advice I offer) to significantly boost your songwriting.
    Regardless of whether it’s an afternoon scavenger hunt or
    perhaps a lifelong game of Concealed Mickey played yr right after yr, no cost Disney games include that unique
    touch that can make getaway reminiscences. If you apply the advice in the following paragraphs, you will be able to acquire
    the most out of your gaming experience. There are lots of websites where you are
    able to enjoy playing free monster truck games.
    It really is a undeniable fact that when folks must examine it by
    means of remedies and quantities, folks this discovering process so you are able
    to get tricky. And it really is also based on the apple applications on the most game players
    talk of one. Play online to get achievements and compete against your
    Facebook friends or play offline.

  145. goatmilk says:

    First of all, thank you HEAPS for the code! A true legend!
    I’ve managed to implement the code and it works great. I’m looking to make a couple of tweaks and hoping you can help:

    1. The database field header appears in the results as well. Is there a way to prevent this from showing?
    2. Is it possible to set the words “Please type here” as the default value of the input box? And then when someone clicks in the box, the words would disappear and they can start typing?
    3. Lastly, how can I limit users to only select options from the autocomplete list (i.e. if a user types a word that is not in the database, they see see a message in the autocomplete list saying “No values found”?

    Really appreciate your help!

  146. Quique FLow says:

    Thank you so much for the info about PHP

  147. Marky says:

    Hi Beschi! Thanks for the autocomplete code.. Got an issue.. why it only works in localhost but when I tried it in live site its not workin ? help please..

  148. Fabian says:

    Hey Beschi,
    I want to use your code.
    Is it possible to get a thumbnail in the list of matches?
    Please can you helt me?

    Best wishes

  149. Pingback: Answer for In need of an autosuggest that returns an ID and firstname from the database - Tech Magazine

  150. You can certainly see your enthusiasm in the work you write. The world hopes for even more passionate writers such as you who are not afraid to say how they believe. All the time go after your heart. “Every man serves a useful purpose A miser, for example, makes a wonderful ancestor.” by Laurence J. Peter.

  151. Thanx for the effort, keep up the good work Great work, I am going to start a small Blog Engine course work using your site I hope you enjoy blogging with the popular BlogEngine.net.Thethoughts you express are really awesome. Hope you will right some more posts.

  152. Era Flintroy says:

    Well I definitely enjoyed reading it. This article provided by you is very practical for correct planning.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s