Fetch real time data in php

I want to fetch all user's name in a page from mysql and once clicked on a name their email id should be displayed in real time.

the new.php and email.php are given below:

asked Oct 29, 2017 at 7:54

10

Something like this [ -note- I didn't test this at all, but this is the basic idea ]

page.php

    
        
               function getLinks[]{
                    //use ajax to get the links
                    var xhttp = new XMLHttpRequest[];
                    xhttp.onreadystatechange = function[] {
                        if [this.readyState == 4 && this.status == 200] {   
                          document.getElementById["link_wrapper"].innerHTML = this.responseText;
                        }
                    };
                    xhttp.open["GET", "get_user_email.php", true];
                    xhttp.send[];
                }

                setInterval[ function[]{
                    //call getLinks every 5000 milliseconds
                    getLinks[];
                },5000];

                //call getLinks on page load
                window.onload = getLinks;
        
    
    
        

    

get_user_email.php

You might be interested in: How To Connect MySQL Database With PHP Websites

Next, I will create insert.php and simply insert new comments in MySQL through the following code: