php - 如何计算 PHPMyadmin DB 表中具有特定值（lke '1'）的列数？

Question

我有一个如下表，其中包含 3 列，值为“1”或“0”。

S.no 产品数量 1 数量2 数量3  
1. 肥皂 1 0 1
2. 球 1 1 0
3. 除臭剂 0 0 0
4. 黄油 1 0 1

我如何计算表格中“1”的总数，如上表中有 6 个？另外，如果我想计算只有“1”值的总行数怎么办？

<?php

if($_SERVER['REQUEST_METHOD']=='POST')
{
 include 'Config.php';

 $conn = mysqli_connect($HostName,$HostUser,$HostPass,$DatabaseName);

 if ($conn->connect_error) 
  die("Connection failed: " . $conn->connect_error);

// $sql = "SELECT SUM(Qty1 + Qty2 + Qty3) from Table"; doesn't seems to work


 $result = $conn->query($sql);

 if ($result=mysqli_query($conn,$sql))
  {
  // Return the number of rows in result set
  $rowcount=mysqli_num_rows($result);

  echo $rowcount;
  // Free result set
  mysqli_free_result($result);
  } 

 else
  echo "0";
}

 else
  echo "failed";

 $conn->close();

?>

标签： phpmysql

Answer 1

希望它有帮助...

SELECT
  sum(Qty1) as sum_Qty1
  , sum(Qty2) as sum_Qty2
  , sum(Qty3) as sum_Qty3
  , sum(Qty1) + sum(Qty2) + sum(Qty3) as tot_Qty 
FROM
  product