SQL/PHP代码-获取每个月的值的总和

SELECT MONTH(date_column) AS month, SUM(value_column) AS total_value
FROM table_name
GROUP BY MONTH(date_column)
ORDER BY MONTH(date_column);

<?php
// 连接数据库
$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 执行SQL查询
$sql = "SELECT MONTH(date_column) AS month, SUM(value_column) AS total_value
        FROM table_name
        GROUP BY MONTH(date_column)
        ORDER BY MONTH(date_column)";

$stmt = $conn->prepare($sql);
$stmt->execute();

// 处理查询结果
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($result as $row) {
    $month = $row['month'];
    $totalValue = $row['total_value'];
    echo "Month: $month, Total Value: $totalValue\n";
}

// 关闭数据库连接
$conn = null;
?>