<?php
require_once __DIR__ . '/User.php';



$User = User::getUser($_GET['id']);


header('Content-Type: text/csv'); //générer le téléchargement en csv
header('Content-Disposition: attachment; filename="Export Planning.csv'); //modifier le nom du csv
try {

    $PDO = new PDO('mysql:host=localhost;dbname=nowaste', 'root', '');
    $PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
    $PDO->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
} catch (PDOException $e) {
    echo 'Connexion impossible';
}

//echo $User['ID_Utilisateurs'];
$req = $PDO->prepare('SELECT id_planning, date, action, heure_debut, heure_fin, id_user FROM planning WHERE id_user= ? ');
$req->execute([$User['ID_Utilisateurs']]);
$data = $req->fetchAll();
//print_r($data);
?>"id_planning";"date (jj/mm/aaaa)";"action";"heure_debut";"heure_fin"
<?php
//echo $User['Prenom'];
foreach ($data as $d) {
    echo '"' . $d->id_planning . '";"' . $d->date . '";"' . $d->action . '";"' . $d->heure_debut . '";"' . $d->heure_fin.'"'. "\n";
} ?>