get_players.php

<?php
header("Content-type: text/javascript");
$servername = "temp.mdsportsrd.com";
$username = "rafamod";
$password = "Raddil12!";
$dbname = "mdsportsdb";

$conn = mysqli_connect($servername, $username, $password, $dbname);
if(!$conn){
    die("Connection failed: " .mysqli_connecet_error());
}

$showData = "SELECT * FROM Players";
$data = array();
$result = mysqli_query($conn, $showData);

if(mysqli_num_rows($result) > 0){
    while($row = mysqli_fetch_assoc($result)){
        $data[] = $row;
    }
} else {
    echo "0 results";
};
echo json_encode($data, JSON_PRETTY_PRINT);
mysqli_close($conn);

?>