Players currently online

Let's build out the code to get and show a list of players that are currently online. Here we write a JavaScript function that calls our PHP module to return a list of players that are logged in.

The JavaScript function is as follows:

function GetPlayersOnlineNow(){
var action='GetPlayersOnlineNow',Username='',  html="<table>";
$.ajax({
dataType: "json",
data: {action:action},
url: $AJAXHANDLER,
        success: function (data){
    for (var i = 0; i < data.length; i++) { 
    if(data[i].UserName==''){Username='Anonymous'}else{Username=data[i].UserName};
    html+='<tr><td><a href="#">'+Username +'</a></td></tr>';  
    }
    html+="</table>";
    $("#playersonlinenowdiv").append(html);
  },
        error: function (xhr, status, error) {
            alert(status + error + xhr.responseText);
        }
    });
  
}

The PHP code is as follows:

function GetPlayersOnlineNow(){
$storedProcedure = "Select  UserName from Player...