Ajax Live Data Search Using Jquery Php Mysql

Today, We want to share with you ajax live data search using jquery php mysql.In this post we will show you php mysql ajax search autocomplete, hear for ajax search box php mysql like google.

ajax live search jquery

Contents

we will give you demo and example for implement.In this post, we will learn about PHP AJAX Live Search Box Autocomplete Using MySQL Database with an example.

Step 1: Create the members’ table in MySQL:

CREATE TABLE `members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `mail_address` varchar(80) NOT NULL,
  `membername` varchar(45) DEFAULT NULL,
  `cell_phone` varchar(50) DEFAULT NULL,
  `bio` text,
  `profile_pic` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`name`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Step 2: Create Connection(config.php)

Step : 3 index.php




    
        Live Demo: Ajax live data search using PHP and MySQL
        
        
        
              
        
    
    
          
            
                Live Demo: Ajax live data search using PHP and MySQL
                
                    
                    
                        
                            
                                Name
                                Email
                                Membername
                                Mobile No.

Step 4: getData.php

num_rows > 0) {
        while ($row = mysqli_fetch_array($query)) {
            $output .= '
    ' . $row['name'] . '
    ' . $row['mail_address'] . '
    ' . $row['membername'] . '
    ' . $row['cell_phone'] . '
  ';
        }
    } else {
        $output = '
  
     No result found.    
  ';
    }
    echo $output;
}
?>

I hope you get an idea about ajax live data search using jquery php mysql.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.