多个条目 - PHP 中的计数值

Question

谢谢朋友们的帮助和反馈。我知道我不擅长 PHP，但仍在尝试学习和使用它：D——我的表包含针对 evaid 作为 Open Close 或 In Process 的重复条目——使用下面的代码，我从 DB 中获得了每个条目的最后输入状态通过使用查询和 if 语句来显示数据的状态，但我也想获取它的计数。任何人都可以帮助我---例如---

$sql = "SELECT * FROM (SELECT * FROM disagreements ORDER BY addeddate DESC) disagreements  GROUP BY evaid";

$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) { 

    while($row = mysqli_fetch_assoc($result))  {   // Here with this query I got last entered status of each row against evaid – as 2 Open – 5 in Process and 10 Closed --- with below if statement – I can echo the rows with status but I want to have count of it that how many are open, in process or closed

        if($row["status"]=='Open') {  // I want to count this value as 2        

            echo "<tr>";

            echo "<td>" . $row["evaid"]. "</td>";

            echo "<td>" . $row["status"]. "</td>";

            echo "</tr>";

        } 

    }

} else {

    echo "Nothing to Display";

}

mysqli_close($conn);

Answer 1

// Hii.. 你可以从你的 SQL 查询中得到一个计数，试试这个$sql = "SELECT *, COUNT(ID) AS COUNT FROM (SELECT * FROM disagreements ORDER BY addeddate DESC) disagreements&nbsp; GROUP BY evaid";$result = mysqli_query($conn, $sql);if (mysqli_num_rows($result) > 0)&nbsp;{&nbsp;&nbsp; &nbsp; while($row = mysqli_fetch_assoc($result))&nbsp;&nbsp; &nbsp; {&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; if($row["status"]=='Open')&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;echo "<tr>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;echo "<td>" . $row['count'] . "</td>"; // here you will get a count&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;echo "<td>" . $row["evaid"]. "</td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;echo "<td>" . $row["status"]. "</td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;echo "</tr>";&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; }&nbsp;&nbsp;else&nbsp;{&nbsp; &nbsp; echo "Nothing to Display";}mysqli_close($conn);

Answer 2

<?php&nbsp;$count['open']&nbsp; &nbsp; = 0;$count['close']&nbsp; &nbsp;= 0;$count['process'] = 0;while($row = mysqli_fetch_assoc($result))&nbsp; {&nbsp; &nbsp;&nbsp; &nbsp; if($row["status"]=='Open')&nbsp;&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $count['open']++;&nbsp; &nbsp; &nbsp; &nbsp; echo "<tr>";&nbsp; &nbsp; &nbsp; &nbsp; echo "<td>" . $row["evaid"]. "</td>";&nbsp; &nbsp; &nbsp; &nbsp; echo "<td>" . $row["status"]. "</td>";&nbsp; &nbsp; &nbsp; &nbsp; echo "</tr>";&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; if($row["status"]=='Close')&nbsp;&nbsp; &nbsp; {&nbsp; // I want to count this value as 2&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; $count['close']++;&nbsp; &nbsp; echo "<tr>";&nbsp; &nbsp; echo "<td>" . $row["evaid"]. "</td>";&nbsp; &nbsp; echo "<td>" . $row["status"]. "</td>";&nbsp; &nbsp; echo "</tr>";&nbsp; &nbsp; }&nbsp;if($row["status"]=='Process')&nbsp;{&nbsp; // I want to count this value as 2&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; $count['process']++;&nbsp; &nbsp; echo "<tr>";&nbsp; &nbsp; echo "<td>" . $row["evaid"]. "</td>";&nbsp; &nbsp; echo "<td>" . $row["status"]. "</td>";&nbsp; &nbsp; echo "</tr>";}}print_r($count);?>