API tools faq
paste
Guest User

Untitled

a guest
Jun 19th, 2018
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.79 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. if(isset($_FILES['file_array'])){
  3. $name_array = $_FILES['file_array']['name'];
  4. $tmp_name_array = $_FILES['file_array']['tmp_name'];
  5. $type_array = $_FILES['file_array']['type'];
  6. $size_array = $_FILES['file_array']['size'];
  7. $error_array = $_FILES['file_array']['error'];
  8. for($i = 0; $i < count($tmp_name_array); $i++){
  9. if(move_uploaded_file($tmp_name_array[$i], "videoCover/".$name_array[$i])){
  10. echo $name_array[$i]." upload is complete<br>";
  11. } else {
  12. echo "move_uploaded_file function failed for ".$name_array[$i]."<br>";
  13. }
  14. }
  15.  
  16. include '../connect/con.php';
  17.  
  18. $id = mysqli_real_escape_string($con, $_POST['id']);
  19. $vidLD = mysqli_real_escape_string($con, $_POST['vidLD']);
  20. $vidYear = mysqli_real_escape_string($con, $_POST['vidYear']);
  21. $vidCity = mysqli_real_escape_string($con, $_POST['vidCity']);
  22. $vidZanr = mysqli_real_escape_string($con, $_POST['vidZanr']);
  23. $vidQuality = mysqli_real_escape_string($con, $_POST['vidQuality']);
  24. $vidTranslated = mysqli_real_escape_string($con, $_POST['vidTranslated']);
  25. $vidMaker = mysqli_real_escape_string($con, $_POST['vidMaker']);
  26. $vidRoles = mysqli_real_escape_string($con, $_POST['vidRoles']);
  27. $vidTime = mysqli_real_escape_string($con, $_POST['vidTime']);
  28. $imgShot1 = PICTURE1;
  29. $imgShot2 = PICTURE2;
  30. $imgShot3 = PICTURE1;
  31.  
  32. $sql="INSERT INTO videoinformation (id, vidLD, vidYear, vidCity, vidZanr, vidQuality, vidTranslated, vidTime, vidMaker, vidRoles, imgShot1, imgShot2, imgShot3) VALUES ('$id', '$vidLD', '$vidYear', '$vidCity', '$vidZanr', '$vidQuality', '$vidTranslated', '$vidMaker', '$vidRoles', '$imgShot1', '$imgShot2', '$imgShot3')";
  33.  
  34. if (!mysqli_query($con,$sql)) {
  35. die('Error: ' . mysqli_error($con));
  36. }echo "Video Description are added";
  37.  
  38. mysqli_close($con);
  39. }
  40. ?>
  41.  
  42. <!DOCTYPE html>
  43. <html>
  44. <head>
  45. <meta charset="UTF-8">
  46. </head>
  47. <body>
  48. <form action="../upload/uploadLD.php" method="post" enctype="multipart/form-data">
  49.  
  50.  
  51. <table style="width:500px, margin-left:50px">
  52. <tr><td>Video ID: </td>
  53. <td><select id="id" name="id">
  54.  
  55. <?php
  56.  
  57. include '../connect/con.php';
  58.  
  59. $con = mysqli_connect("$db_host", "$db_username", "$db_pass", "$db_name");
  60.  
  61. mysqli_select_db($db_name, $con);
  62. if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); }
  63.  
  64. $cdquery="SELECT * FROM newsvid";
  65. $cdresult = mysqli_query($con,$cdquery);
  66.  
  67. while ($cdrow=mysqli_fetch_array($cdresult)) {
  68. $cdTitle=$cdrow["id"];
  69. echo "<option>
  70. $cdTitle
  71. </option>"; }
  72.  
  73. mysqli_close($con);?>
  74.  
  75. </select>
  76. </td></tr>
  77.  
  78.  
  79. <tr><td>Video LD</td><td><input name="vidLD"></td></tr>
  80. <tr><td>Year:</td><td><input name="vidYear"></td></tr>
  81. <tr><td>City:</td><td><input name="vidCity"></td></tr>
  82. <tr><td>Zanr:</td><td><input name="vidZanr"></td></tr>
  83. <tr><td>Quality:</td><td><input name="vidQuality"></td></tr>
  84. <tr><td>Translated:</td><td><input name="vidTranslated"></td></tr>
  85. <tr><td>Time:</td><td><input name="vidTime"></td></tr>
  86. <tr><td>Maker:</td><td><input name="vidMaker"></td></tr>
  87. <tr><td>Roles:</td><td><input name="vidRoles"></td></tr>
  88. </table>
  89.  
  90.  
  91.  
  92.  
  93.  
  94. <p><input type="file" name="file_array[]"></p>
  95. <p><input type="file" name="file_array[]"></p>
  96. <p><input type="file" name="file_array[]"></p>
  97. <input type="submit" value="Upload all files">
  98.  
  99. </form>
  100. </body>
  101. </html>
  102.  
  103. $imgShot1 = PICTURE1;
  104. $imgShot2 = PICTURE2;
  105. $imgShot3 = PICTURE1;
  106.  
  107. $name_array = $_FILES['file_array']['name'];
  108. $tmp_name_array = $_FILES['file_array']['tmp_name'];
  109. $type_array = $_FILES['file_array']['type'];
  110. $size_array = $_FILES['file_array']['size'];
  111. $error_array = $_FILES['file_array']['error'];
  112. for($i = 0; $i < count($tmp_name_array); $i++){
  113. if(move_uploaded_file($tmp_name_array[$i], "videoCover/".$name_array[$i])){
  114. echo $name_array[$i]." upload is complete<br>";
  115. $imgShot[$i]=base64_encode(file_get_contents('videoCover/'.$name_array[$i]));
  116. $sql="INSERT INTO videoinformation '".$imgShot[0]."','".$imgShot[1]."','".$imgShot[2];
  117. } else {
  118. echo "move_uploaded_file function failed for ".$name_array[$i]."<br>";
  119. }
  120. }
  121.  
  122. $imgShot[$i]=base64_encode(file_get_contents('videoCover/'.$name_arrray[$i]));
  123.  
  124. $sql="insert into [...] '".$imgShot[0]."','".$imgShot[1]."','".$imgShot[2]."' [...]";
  125.  
  126. $imgShot1 = PICTURE1;
  127. $imgShot2 = PICTURE2;
  128. $imgShot3 = PICTURE1;
  129.  
  130. $sql="INSERT INTO videoinformation (id, vidLD, vidYear, vidCity, vidZanr, vidQuality, vidTranslated, vidTime, vidMaker, vidRoles, imgShot1, imgShot2, imgShot3) VALUES ('$id', '$vidLD', '$vidYear', '$vidCity', '$vidZanr', '$vidQuality', '$vidTranslated', '$vidMaker', '$vidRoles', '".$imgShot[0]."','".$imgShot[1]."','".$imgShot[2]."')";
  131.  
  132. <?php
  133.  
  134. include '../connect/con.php';
  135.  
  136. if(isset($_FILES['file_array'])){
  137.  
  138. $name_array = $_FILES['file_array']['name'];
  139. $tmp_name_array = $_FILES['file_array']['tmp_name'];
  140. $type_array = $_FILES['file_array']['type'];
  141. $size_array = $_FILES['file_array']['size'];
  142. $error_array = $_FILES['file_array']['error'];
  143. for($i = 0; $i < count($tmp_name_array); $i++){
  144. if(move_uploaded_file($tmp_name_array[$i], "videoCover/".$name_array[$i])){
  145. echo $name_array[$i]." upload is complete<br>";
  146. $imgShot[$i]=base64_encode(file_get_contents('videoCover/'.$name_array[$i]));
  147. } else {
  148. echo "move_uploaded_file function failed for ".$name_array[$i]."<br>";
  149. }
  150. }
  151.  
  152.  
  153.  
  154. $id = mysqli_real_escape_string($con, $_POST['id']);
  155. $vidLD = mysqli_real_escape_string($con, $_POST['vidLD']);
  156. $vidYear = mysqli_real_escape_string($con, $_POST['vidYear']);
  157. $vidCity = mysqli_real_escape_string($con, $_POST['vidCity']);
  158. $vidZanr = mysqli_real_escape_string($con, $_POST['vidZanr']);
  159. $vidQuality = mysqli_real_escape_string($con, $_POST['vidQuality']);
  160. $vidTranslated = mysqli_real_escape_string($con, $_POST['vidTranslated']);
  161. $vidMaker = mysqli_real_escape_string($con, $_POST['vidMaker']);
  162. $vidRoles = mysqli_real_escape_string($con, $_POST['vidRoles']);
  163. $vidTime = mysqli_real_escape_string($con, $_POST['vidTime']);
  164.  
  165. $sql="INSERT INTO videoinformation (id, vidLD, vidYear, vidCity, vidZanr, vidQuality, vidTranslated, vidTime, vidMaker, vidRoles, imgShot1, imgShot2, imgShot3) VALUES ('$id', '$vidLD', '$vidYear', '$vidCity', '$vidZanr', '$vidQuality', '$vidTranslated', '$vidMaker', '$vidRoles', '".$imgShot[0]."','".$imgShot[1]."','".$imgShot[2]."')";
  166. if (!mysqli_query($con,$sql)) {
  167. die('Error: ' . mysqli_error($con));
  168. }echo "Video Description are added";
  169.  
  170. mysqli_close($con);
  171. }
  172. ?>
  173.  
  174. <FORM ENCTYPE="multipart/form-data" ACTION="upload.php" METHOD="POST">
  175. <INPUT NAME="file[]" TYPE="file">
  176. <INPUT NAME="file[]" TYPE="file">
  177. <INPUT NAME="file[]" TYPE="file">
  178. </FORM>
  179.  
  180. <?php
  181. foreach( $_FILES['file'] as $file ){
  182. print_r( $file );
  183. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!