Advertisement
nicolas-chuet

modifier.php

Apr 23rd, 2020
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.43 KB | None | 0 0
  1. <?php
  2. $mysqli = new mysqli('localhost', 'root', '', 'base_test_modal') or die('die');
  3. if(isset($_POST['submit'])){
  4. $id = $_POST['id'];
  5. $title = $_POST['title'];
  6. $text = $_POST['text'];
  7. $urls = $_POST['url'];
  8. $i = (int)$_POST['id'];
  9. $idR=[];
  10. if (verifTitle($title) && verifText($text)){
  11. $idRequest=$mysqli->query('SELECT `id` FROM `domain` WHERE `domain`.`id_text_modal` = '.$i);
  12. while ($iR = $idRequest->fetch_object())
  13. {
  14. array_push($idR,$iR->id);
  15. }
  16. if (verifurl($urls)) {
  17. if (update($mysqli, $urls, $text, $title, $id))
  18. {
  19. delete($mysqli, $idR);
  20. header("Location: http://demo.local?tag=modifiersuccess");
  21. }
  22. echo "erreur lors de la mise a jour";
  23. }
  24. }
  25. }
  26. $modalRequest = $mysqli->query('SELECT * FROM `modal` WHERE `modal`.`id` = '.mysqli_real_escape_string($mysqli, $_REQUEST['id']));
  27. $modal = $modalRequest->fetch_object();
  28. $urlsRequest = $mysqli->query('SELECT * FROM `domain` WHERE `domain`.`id_text_modal` = '.$modal->id);
  29. $formUrl=[];
  30. while ($url = $urlsRequest->fetch_object())
  31. {
  32. array_push($formUrl,$url->url);
  33. }
  34. ?>
  35. <!DOCTYPE html>
  36. <html lang="en">
  37. <head>
  38. <meta charset="UTF-8">
  39. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  40. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css">
  41. <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js"></script>
  42. <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"></script>
  43. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
  44. <script>
  45. $( document ).ready(function() {
  46. $( "#addUrl" ).bind( "click", function( event ) {
  47. $("#divUrl").append('<input type="text" name="url[]" /><br/>');
  48. });
  49. })
  50. </script>
  51. </head>
  52. <body>
  53. <div class="container">
  54. <?php
  55. $modalTitle=$modal->title;
  56. $modalText=$modal->text_modal;
  57. if (!empty($_POST)){
  58. $modalTitle=$_POST['title'];
  59. $modalText=$_POST['text'];
  60. }
  61. ?>
  62. <form class="form-group" action="" method="POST">
  63. TITLE MODAL: <input class="form-control" type="text" name="title" value="<?php echo $modalTitle; ?>"/><br/>
  64. TEXT MODAL: <textarea class="form-control" name="text"><?php echo $modalText; ?></textarea><br/>
  65. <?php
  66. if (!empty($_POST)) {
  67. $formUrl= $_POST['url'];
  68. }
  69. foreach ($formUrl as $url){
  70. ?>
  71. URL MODAL: <input class="form-control" type="text" name="url[]" value="<?php echo $url; ?>"/><br/><br/>
  72. <?php
  73. }
  74. ?>
  75. <input type="hidden" name="id" value="<?php echo $modal->id; ?>">
  76. <input class="btn btn-outline-secondary" type="button" value="Ajouter une url" id="addUrl">
  77. <div id="divUrl"></div>
  78. <input class="btn btn-primary" type="submit" name="submit" value="soumettre"><br/>
  79. </form>
  80. </div>
  81. </body>
  82. <?php
  83. function verifTitle($title)
  84. {
  85. if ($title=="")
  86. {
  87. echo" il y a un erreur dans le champ Titre";
  88. return false;
  89. }
  90. return true;
  91. };
  92. function verifText($text)
  93. {
  94. if ($text=="")
  95. {
  96. echo" il y a un erreur dans le champ Text";
  97. return false;
  98. }
  99. return true;
  100. };
  101. function verifurl($urls)
  102. {
  103. foreach ($urls as $url)
  104. {
  105. if (!filter_var($url, FILTER_VALIDATE_URL))
  106. {
  107. echo "il y a une erreur dans l url saisi";
  108. return false;
  109. }
  110.  
  111. }
  112. return true;
  113. };
  114. function update($mysqli,$urls,$text,$title,$id)
  115. {
  116. foreach ($urls as $url)
  117. {
  118. $stmt = $mysqli->prepare("INSERT INTO `domain` (`url`, `id_text_modal`) VALUES (?,?) ");
  119. $stmt->bind_param('ss', $url, $id);
  120. $stmt->execute();
  121. }
  122. $stmt2 = $mysqli->prepare("UPDATE `modal` SET `text_modal`=?, `title`=? WHERE `id` =? ");
  123. $stmt2->bind_param('ssi', $text, $title, $id);
  124. $stmt2->execute();
  125. $stmt->close();
  126. $stmt2->close();
  127. return true;
  128. };
  129. function delete($mysqli,$idR)
  130. {
  131. foreach ($idR as $id) {
  132. $i=(int)$id;
  133. $stmt = $mysqli->prepare("DELETE FROM `domain` WHERE `id`=?");
  134. var_dump($stmt);
  135. $stmt->bind_param('i',$i);
  136. $stmt->execute();
  137. }
  138. $mysqli->close();
  139. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement