fetch_mes.php

<?php
include 'conexion.php';

$periodo = $_POST['periodo'];
$mes = $_POST['mes'];
$data = array();

if ($periodo == 'diario') {
    $sql = "SELECT DATE(fecha) as fecha, promedio_pm10, promedio_pm25, estado FROM promedio_sds011 WHERE DATE_FORMAT(fecha, '%Y-%m') = '$mes' GROUP BY DATE(fecha)";
} else if ($periodo == 'mensual') {
    $sql = "SELECT DATE_FORMAT(hora_inicio, '%Y-%m') as fecha, AVG(prom_pm10) as promedio_pm10, AVG(prom_pm25) as promedio_pm25 FROM prom_sds011 GROUP BY DATE_FORMAT(hora_inicio, '%Y-%m')";
}

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

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $data[] = $row;
    }
}

echo json_encode($data);

$conn->close();
?>