php - 将加权平均值添加到返回的mysql查询并将所有数据相加

Question

我对 php 比较陌生...我有两个查询通过另一个字段名称返回列的平均值。我需要为这些平均值添加权重，然后将结果相加以获得总分...我无法让它工作...以下是查询:

$engresults = $con->query("SELECT AVG(activity) as avgscore FROM combinedna WHERE coachname = '$coachname'");    
$timeresults = $con->query("SELECT AVG(timely) as avgtime FROM combinedna WHERE coachname = '$coachname'");

平均值返回正确，我可以向该函数添加权重，但无法将两者相加

while($row = $engresults->fetch_assoc()) {
    echo "<tr>";
    echo "<td>Did you identify an effective integrated activity?</td>";
    echo "<td><center>" .$row['avgscore'] *.05 . "</center></td>";
    echo "</tr>";
}

while($row = $timeresults->fetch_assoc()) {
    echo "<tr>";
    echo "<td>Did you spend the appropriate amount of time?</td>";
    echo "<td><center> " .$row['avgtime'] *.10 . "</center></td>";
    echo "</tr>";
}

我需要将 .05 添加到第一个，将 .10 添加到第二个，然后将结果加在一起......我只是不知道要使用的 PHP。预先感谢您的耐心和帮助

Answer 1

将值放入变量中，然后添加它们。

$row = $engresults->fetch_assoc(); // No loop needed
$avgscore_weighted = $row['avgscore'] * .05;
$row = $timeresults->fetch_assoc();
$avgtime_weighted = $row['avgtime'] * .10;
$weighted_sum = $avg_score_weighted + $avgtime_weighted;

echo "<tr>";
echo "<td>Did you identify an effective integrated activity?</td>";
echo "<td><center>" .$avgscore_weighted . "</center></td>";
echo "</tr>";

echo "<tr>";
echo "<td>Did you spend the appropriate amount of time?</td>";
echo "<td><center> " .$avgtime_weighted . "</center></td>";
echo "</tr>";

echo "<tr>";
echo "<td>The total was: </td>";
echo "<td><center> " .$weighted_sum . "</center></td>";
echo "</tr>";