How to create Smart Auto complete without Jquery

[rayearth_1]

i need help, i want to create a smart auto complete using a text box, it fill clients names from client database, is it any way to create those without jquery, thanks

[cereal]

Hi,

you still need a client side script to submit the on going request, you can do that without a framework, look for an example at the autocomplete.js code:

• https://autocomplete-js.com/

it does not have dependencies.

[rayearth_1]

to cereal, thanks for yur response, but what i mean is, how to create it, whithout using jquery,
to be honest, i never used Jquery, can u show me how to use , or plug the jquery to php, many thanks

[cereal]

In short you need a script that can receive a GET request, filter it and use it to perform a query, in which case would be something like:

SELECT `last_name` FROM `clients` WHERE `last_name` LIKE 'LETTER%' ORDER BY `last_name`, `first_name` LIMIT 10;

Where 'LETTER%' would be a placeholder for a prepared statement, i.e. this :last_name and defined in PHP as:

$data[':last_name'] = $input . '%';

See:

• http://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html#operator_like

I prefer autocomplete.js as with JQuery you have to add the UI library and what followes: styles, images and more code, but it's your choice:

• http://jqueryui.com/autocomplete/
• http://api.jqueryui.com/autocomplete/

Have you tried something? If affirmative, paste it here, so we can suggest you how to continue, if needed.