Advertisement
nicolas-chuet

modifier.php

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