05. 프로젝트 연동

11:50 쿼리문 설명
25:00 새로 짜기
05. 프로젝트 연동

loadtop10player.php

$password = "1234";
$dbname = "PLAYER_Database";

// Create connection
$conn = new mysli($servername, $username, $password, $dbname);

// Check connection
if($conn->connect_error){
	die("Connection failed : ". $conn->connect_error);
}

$playername = $_POST['Name'];

$sql = "SELECT Name, Score FROM Player_Data ORDER BY Score DESC LIMIT 10";

echo $sql;

$result = $conn->query($sql);

$topPlayers = array();

if($result->num_rows>0)
{
	while($row = $result->fetch_assoc()){
    	echo $row["Name"]."-".$row["Score"];
    }
}
else
{
	echo "No Data Here";
}