获取PHP中MySQL列的总和

您可以在MySQL查询中完全处理它：

SELECt SUM(column_name) FROM table_name;

在PHP代码中，尝试以下操作：

$result = mysql_query('SELECt SUM(value) AS value_sum FROM pres'); $row = mysql_fetch_assoc($result); $sum = $row['value_sum'];

使用PDO（

mysql_query

$stmt = $handler->prepare("SELECt SUM(value) AS value_sum FROM pres");$stmt->execute();$row = $stmt->fetchAll(PDO::FETCH_OBJ);$sum = $row->value_sum;