Advertisement
Guest User

Untitled

a guest
Sep 26th, 2018
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.52 KB | None | 0 0
  1. <form action="upload_file.php" method="post" enctype="multipart/form-data">
  2. <div class="form-group">
  3. <label for="exampleInputEmail1">Upload File</label>
  4. <input type="file" class="form-control" id="upload_file" name="upload_file[]" onchange="preview_image();" multiple/>
  5. <small id="emailHelp" class="form-text text-muted">*upload gambar disini.</small>
  6. <label for="exampleInputEmail1" style="margin-top:10px;">Jenis Aplikasi</label>
  7. <select class="form-control" name="jenis">
  8. <option value="0">Pilih Jenis</option>
  9. <?php
  10.  
  11. $servername = "localhost";
  12. $username = "root";
  13. $password = "";
  14. $dbname = "db_images";
  15.  
  16. // Create connection
  17. $conn = new mysqli($servername, $username, $password, $dbname);
  18. $sql = "SELECT * FROM tb_id_app where jenis = '2' order by id desc";
  19. $result = $conn->query($sql);
  20. while($row = $result->fetch_assoc()) { ?>
  21. ?>
  22. <option value="<?php echo $row['id'];?>"><?php echo $row['app_id'];?></option>
  23. <?php }?>
  24. </select>
  25. </div>
  26. <input type="submit" name='submit_image' class="btn btn-primary" value="Upload Image"/>
  27. </form>
  28.  
  29.  
  30. <?php
  31. $servername = "localhost";
  32. $username = "root";
  33. $password = "";
  34. $dbname = "db_images";
  35.  
  36. // Create connection
  37. $conn = new mysqli($servername, $username, $password, $dbname);
  38. // Check connection
  39. if ($conn->connect_error) {
  40. die("Connection failed: " . $conn->connect_error);
  41. }
  42.  
  43. if(isset($_POST['submit_image']))
  44. {
  45. for($i=0;$i<count($_FILES["upload_file"]["name"]);$i++)
  46. {
  47. $uploadfile=$_FILES["upload_file"]["tmp_name"][$i];
  48. $folder="wallpaper1/";
  49. $time = date("Y-m-d h:i:sa");
  50. $array = explode('.', $_FILES["upload_file"]["name"][$i]);
  51.  
  52. $name = md5($time."".$_FILES["upload_file"]["name"][$i]).".".$array[count($array)-1];
  53. move_uploaded_file($_FILES["upload_file"]["tmp_name"][$i], "$folder".$name);
  54.  
  55. //INSERT INTO `db_wallpaper`(`id`, `image`) VALUES ([value-1],[value-2])
  56. $sql = "INSERT INTO `db_wallpaper`(`id`, `image`,`id_app`) VALUES (0,'".$name."','".$_REQUEST['jenis']."')";
  57.  
  58. if ($conn->query($sql) === TRUE) {
  59. echo "New record created successfully";
  60. } else {
  61. echo "Error: " . $sql . "<br>" . $conn->error;
  62. }
  63. }
  64. exit();
  65. }
  66.  
  67.  
  68. $conn->close();
  69. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement