<?php

include 'database.php';
$database = new Database();
$connexion = $database->getConnection();

if ($connexion) {
    $ok = "";
    $table = "";
    $choix2 = "";
    
    if(isset($_POST['valeurChoisie'])){
        $ok = $_POST['valeurChoisie'];
    };
    
    if(isset($_POST['choix2'])){
        $choix2 = $_POST['choix2'];
    }
    
    if(isset($_POST['table'])){
        $table = $_POST['table'];
        if($choix2 == "normal"){
            if($table == "povoa"){
                $table = "metro_b_2";
            }else{
                $table = "metro_b_1";
            }
        }
        if($choix2 == "sabados"){
            if($table == "povoa"){
                $table = "metro_b_3";
            }else{
                $table = "metro_b_4";
            }
        }
    };
    

    $sql = "SELECT `$ok` from `$table`";
    $statement = $connexion->prepare($sql);
    $statement->execute();
    
    $results = $statement->fetchAll(PDO::FETCH_ASSOC);
    foreach ($results as $row) {
            foreach ($row as $arret => $horaire) {
                        echo $horaire;
                        echo ",";
                    }

    }
}


?>