API tools faq
paste
Advertisement
Guest User

TPD

a guest
May 24th, 2018
150
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.32 KB | None | 0 0
raw download clone embed print report
  1. <!doctype html>
  2. <html lang="fr">
  3.  
  4.  
  5. <?php include("assets/header.php"); ?>
  6.  
  7.  
  8. <!--php include("assets/datemeteo.php"); ?> -->
  9. <?php include("assets/menu.php"); ?>
  10. <?php include("assets/meteo.php"); ?>
  11. <?php include("assets/meteo2.php"); ?>
  12.  
  13. <div id="bande_verticale"></div>
  14. <div id="bande_horizontale"></div>
  15. <body>
  16. <br>
  17. <br>
  18. <form method="POST" action="planning.php">
  19. <!-- Boucle permettant d'afficher un début et une fin de date automatiquement -->
  20. <?php echo "<center>";
  21. echo '<select name="année" class="autosubmit" id="selectannee" lang="fr" >';
  22. $annee=date("Y");
  23. echo '<option value="">--- Année ---</option>';
  24.  
  25. for ($anneedebut=2015; $anneedebut<=$annee ;$anneedebut++){
  26.  
  27. echo '<option value="'.$anneedebut.'">'.$anneedebut.'</option>'; }
  28. echo '</select>';
  29. ?>
  30. <!-- fin de la boucle
  31. code-ci dessous, code coder en dur -->
  32. <!--<option value="2018-"> 2018 </option>
  33. <option value="2019-"> 2019 </option>
  34. <option value="2020-"> 2020 </option>
  35. <option value="2021-"> 2021 </option>
  36. <option value="2022-"> 2022 </option>
  37. <option value="2023-"> 2023 </option>
  38. <option value="2024-"> 2024 </option>
  39. <option value="2025-"> 2025 </option>
  40. <option value="2026-"> 2026 </option>
  41. <option value="2027-"> 2027 </option>
  42. <option value="2028-"> 2028 </option>
  43. <option value="2029-"> 2029 </option>
  44.  
  45. <option value="fr" selected="selected" > --- année --- </option>
  46. </select>
  47. -->
  48.  
  49.  
  50. <select name="mois" class="autosubmit" dir="ltr" id="selectmois" lang="fr">
  51. <option value="-01-"> Janvier </option>
  52. <option value="-02-"> Février </option>
  53. <option value="-03-"> Mars </option>
  54. <option value="-04-"> avril </option>
  55. <option value="-05-"> Mai </option>
  56. <option value="-06-"> Juin </option>
  57. <option value="-07-"> Juillet</option>
  58. <option value="-08-"> Aout </option>
  59. <option value="-09-"> Septembre </option>
  60. <option value="-10-"> Octobre </option>
  61. <option value="-11-"> Novembre </option>
  62. <option value="-12-"> Decembre</option>
  63.  
  64. <option value="fr" selected="selected" > --- Mois --- </option>
  65. </select>
  66.  
  67. <select name="jour" class="autosubmit" dir="ltr" id="selectjour" lang="fr">
  68. <option value="1"> 1 </option>
  69. <option value="2"> 2 </option>
  70. <option value="3"> 3 </option>
  71. <option value="4"> 4 </option>
  72. <option value="5"> 5 </option>
  73. <option value="6"> 6 </option>
  74. <option value="7"> 7 </option>
  75. <option value="8"> 8 </option>
  76. <option value="9"> 9 </option>
  77. <option value="10"> 10 </option>
  78. <option value="11"> 11 </option>
  79. <option value="12"> 12 </option>
  80. <option value="13"> 13 </option>
  81. <option value="14"> 14 </option>
  82. <option value="15"> 15 </option>
  83. <option value="16"> 16 </option>
  84. <option value="17"> 17 </option>
  85. <option value="18"> 18 </option>
  86. <option value="19"> 19 </option>
  87. <option value="20"> 20 </option>
  88. <option value="21"> 21 </option>
  89. <option value="22"> 22 </option>
  90. <option value="23"> 23 </option>
  91. <option value="24"> 24 </option>
  92. <option value="25"> 25 </option>
  93. <option value="26"> 26 </option>
  94. <option value="27"> 27 </option>
  95. <option value="28"> 28 </option>
  96. <option value="29"> 29 </option>
  97. <option value="30"> 30 </option>
  98. <option value="31"> 31 </option>
  99.  
  100.  
  101. <option value="fr" selected="selected" > --- Jour --- </option>
  102. </select>
  103.  
  104. <input type="submit" name="valider" value=" Voir les rendez-vous pendant cette période " id="voirrdv"/>
  105. <a id="voirrdv2" type="button" href="planning.php" title="Bilan">voir la date d'aujourd'hui</a>
  106.  
  107.  
  108.  
  109. </form>
  110.  
  111. <br>
  112. <br>
  113.  
  114. <?php
  115. include("config/config.php");
  116. $total= date("Y-m-j");
  117.  
  118. if(isset($_POST['valider'])){
  119. $mois=$_POST['mois'];
  120. $annee=$_POST['année'];
  121. $jour=$_POST['jour'];
  122. $total=$annee.$mois.$jour;
  123. }
  124. $stmt = mysqli_stmt_init($mysqli);
  125.  
  126. if (mysqli_stmt_prepare($stmt, 'SELECT r.Dat,r.Time, r.idRDV, c.Nom, c.Prenom, c.Ville, c.Rue,c.idClient, c.code_postal, c.adresse_mail, c.Numero_telephone, r.Message, r.Accept FROM RDV r INNER JOIN Client c WHERE Dat = ? AND c.idClient = r.idRDV')){
  127.  
  128. /* Association des variables SQL */
  129. mysqli_stmt_bind_param($stmt,"s",$total);
  130.  
  131. /* Exécution de la requête */
  132. mysqli_stmt_execute($stmt);
  133.  
  134. /* Association des variables de résultats */
  135. mysqli_stmt_bind_result($stmt, $date,$heure, $idRDV, $nom, $prenom, $ville, $rue, $id_expediteur, $postal,$mail, $telephone, $message, $Accept) ;
  136.  
  137. /* Lecture des valeurs */
  138. while ($données=mysqli_stmt_fetch($stmt)){
  139. echo "<center>";
  140.  
  141. echo ' Nom du client : '.$nom.'<br>
  142. Prénom du client : '.$prenom.'<br>
  143. Adresse du client : '.$ville.' '.$rue.'<br>
  144. Code postal : '.$postal.'<br>
  145. Telephone : '.$telephone.'<br>
  146. E-mail : '.$mail.'<br><br>
  147. Date du rendez-vous : <b>'.$date.' </b><br>
  148. Heure du rendez vous : <FONT color="red"> '.$heure.' </FONT> <br> <br>
  149. Commentaire : <br> <br> '.wordwrap($message, 100, "<br />\n").'<br><br>';
  150.  
  151.  
  152. if ($Accept == 0){
  153. echo "Etat du rendez-vous : <font color=orange>En cours </font>
  154. <form method='POST' action='planning.php'>
  155. <select name='etat' class='autosubmit' dir='ltr' id='etat' lang='fr'>
  156. <option value='0'> en attente </option>
  157. <option value='1'> valider </option>
  158. <option value='2'> refuser </option>
  159. <input type='submit' name='buttonValider' value='Valider' />
  160. </form>
  161. </select>";
  162.  
  163. }
  164.  
  165. elseif($Accept == 1){
  166. echo "Etat du rendez-vous : <font color=green> Valider </font>
  167. <form method='POST' action='planning.php'>
  168. <select name='etat' class='autosubmit' dir='ltr' id='etat' lang='fr'>
  169. <option value='0'> en attente </option>
  170. <option value='1'> valider </option>
  171. <option value='2'> refuser </option>
  172. <input type='submit' name='buttonValider' value='Valider' />
  173. </select>";
  174. }
  175.  
  176. elseif($Accept == 2){
  177. echo "Etat du rendez-vous : <font color=red> refuser </font>
  178. <form method='POST' action='planning.php'>
  179. <select name='etat' class='autosubmit' dir='ltr' id='etat' lang='fr'>
  180. <option value='0'> en attente </option>
  181. <option value='1'> valider </option>
  182. <option value='2'> refuser </option>
  183. <input type='submit' name='buttonValider' value='Valider' />
  184. </select>";
  185.  
  186. }
  187.  
  188.  
  189.  
  190.  
  191. else{
  192. echo "Etat du rendez-vous : <font color=blue> Erreur </font>
  193. <form method='POST' action='planning.php'>
  194. <select name='etat' class='autosubmit' dir='ltr' id='etat' lang='fr'>
  195. <option value='0'> en attente </option>
  196. <option value='1'> valider </option>
  197. <option value='2'> refuser </option>
  198. <input type='submit' name='buttonValider' value='Valider' />
  199. </select>";
  200. }
  201. echo "<br>";
  202.  
  203. echo "<b>____________________________________________________________________________________________________<br><br></b>";
  204. echo "</center>";
  205.  
  206.  
  207.  
  208.  
  209. }
  210. /* Fermeture de la commande */
  211.  
  212. }
  213.  
  214. /* Fermeture de la connexion */
  215. /*mysqli_close($mysqli)*/;
  216.  
  217. ?>
  218.  
  219. <?php
  220. /*if(isset($_POST['etat'])) {
  221.  
  222. $Accept = $_POST['etat'];
  223. echo " ".$nom. "";
  224. $requpertation_info = $bdd->prepare('UPDATE RDV SET Accept ="'.$Accept.'"WHERE Client_idClient = (SELECT idClient FROM Client WHERE Nom ="Rabadon")');
  225. $requpertation_info->execute();*/
  226. if(isset($_POST['etat'])) {
  227.  
  228. $Accept = $_POST['etat'];
  229.  
  230.  
  231. //update
  232. $stmt2 = $mysqli->prepare('UPDATE RDV SET Accept=? WHERE
  233. Client_idClient = (SELECT idClient FROM Client WHERE idClient= idRDV)');
  234. $stmt2->bind_param('i', $Accept);
  235. $stmt2->execute();
  236. $stmt2->close();
  237. echo "<font color=blue> <b>Votre modification à bien été prise en compte ! </b></font>";
  238.  
  239.  
  240.  
  241.  
  242. //if (mysqli_stmt_prepare($stmt,'UPDATE RDV SET Accept ="'.$Accept.'"WHERE Client_idClient = (SELECT idClient FROM Client WHERE Nom ="$nom")')){
  243.  
  244. /* Association des variables SQL */
  245. //mysqli_stmt_bind_param($stmt,"s",$Accept);
  246.  
  247. /* Exécution de la requête */
  248. //mysqli_stmt_execute($stmt);
  249.  
  250. /* Lecture des valeurs */
  251. //while ($données=mysqli_stmt_fetch($stmt)){
  252. echo "<center>";
  253. }
  254. mysqli_stmt_close($stmt);
  255.  
  256. mysqli_close($mysqli);
  257. ?>
  258. <br>
  259. <br>
  260.  
  261. <img id="outil" src="images/logoadmin.png" alt="Logo d'administration" class="logoadmin" />
  262.  
  263. </body>
  264.  
  265.  
  266. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!