PHP Ajax Display Dynamic MySQL Data in Bootstrap Modal

Today, We want to share with you PHP Ajax Display Dynamic MySQL Data in Bootstrap Modal.In this post we will show you how to display data from database in php using ajax?, hear for Bootstrap Modal with Dynamic MySQL Data using Ajax & PHP we will give you demo and example for implement.In this post, we will learn about Loading Dynamic Content on a Bootstrap Modal using jQuery with an example.

PHP Ajax Display Dynamic MySQL Data in Bootstrap Modal

There are the Following The simple About PHP Ajax Display Dynamic MySQL Data in Bootstrap Modal Full Information With Example and source code.

As I will cover this Post with live Working example to develop Dynamically load content in Bootstrap Modal with AJAX, so the php ajax insert data in mysql by using bootstrap modal for this example is following below.

Step 1 : Create a MySQL TABLE and Dumping Data

tbl_leader

--  
 -- Table structure for table `tbl_leader`  
 --  
 CREATE TABLE IF NOT EXISTS `tbl_leader` (  
  `id` int(11) NOT NULL AUTO_INCREMENT,  
  `name` varchar(50) NOT NULL,  
  `person_types` text NOT NULL,  
  `gender` varchar(10) NOT NULL,  
  `designation` varchar(100) NOT NULL,  
  `age` int(11) NOT NULL,  
  PRIMARY KEY (`id`)  
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;  
 --  
 -- Dumping data for table `tbl_leader`  
 --  
 INSERT INTO `tbl_leader` (`id`, `name`, `person_types`, `gender`, `designation`, `age`) VALUES  
 (1, 'Narendra Modi', 'Mann ki Baat and periodic public person_typeses to children', 'Male', 'Prime Minister’s', 36),  
 (5, 'AMIT Shah', 'the BJP pulled off a win in Gujarat ', 'male', 'Despite anti-incumbency', 24),  
 (6, 'Dipak Misra', ' set to retire on October 2. With many former judges, CA 90017', 'Female', 'post-retirement ', 26),  
 (7, 'Mohan Bhagwat', 'Despite speculation that the BJP has grown too big for the RSS', 'Male', 'RSS', 32),  
 (8, 'SoNIA GANDHI', 'Mamata and old warhorse Pawar, OH 45202', 'Male', 'political ', 29),  
 (9, 'Mamata Banerjee', 'increased her tally from the 2016 Assembly polls', 'Male', 'mass leader in West Bengal', 33),  
 (10, 'RajNATH SINGH', 'credited with paving the way for a dialogue', 'Female', 'Intelligence Bureau chiefDineshwar', 27),  
 (11, 'Arjun JAITLEY', 'Revenue collections from GST and a higher growth trajectory', 'Female', 'Punjab National Bank scandal', 29),  
 (12, 'Yogi ADITYANATH', 'Despite the massive setback in the Gorakhpur and Phulpur Lok Sabha', 'Female', 'Deputy Chief Minister Keshav Prasad Maurya', 25),  
 (13, 'Mukesh Ambani', 're-entry into the telecom business through Jio', 'Female', 'world’s richest puts', 26),  
 (14, 'Rahul Gandhi', 'Gandhi has positioned himself as a challenger to PM Modi', 'Male', 'Congress chief', 30),  
 (15, 'NITIN GADKARI', 'the Delhi-Meerut Expressway', 'Female', 'Motor Vehicles Bill', 22),  
 (16, 'MAYAVATI', ' Samajwadi Party’s, 9 MLAs in the 403-member UP Assembly', 'Male', 'BSP, in the bypolls', 35),  
 (17, 'Akhilesh Yadav', 'support for SP candidates in return for support in the Rajya Sabha', 'Male', ' BSP chief Mayawati to formally', 21),  
 (18, 'Lalu Prashad', 'Lalu now in jail, Tejashwi has stepped up, shouldering charge of the party', 'Female', 'politician', 23),  
 (19, 'Virat Kohli's', 'World Top 1st Ranking in Cricket Worlds', 'Male', 'Cricketer', 28);  

Step 2 : Main HTML interface View Files

index.php

jquery Ajax Loaded Bootstrap Modal with PHP & MySQL

  
   
   
        
             
             
             
             
        
        
           

  
           
  
                
Bootstrap Modal with Dynamic MySQL Data using Ajax & PHP - Pakainfo.com
  
                
  
                
  
                     
  
                          
  
                               
Leader Name
  
                               
View
  
                          
  
                            
                          
  
                               
  
                               
" class="btn btn-info btn-xs Leader_data" />
  
                          
  
                            
                     
  
                
  
           
  
        
   
 
  
      
  
           
  
                
  
                     ×  
                     
Leader Details
  
                
  
                
  
                
  
                
  
                     Close  
                
  
           
  
      
  
 
  
 

Step 3 : PHP Get Dynamic MySQL Data

select.php

  
           ';  
      while($dataleaders = mysqli_fetch_array($result))  
      {  
           $results .= '  
                  
                ';  
      }  
      $results .= "
  
                     
Leader Name
  
                     
'.$dataleaders["name"].'
  
                
  
                
  
                     
Leader Types
  
                     
'.$dataleaders["person_types"].'
  
                
  
                
  
                     
Gender of Leader
  
                     
'.$dataleaders["gender"].'
  
                
  
                
  
                     
Leader Designation
  
                     
'.$dataleaders["designation"].'
  
                
  
                
  
                     
Age of Leader
  
                     
'.$dataleaders["age"].' Year