如何在HTML中回显来自php中的mysqli_multi_query的值

Question

当使用mysqli_multi_query.But时，我能够从数据库中获得显示的值，我无法在HTML中打印，这可能是when循环的问题。下面是我的代码，它为三个SQL语句提供了AVG。唯一的问题是在HTML中显示平均值。

<?php
    $con = new mysqli("localhost", "root","","survey");
    if ($con){ printf(""); }

    $query  = "SELECT AVG(workarea) FROM score;" ;
    $query .= "SELECT AVG(manager) FROM score;";
    $query .= "SELECT AVG(comm) FROM score;";

    // Execute multi query
    if (mysqli_multi_query($con,$query)) {
        do {
            if ($result=mysqli_store_result($con)) {
                // Fetch one and one row
                while ($row=mysqli_fetch_row($result)) {
                    printf("%s\n",$row[0]);
                }

                // Free result set
                mysqli_free_result($result);
            }
        } while (mysqli_next_result($con));
    }
?>
<div class="row count">
WORK AREA/UNIT SCORE : <?php echo $row[0]; ?> // echo $row[AVG(workarea)]  doesnot work
</div>

<div class="row count">
SUPERVISOR/MANAGER SCORE : <?php echo $row[0]; ?> // echo $row[AVG(manager)]     
</div>

<div class="row count">
COMMUNICATION SCORE : <?php echo $row[0]; ?> // echo $row[AVG(comm)] doesnot work
</div>

Answer 1

不需要多个查询，只需在单个查询中获得AVG。并将html写入while循环中，如

 $con = new mysqli("localhost", "root", "", "survey");
if ($con) {
    printf("");
}
$query = "SELECT AVG(workarea),AVG(manager),AVG(comm) FROM score;";
// Execute multi query
if ($result = $con->query($query)) {

    /* fetch object array */
    while ($row = $result->fetch_row()) {
        ?>
        <div class="row count">
            WORK AREA/UNIT SCORE : <?php echo $row[0]; ?> 
        </div>

        <div class="row count">
            SUPERVISOR/MANAGER SCORE : <?php echo $row[1]; ?>    
        </div>

        <div class="row count">
            COMMUNICATION SCORE : <?php echo $row[2]; ?> 
        </div>
        <?php
    }

    /* free result set */
    $result->close();
}