Monday, 24 December 2012

How to use jQuery Auto Complete in PHP and MySQL

As we know, PHP is a powerful server side programming (scripting) language through open source. In this world more than 40% of the websites are using PHP. OK fine lets go to our work now.

In this column we are gonna to know, how to embed jQuery auto suggestion by using PHP and MySQL.

Step 1:

We must download jQuery Auto complete Plugin by using this link click here. And then extract this zipped file. Finally copy jquery.autocomplete.css and jquery.autocomplete.js into your project folder.

And one more thing add your default jQuery link in your script link. Now lets start our project.

Step 2:

We have to create a new database table for this usage before we write our scripts. My Suggestion use xampp or wamp tool to create db quickly.

create db structure as shown below,