<?php
//
try {

  $pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
  $bdd = new PDO(
    'mysql:host=localhost;dbname=ntnlvca_wplbd',
    'david',
    'kt3;Dv2?Wan9f/',
    $pdo_options
  );

  $bdd -> exec("SET CHARACTER SET utf8");

  $req = $bdd -> prepare('SELECT post_date, meta_value
    FROM wplg_posts
    INNER JOIN wplg_postmeta ON ID = post_id
    WHERE post_type = "sp_event"
      AND DATE_FORMAT(post_date,"%Y-%m-%d") = DATE_FORMAT("2021-09-19","%Y-%m-%d") # CURRENT_DATE()
      AND meta_key IN ("sp_team","sp_results")
    ORDER BY post_date;'
    );

  $req -> execute();
  $results = $req -> fetchAll(PDO::FETCH_ASSOC);

  $display = ($results)
    ? var_dump($results)
    : "Pas de matchs à l'horaire aujourd'hui.";

  echo $display;

  // Boucle pour parcourir la table des résultats
  /*
  while ($donnees = $req_donneesensg -> fetch()) {

  }
  */

  // Fermeture de la requête et de la base de données
  $req -> closeCursor();
  $bdd = null;

}

catch(Exception $e) {

  die('Erreur : '.$e -> getMessage());

}

?>