horaire-et-pointage.php (1c6ef26) - lbd.git

horaire-et-pointage.php

<?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());

}

lbd.git

horaire-et-pointage.php premier jet