Advertisement
Guest User

Untitled

a guest
Dec 6th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. <?php
  2. try
  3. { // connection à la base de données
  4. $bdd = new PDO('mysql:host=localhost;dbname=test3', 'root', '');
  5. }
  6. catch(Exception $e)
  7. {
  8. die('Erreur : '.$e->getMessage()); // En cas d'erreur, on affiche un message et on arrête tout
  9. }
  10. ?>
  11.  
  12. <!doctype html>
  13.  
  14. <html lang="fr">
  15. <head>
  16. <meta charset="utf-8">
  17.  
  18. <title>The HTML5 Herald</title>
  19. <style>
  20. @import url('https://fonts.googleapis.com/css?family=Bebas+Neue&display=swap');
  21. </style>
  22.  
  23. <link rel="stylesheet" href="style.css">
  24.  
  25. </head>
  26.  
  27. <body>
  28.  
  29. <h1>Choisir une <span>DATE </span>:)</h1>
  30.  
  31. <div class="date-picker">
  32. <form method="post">
  33.  
  34. <input type="date" name="date_naissance" placeholder="Ex: 1981-05-25" /><br />
  35.  
  36. <input type="time" id="appt" name="appt"> <br/>
  37. <br/>
  38. <input type="submit" value="OK"><br/>
  39. </form>
  40. </div>
  41. <?php
  42. $prenom = $_POST['date_naissance'];
  43.  
  44.  
  45.  
  46. $heure = $_POST['appt'];
  47.  
  48.  
  49.  
  50. $reponse = $bdd->query("SELECT * FROM capteur WHERE date_jour='$prenom'");
  51.  
  52. while ($donnees = $reponse->fetch())
  53. {
  54. ?>
  55. </br>
  56. <h1> <span>Valeur </span></h1>
  57. <div id="valeur_finale">
  58. <div id="final">
  59. <?php echo $donnees['date_jour']; echo "<br />"; ?> <?php echo $donnees['valeur']; ?>
  60. </div>
  61. </div>
  62. <?php
  63. }
  64. $reponse->closeCursor(); // Termine le traitement de la requête
  65.  
  66. ?>
  67.  
  68.  
  69.  
  70.  
  71. </body>
  72. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement