php - 对多列求和

Question

我的 MySQL 中存储了数字(付费)。我需要对列求和。

$sql= "SELECT SUM(furniture) FROM paid"; 
$stmt = $connect->prepare($sql);
$stmt->execute();
$furniture = (int) $stmt->fetchColumn();

$sql= "SELECT SUM(groceries) FROM paid"; 
$stmt = $connect->prepare($sql);
$stmt->execute();
$groceries = (int) $stmt->fetchColumn();

//so on....

数据库中有超过 50 列。我的问题是，是否有一种更短的编写方法，以便我可以获得每列的 SUM 并将其分配给一个变量？

Answer 1

尝试使用单个查询

$sql = "SELECT  SUM(`furniture`) AS sumFurniture, 
                SUM(`groceries`) AS sumGroceries ,
                ...
        FROM `paid` ";

结果可以用

$sth = $connect->prepare($sql);
$sth->execute();
$result = $sth->fetch();

$sumFurniture = $result['sumFurniture'];
$sumGroceries = $result['sumGroceries'];
....