<?php

class Database {
    private $host = "localhost"; 
    private $db_name = "carpe_sae"; 
    private $username = "carpe_php"; 
    private $password = "onestdestubesonestpasdespots"; 
    private $conn;

    public function getConnection() {
        $this->conn = null;

        try {
            $this->conn = new PDO(
                "mysql:host=" . $this->host . ";dbname=" . $this->db_name,
                $this->username,
                $this->password
            );
            $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 
        } catch (PDOException $exception) {
            echo "Erreur de connexion : " . $exception->getMessage();
        }

        return $this->conn;
    }
}

$database = new Database();
$connexion = $database->getConnection();

if ($connexion) {
    
    if(isset($_POST['cause'])){
        $cause = $_POST['cause'];
        
        if($cause == "mois"){
            $sql = "SELECT MMAR,COUNT(*) as compte FROM `marriages` GROUP BY MMAR ORDER BY MMAR";
            $statement = $connexion->prepare($sql);
            $statement->execute();
                    
            $results = $statement->fetchAll(PDO::FETCH_ASSOC);
            foreach ($results as $row) {
                echo $row['MMAR'];
                echo ",";
                echo $row['compte'];
                echo ".";
            }
        }
        
        if($cause == "jour"){
            $sql = "SELECT JSEMAINE,COUNT(*) as compte FROM `marriages` GROUP BY JSEMAINE ORDER BY JSEMAINE";
            $statement = $connexion->prepare($sql);
            $statement->execute();
                    
            $results = $statement->fetchAll(PDO::FETCH_ASSOC);
            foreach ($results as $row) {
                echo $row['JSEMAINE'];
                echo ",";
                echo $row['compte'];
                echo ".";
            }
        }
    }
    
    

}

?>