Advertisement
ruswan11

Ubah File

Oct 24th, 2016
4,736
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.51 KB | None | 0 0
  1. <?php
  2.  
  3. $qtampil="SELECT * FROM  tbl_file WHERE file_id='$_GET[id]'";
  4. $tampil=mysqli_query($db,$qtampil);
  5. $datatampil = mysqli_fetch_array($tampil);
  6.  
  7. // Jika tombol simpan yang mempunyane name"ubah" ditekan
  8. if(isset($_POST['ubah'])) {
  9.  
  10.   // Baca lokasi file sementar dan nama file dari form (fupload)
  11.   $lokasi_file = $_FILES['file']['tmp_name'];
  12.   $nama_file = $_FILES['file']['name'];
  13.  
  14.   // Tentukan folder untuk menyimpan file
  15.   $folder = "file/$nama_file";
  16.  
  17.   // Jika tidak ada file yang dipilih, maka hanya merubah informasinya saja
  18.   if(!$lokasi_file){
  19.  
  20.   // Masukkan informasi file ke database
  21.     $update="UPDATE  tbl_file SET file_judul='$_POST[judul]', file_Keterangan='$_POST[keterangan]' WHERE file_id='$_GET[id]'";
  22.  
  23. // Memasukan data ke database dengan menggunakan koneksi yang ada di file koneksi.php
  24.     $hasil= mysqli_query($db,$update);
  25.     if ($hasil) {
  26.  
  27.     //pindah file ke dalam folder yang di web server
  28.      move_uploaded_file ($lokasi_file,"$folder");
  29.      echo "<script>alert('File Berhasil Dirubah..');location.href='index.php?m=daftar-File'</script>";
  30.    }
  31.    else{
  32.     echo "<script>alert('File l Dirubah..');location.href='index.php?m=daftar-File'</script>";
  33.   }
  34. }
  35. // Jika ada file yang dipilih, maka file yang lama diganti dengan file yang baru
  36. else{
  37.  
  38.   // Masukkan informasi file ke database
  39.   $update="UPDATE  tbl_file SET file_judul='$_POST[judul]', file_keterangan='$_POST[keterangan]', file_nama='$nama_file' WHERE file_id='$_GET[id]'";
  40.  
  41.   $hasil= mysqli_query($db,$update);
  42.   $file= "file/".$datatampil['file_nama']."";
  43.   if ($hasil) {
  44.     unlink($file);
  45.     move_uploaded_file ($lokasi_file,"$folder");
  46.     echo "<script>alert('File Berhasil Dirubah..');location.href='index.php?m=daftar-File'</script>";
  47.   }
  48.   else{
  49.     echo "ok";
  50.   }
  51. }
  52. }
  53.  
  54. ?>
  55.  
  56. <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">    
  57.   <div class="row">
  58.     <ol class="breadcrumb">
  59.       <li><a href="#"><svg class="glyph stroked home"><use xlink:href="#stroked-home"></use></svg></a></li>
  60.       <li class="active">Icons</li>
  61.     </ol>
  62.   </div><!--/.row-->
  63.  
  64.   <div class="row">
  65.     <div class="col-lg-12">
  66.       <h1 class="page-header">Ubah File</h1>
  67.     </div>
  68.   </div><!--/.row-->
  69.  
  70.  
  71.   <div class="row">
  72.     <div class="col-lg-12">
  73.       <div class="panel panel-default">
  74.         <div class="panel-heading">Form Ubah File</div>
  75.         <div class="panel-body">
  76.           <div class="col-md-12">
  77.             <form enctype="multipart/form-data" role="form" method="POST">
  78.              <div class="form-group">
  79.               <label>Pilih File</label>
  80.               <input type="file" class="form-control" name="file" >
  81.             </div>
  82.             <div class="form-group">
  83.               <label>Judul</label>
  84.               <input name="judul" value="<?php echo $datatampil['file_judul'];?>" class="form-control" placeholder="Judul File" required="">
  85.             </div>
  86.             <div class="form-group">
  87.               <label>Keterangan</label>
  88.               <textarea name="keterangan"  required=""  placeholder="Keterangan File" class="form-control" rows="3"><?php echo $datatampil['file_keterangan'];?></textarea>
  89.             </div>
  90.           </div>
  91.           <div class="col-md-6">
  92.             <button type="submit" name="ubah" class="btn btn-primary">Simpan</button>
  93.             <button type="reset" class="btn btn-default">Reset</button>
  94.           </div>
  95.         </form>
  96.       </div>
  97.     </div>
  98.   </div><!-- /.col-->
  99. </div><!-- /.row -->
  100.  
  101. </div><!--/.main-->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement