如何使用PHP和MySQL中的字母搜索从数据库中获取数据

Question

I need one help.I need to get data while user is typing letter inside text field from database using PHP and MySQL.I am explaining my code below.

$searchData=$_GET['search'] ;

In the above line user is getting the letter typed by user and once one letter will be typed the according to key word search the data will fetch from data base.I am explaining the table below.

db_name:

id    name     status

1      Raj      1    

2      Rahul     1   

3      Dog       1

4      Deer      1

Suppose user typed the the first letter R the all two names belongs to R should display and the single name will come when full name will be typed.Please help me to resolve this problem.

Answer 1

Here is what you are looking for

http://www.bewebdeveloper.com/tutorial-about-autocomplete-using-php-mysql-and-jquery