Making an html text field dynamic(Autocomplete jquery)

Question

This is my Mysql query:

mysql_select_db($database_final, $final);
$query_Truck = "SELECT * FROM tbl_truck";
$Truck = mysql_query($query_Truck, $final) or die(mysql_error());
$row_Truck = mysql_fetch_assoc($Truck);
$totalRows_Truck = mysql_num_rows($Truck);

how can i get the data inside this to be in the jquery autocomplete with the id of the truck plate number being the one stored in the database and not the truck plate number itself?

You are looking for the autocomplete functionality, you are better off googling for: php jquery autocomplete mysql — bagonyi
– bagonyi, Commented Dec 1, 2013 at 5:10
Select2 is a library for providing all sorts of useful select widgets. The AJAX version might be of particular interest: ivaynberg.github.io/select2/#ajax — Darragh Enright
– Darragh Enright, Commented Dec 1, 2013 at 5:11

Matt · Accepted Answer · 2013-12-01 05:10:15Z

1

You could play around with jQuery's autocomplete. There are great examples on that site, and the API is on this page.

Or, shameless plug, you can check out a random implementation of autocomplete on my own website, at www.classbooklist.org

answered Dec 1, 2013 at 5:10

Matt

4373 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Making an html text field dynamic(Autocomplete jquery)

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