Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2021
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.87 KB | None | 0 0
  1. ============================================= includes/incl.page.php =================================================
  2. <?php
  3.  
  4. /* Answer to: "php error reporting" */
  5.  
  6. ini_set('display_errors', 1);
  7. ini_set('display_startup_errors', 1);
  8. error_reporting(E_ALL);
  9.  
  10. $response = array(
  11. 'status' => 0,
  12. 'message' => 'Form submission falied, please try again'
  13. );
  14.  
  15. if (isset($_POST["img_page"]) || isset($_POST["page_title"]) || isset($_POST["page_descr"]) || isset($_POST["videoId"])) {
  16.  
  17. $newFileName = basename($_FILES["page_img"]["name"]);
  18.  
  19. if (empty($newFileName)) {
  20. $newFileName = "pageImg";
  21. } else {
  22. //create lowercase of filename and replace empty space with -
  23. $newFileName = strtolower(str_replace(" ", "-", $newFileName));
  24. }
  25. $imgTitle = isset($_POST["page_title"]);
  26. $imgDescr = isset($_POST["page_descr"]);
  27.  
  28. $pageImg = isset($_POST["page_img"]);
  29.  
  30. $fileName = $_FILES["page_img"]["name"];
  31. $fileType = $_FILES["page_img"]['type'];
  32. $fileTempName = $_FILES["page_img"]['tmp_name'];
  33. $fileError = $_FILES["page_img"]['error'];
  34. $fileSize = $_FILES["page_img"]['size'];
  35.  
  36. echo $fileName;
  37.  
  38. $youtubeVideoId = isset($_POST["videoId"]);
  39.  
  40. $fileExtension = explode(".", $fileName);
  41. $fileActualExt = strtolower(end($fileExtension));
  42.  
  43. $allowed = array("jpg", "jpeg", "png");
  44.  
  45. if (in_array($fileActualExt, $allowed)) {
  46. if ($fileError === 0) {
  47. if ( $fileSize < 2000000 ){
  48. $imageFullName = $newFileName . "." . uniqid("", true) . "." . $fileActualExt;
  49. $fileDestination = "../img/page/" . $imageFullName;
  50.  
  51. include_once "dbh.incl.php";
  52.  
  53. if (empty($imgTitle) || empty($imgDescr) || empty($youtubeVideoId)) {
  54. header("Location: ../page-post.php?upload=emptyinput" . $youtubeVideoId . "");
  55. exit();
  56. } else {
  57. $sql = "SELECT * FROM pages";
  58. $stmt = mysqli_stmt_init($conn);
  59. if (!mysqli_stmt_prepare($stmt, $sql)) {
  60. echo"SQL statement gefaald 1!";
  61. } else {
  62. mysqli_stmt_execute($stmt);
  63. $result = mysqli_stmt_get_result($stmt);
  64. // $rowCount = mysqli_num_rows($result);
  65. // $setImageOrder = $rowCount + 1;
  66.  
  67. $sql = "INSERT INTO pages (titlePage, descPage, imgPage, youtubeVideoId) VALUES (?, ?, ?, ?)";
  68. if (!mysqli_stmt_prepare($stmt, $sql)) {
  69. echo "SQL statement gefaald 2!";
  70. }
  71. else {
  72. // bind 3 strings to statement
  73. mysqli_stmt_bind_param($stmt, "ssss", $imgTitle, $imgDescr, $imageFullName, $youtubeVideoId);
  74. mysqli_stmt_execute($stmt);
  75.  
  76. move_uploaded_file($fileTempName, $fileDestination);
  77.  
  78. header("Location: ../page-manage.php?upload=succes");
  79. exit();
  80. }
  81. }
  82. }
  83.  
  84.  
  85. } else {
  86. $response['message'] = 'bestand is te groot!';
  87. }
  88.  
  89. } else {
  90. $response['message'] = 'U heeft een error bij het uploaden van uw bestand!';
  91. }
  92. } else {
  93. $response['message'] = 'Om een bestand te uploaden moet het een PNG/JPEG/JPG bestand zijn!';
  94. }
  95.  
  96. echo json_decode($response);
  97. } else {
  98. $response['message'] = 'Form input not valid';
  99. }
  100.  
  101. echo json_encode($response);
  102.  
  103.  
  104.  
  105. ======================================== ajax.js =====================================================
  106.  
  107. $("#myForm").on('submit', function(e){
  108. e.preventDefault();
  109. $.ajax({
  110. url: '/blog-app/includes/page.incl.php',
  111. type: "POST",
  112. data: new FormData(this),
  113. // dataType: "json",
  114. cache: false,
  115. processData: false,
  116. contentType: false,
  117. method: 'get',
  118. beforesend: function() {
  119. $('.submit').attr("disabled", "disabled");
  120. },
  121. success: function(response){
  122. console.log("success", response.message);
  123. alert('response', response);
  124.  
  125. },
  126.  
  127. error: function (e) {
  128. alert('Something went wrong with uploading the data');
  129. console.log("Unsuccessful:", e);
  130. }
  131. });
  132.  
  133. =================================== html ========================================================
  134.  
  135. <?php
  136. include_once 'admin-nav.php';
  137. include_once 'admin-page-header.php';
  138. // require "includes/page.incl.php";
  139. ?>
  140.  
  141. <main class="my-5">
  142.  
  143. <div class="col-sm-10">
  144. <div class="container">
  145. <div class="align-self-center">
  146. <h1 class="font-weight-light text-center text-lg-left mt-4 mb-0">Upload pagina</h1>
  147. <br>
  148. <form action=" " method="post" id="myForm" enctype="multipart/form-data">
  149.  
  150. <input type="text" name="page_title" class="page_title" placeholder="Pagina titel.." style="width:100%;"><br><br>
  151. <textarea name="page_descr" class="page_descr" id="" cols="30" placeholder="pagina beschrijving.." rows="10" style="width:100%;"></textarea>
  152. <hr>
  153. <input type="file" name="page_img" class="page_img">
  154. <label for="page_img">Kies een achtergrond</label>
  155. <br>
  156. <hr>
  157. <h3>Voeg een video toe</h3>
  158. <br>
  159. <input type="text" class="form-control" id="search" name="search" placeholder="type in gezochte video">
  160. <br>
  161. <div id="hide_video"><div id="name_video"></div></div>
  162. <br>
  163. <hr>
  164. <br>
  165. <h5 id="vidsAvailable">Videos beschikbaar</h5>
  166. <div class="row-xs-6 row-md-3">
  167. <div class="col">
  168. <div id="result"></div>
  169. </div>
  170. </div>
  171. <br>
  172. <hr>
  173. <section class="form-group">
  174. <button type="submit" name="page_upload" class="submit">Pagina Uploaden</button>
  175. </section>
  176. </form>
  177. </div>
  178. </div>
  179. </div>
  180. </main>
  181.  
  182. <!-- admin-page-header -->
  183. </div>
  184. <script scrc="js/youtube_api.js"></script>
  185. <!-- <script src="js/preview-image.js"></script> -->
  186. <?php
  187. require 'footer.php';
  188. ?>
  189.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement