<?php
	$servername = "127.0.0.1";
	$username = "root";
	$password = "maiyeuem";
	$dbname = "skywars";

	$ketnoi = new mysqli($servername, $username, $password, $dbname);
	if($ketnoi->connect_error){
		echo ("Kết nối không thành công". $ketnoi->connect_error);
	}
	$top = 1;
?>
<style>
.tablec{
    border-collapse: collapse;
}
th, td {
    padding: 8px;
    text-align: left;
    border-bottom: 1px solid #ddd;
}
img {
  vertical-align: middle;
}
tr:nth-child(even){background-color: #d2a679}
th{background-color: #996633}
</style>

<table class="tablec">
  <tr>
    <th>Top</th>
    <th style="width:150px">Name</th>
    <th>Giết</th>
  </tr>
  <?php
  $sql = "SELECT * FROM skywar_data ORDER BY kills LIMIT 10";
  $que = mysqli_query($ketnoi,$sql);
  while($data=mysqli_fetch_assoc($que)){
	  $id = $data['id'];
	  $username = $data['username'];
	  $kills = $data['kill'];
  ?>
  <tr>
    <td><?php echo $top++; ?></td>
    <td><img src="https://mcapi.ca/avatar/2d/<?php echo $username; ?>/22"> <?php echo $username; ?></td>
    <td><?php echo $kills; ?></td>
  </tr><?php } ?>
</table>