Retrieve data from mysql based on select option

<script>
function showUser(str)
{
if (str=="")
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  } 
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getuser.php?q="+str,true);
xmlhttp.send();
}
script>


<form>
<select name="staff" onchange="showUser(this.value)">
 value="">Select Staff
 value="Ms.Shakthi">Ms.Shakthi
 value="Ms.Priya">Ms.Priya
select>
form>


 id="txtHint">Person info will be listed here.

Getuser.php code

php
$q = intval($_GET['q']);

$con = mysqli_connect('localhost','willy','12345','test');
if (!$con)
  {
  die('Could not connect: ' . mysqli_error($con));
  }

mysqli_select_db($con,"test");
$sql="SELECT * FROM test WHERE Staff = '".$q."'";

$result = mysqli_query($con,$sql);

echo "";while($row = mysqli_fetch_array($result)){
  echo "";
  echo "


Name
Class
Syllabus
Motivated
Time
Doubts
Marking
Interesting
Methods



  
" .
                                            

                                                

                                                                                                        
                                                    
                                                
                                                

                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares
                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp
    


                                                        
                                                    
                                                
                                            

                                            

                                                                                            

                                        
                                    
                                                                    
                                

                                                                    

                                

                                    
                                    
                                
                                                                                                                
                                                                                                                             

                        
                                        

                    

                        

                            
No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that
                                you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice
                                sessions to improve your knowledge and scores.
                        
                    
                    

                    

                    


                    

                    

                        
                        
                    
                    
                    

                                                

                                

                                    
Similar Forum
                                    

                                
                                

                            
                            

                                
                               
                                                                            

                                            

                                                    

                                                        

                                                            

                                                                Q
                                                            
                                                            

                                                                
Neet 2019 syllabus will change?
                                                                  
                                                            
                                                                
                                                            
                                                        
                                                    

                                                
                                            
                                        
                                                                            

                                            

                                                    

                                                        

                                                            

                                                                Q
                                                            
                                                            

                                                                
Syllabus in LaTeX
                                                                  
                                                            
                                                                
                                                            
                                                        
                                                    

                                                
                                            
                                        
                                                                            

                                            

                                                    

                                                        

                                                            

                                                                Q
                                                            
                                                            

                                                                
Does Hogwarts follow any specific syllabus for DADA?
                                                                  
                                                            
                                                                
                                                            
                                                        
                                                    

                                                
                                            
                                        
                                                                    
                                

                                    View All
                                
                            
                         
                        
                            

                                

                                    

                                        
Explore Other Libraries
                                        

                                    
                                    

                                
                                
                                    



        
            
 Online Exams
            
            
 Question Bank
            
            
Career News
            
            
Feeds
            
            
 Full Forms
                  
 Dictionary
                  
 Interview Question
         

            
 Gigs
        
            
 Quotes
        
            
 Lyrics
        
            
 Videos
        
            
 Courses
        
            
 Blogs
       
            
 Tutorials
         
            
 Forum
        
            
 Educators
        
            
 Corporates
        
            
 Tools
                                      

                                

                                    

                                        

                                            
Related Searches
                                            

                                        
                                        


                            
                                        Course Queries                                            Syllabus Queries                                     
                                
                            
                        
                    

                    

                        
                        
                    
                

                

            

        

            
Important Course Queries Links

                            

                    
                        
                            
                            Syllabus Queries
                        
                    
                
                            

                    
                        
                            
                            Competitions/Entrance Exams
                        
                    
                
                    
    

            

            
            
                
                

                    

                    

                    

                
            
            

        
        

    
    


    

        

            

                
                    ×
                
                

                    
                
            
            

                
Please allow ads on our site
                
Kindly log in to use this feature. We’ll take you to the login page automatically.
                
                Login
            
        
    


    

    

    

    

    

   
    
    
    

        
    

   
    
        
    
   
    
    
    
            
        
        
        
        
        
        

    




    

    

    

        

            

                

                    

                        

                            
                        
                    
                    

                        

                            
Join Our Community Today
                            
Ready to take your education and career to the next level? Register today and join our
                                growing community of learners and professionals.
                            

                                                                

                                    
                                    
                                        Please complete the CAPTCHA.
                                    
                                    
                                        Subscribe Now
                                
                            
                        
                    
                    

                        

                            
                        
                    
                
            
        
    




    

        

            


                
            
            

                


                

            
        
    



    



    

  
      


    

    

        

            

                Your experience on this site will be improved by allowing cookies.
                Read Cookie Policy
            

            

                
                    Reject
                
                
                    Allow cookies
                
            
        
    

    

            
    
    
    
    

    
            
        
    


    

    

        

            

                Your experience on this site will be improved by allowing cookies.
                Read Cookie Policy
            

            

                
                    Reject
                
                
                    Allow cookies