Auto complete text box with PHP, jQuery and MySql
Auto complete text box with PHP, jQuery and MySql In this tutorial I want to show you how easy to do a auto complete text box with PHP, jQuery and MySql. Creating database table We need to create a table in our database before writing our script. I also add some data for this table. Import following SQL statement via phpMyAdmin or any other MySQL tool. CREATE TABLE `tag` ( `id` int ( 20 ) NOT NULL auto_increment , `name` varchar ( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 10 ; INSERT INTO `tag` ( `id` , `name` ) VALUES ( 1 , 'php' ), ( 2 , 'php frameword' ), ( 3 , 'php tutorial' ), ( 4 , 'jquery' ), ( 5 , 'ajax' ), ( 6 , 'mysql' ), ( 7 , 'wordpress' ), ( 8 , 'wordpress theme' ), ( 9 , 'xml' ); index.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://w...