使用php从mysql获取% percentage

Question

也许这个问题太基本了，我找不到答案。

我有一个包含两个值的表。instructions |来自mysql的赋值。我希望获得指令对估值的%(百分比)价值。例如，10个预约/5个销售= 50%的转换率。总和为Sales / Appoints x 100 =%

你知道我该如何在html表的'percentage‘列中回显它吗？

$query = "SELECT * FROM office_figures2016";
$result = mysqli_query($conn, $query);

while($office_figures2016=mysqli_fetch_assoc($result)){

echo "<tr>";
        //changes date to english format from a time stamp
        echo"<td>".$office_figures2016['id_why']."</td>";

        echo"<td>".date('d-m-Y',strtotime($office_figures2016['date_figures']))."</td>";
        echo"<td>".$office_figures2016['valuations']."</td>";
        echo"<td>".$office_figures2016['instructions']."</td>";
        echo"<td>".$office_figures2016['percentage of above']."</td>";

Answer 1

 $query= "SELECT *, 
        concat(round(( instructions/valuations * 100 ),2),'%') AS percentage
    FROM office_figures2016";
    $result = mysqli_query($conn, $query);
        while($office_figures2016=mysqli_fetch_assoc($result)){

        //echo "$applicant_card[id].$applicant_card[first_name]";   //this echos  out a few columns = id and first_name


        echo "<tr>";
        //changes date to english format from a time stamp
        echo"<td>".$office_figures2016['id_why']."</td>";

        echo"<td>".date('d-m-Y',strtotime($office_figures2016['date_figures']))."</td>";
        echo"<td>".$office_figures2016['valuations']."</td>";
        echo"<td>".$office_figures2016['instructions']."</td>";
        echo"<td>".$office_figures2016['percentage']."</td>";
        echo"<td>".$office_figures2016['firsts']."</td>";


        echo "<td><a href='edit_figures.php?edit=$office_figures2016[id_why]'>Edit</a></td>";
        //echo "<td><a href='delete_applicant.php?id=$office_figures2016[id]'>x</a></td></tr>";

      }

Answer 2

您不应该创建这样的列-在数据库中有重复的值是不好的习惯。它是一个简单的值，所以你可以每次都计算它，例如：

SELECT a.a, a.b, (a/b) FROM a ORDER BY (a/b);

如果您真的想添加它，您可以简单地在phpMyAdmin中创建列，然后更新它的宽度

UPDATE A SET a_b=a/b