Advertisement
gurumutant

Pemroses Form Bibliografi untuk memproses upload file

Oct 25th, 2019
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.25 KB | None | 0 0
  1. <?php
  2. // file proses/biblio-proses.php
  3. require_once("../config.php");
  4.  
  5. cekvar($_POST);
  6. if (isset($_POST["judul_buku"])) { // mendeteksi pengiriman form
  7.     extract($_POST); // ekstraksi array $_POST
  8.     // mengecek apakah ada upload file
  9.     if ($_FILES['file_cover']['name'] != "") { // terdeteksi ada upload
  10.         $upload_dir = "../img/coverbuku/";
  11.         $namafilecover = mktime().$_FILES['file_cover']['name'];
  12.         move_uploaded_file(
  13.             $_FILES['file_cover']['tmp_name'],
  14.             $upload_dir.$namafilecover
  15.         );
  16.     } else { // tidak ada file diupload
  17.         if ($kode_buku > 0) { // uperasi update, jangan ubah nama file
  18.             $namafilecover = $cover_existing;
  19.         } else { // operasi insert, isi nama file dengan null
  20.             $namafilecover = NULL;
  21.         }
  22.     }
  23.     if ($kode_buku > 0) { // apakah mau mengupdate
  24.         $sql = "UPDATE buku
  25.                SET Bk_Judul_Buku =  ?,
  26.                Bk_Penulis = ?,
  27.                Bk_Th_Terbit = ?,
  28.                Bk_Kode_Kategori = ?,
  29.                Bk_Penerbit = ?,
  30.                Bk_Foto = ?
  31.                 WHERE Kode_Buku = ?";
  32.         $stmt = $conn->prepare($sql);
  33.         $formdata = [
  34.             $judul_buku,
  35.             $penulis,
  36.             $th_terbit,
  37.             $kode_kategori,
  38.             $penerbit,
  39.             $namafilecover,
  40.             $kode_buku
  41.         ];
  42.         $stmt->execute($formdata);
  43.         setPesan("Data berhasil diperbarui");
  44.     } else { // menambahkan data baru
  45.         $sql = "INSERT INTO buku VALUES(NULL, NOW(), ?, ?, ?, ?, ?)";
  46.         $stmt = $conn->prepare($sql);
  47.         $formdata = [
  48.             $judul_buku,
  49.             $penulis,
  50.             $th_terbit,
  51.             $kode_kategori,
  52.             $penerbit,
  53.             $namafilecover
  54.         ];
  55.         $stmt->execute($formdata);
  56.         setPesan("Data berhasil disimpan");
  57.     }
  58.     header("Location: ../index.php?p=bibliografi"); exit;
  59. }
  60. if (isset($_GET["id"])) { // mendeteksi operasi hapus
  61.     $id = $_GET["id"];
  62.     $stmt = $conn->prepare("DELETE FROM buku
  63.                                WHERE Kode_Buku = ?");
  64.     $stmt->execute([$id]);
  65.     setPesan("Data berhasil dihapus");
  66.     header("Location: ../index.php?p=bibliografi"); exit;
  67. }
  68. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement