php - 如何计算电脑游戏中的击杀/死亡率？

Question

我需要我的电脑游戏从用户总数中获取所有杀戮和死亡，然后将杀戮除以死亡，然后将总数放在最后。这个比率被称为它们的杀灭比，或“KDR”。

 <?php
   // Create connection
   $con=mysqli_connect("ipaddress","user","password","minecraft");

   // Check connection
   if (mysqli_connect_errno()) {
     echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }
   $result = mysqli_query($con,"SELECT *, `kills`/`deaths` as `KDR` FROM war_kills ``ORDER BY kills DESC");




   echo "<table border='1'>
   <tr>
   <th>Player</th>
   <th>Kills</th>
   <th>Deaths</th>
   <th>KDR</th>
   </tr>";

   while($row = mysqli_fetch_array($result)) {
     echo "<tr>";
     echo "<td>" . $row['player'] . "</td>";
     echo "<td>" . $row['kills'] . "</td>";
     echo "<td>" . $row['deaths'] . "</td>";
     echo "<td>" . $row['KDR'] . "</td>";

     echo "</tr>";
   }

   echo "</table>";
   ?>

到目前为止我们已经准备好了:http://gexgaming.com/warstats/index.php

Answer 1

从中更改查询

SELECT player, kills, deaths, KDR FROM war_kills ORDER BY kills DESC` 

到

SELECT player, kills, deaths, kills / deaths as KDR FROM war_kills ORDER BY kills DESC`