album.php

<div class="container">
   <div class="row">
      <div class="col-5">
         <div class="card">
            <div class="card-body">
               <h4>Halaman Album</h4>
               <?php
               //ambil data yang di kirim oleh <form>
               $submit = @$_POST['submit'];
               $albumID = @$_GET['albumid'];
               if ($submit == 'Simpan') {
                  $nama_album = @$_POST['nama_album'];
                  $deskripsi_album = @$_POST['deskripsi_album'];
                  $tanggal = date('Y-m-d');
                  $user_id = @$_SESSION['user_id'];
                  $insert = mysqli_query($conn, "INSERT INTO album VALUES('','$nama_album','$deskripsi_album','$tanggal','$user_id')");
                  if ($insert) {
                     echo "<script> alert('Berhasil Membuat Album!!!')</script>";
                     echo '<meta http-equiv="refresh" content="0.8; url=?url=album">';
                  } else {
                     echo "<script> alert('Gagal Membuat Album!!!')</script>";
                     echo '<meta http-equiv="refresh" content="0.8; url=?url=album">';
                  }
               } elseif (isset($_GET['edit'])) {
                  if ($submit == 'Ubah') {
                     $nama_album = @$_POST['nama_album'];
                     $deskripsi_album = @$_POST['deskripsi_album'];
                     $tanggal = date('Y-m-d');
                     $user_id = @$_SESSION['user_id'];
                     $update = mysqli_query($conn, "UPDATE album SET NamaAlbum='$nama_album', Deskripsi='$deskripsi_album' WHERE AlbumID='$albumID'");
                     if ($update) {
                        echo "<script> alert('Berhasil Mengubah Album!!!')</script>";
                        echo '<meta http-equiv="refresh" content="0.8; url=?url=album">';
                     } else {
                        echo "<script> alert('Gagal Mengubah Album!!!')</script>";
                        echo '<meta http-equiv="refresh" content="0.8; url=?url=album">';
                     }
                  }
               } elseif (isset($_GET['hapus'])) {
                  $hapus = mysqli_query($conn, "DELETE FROM album WHERE AlbumID='$albumID'");
                  if ($hapus) {
                     echo "<script> alert('Berhasil Hapus Album!!!')</script>";
                     echo '<meta http-equiv="refresh" content="0.8; url=?url=album">';
                  } else {
                     echo "<script> alert('Gagagl Menghapus Album!!!')</script>";
                     echo '<meta http-equiv="refresh" content="0.8; url=?url=album">';
                  }
               }
               $val = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM album WHERE AlbumID='$albumID' "));
               ?>
               <?php if (!isset($_GET['edit'])) : ?>
                  <form action="?url=album" method="post">
                     <div class="form-group">
                        <label>Nama Album</label>
                        <input type="text" class="form-control" required name="nama_album">
                     </div>
                     <div class="form-group">
                        <label>Deskripsi Album</label>
                        <textarea name="deskripsi_album" class="form-control" required cols="30" rows="5"></textarea>
                     </div>
                     <input type="submit" value="Simpan" name="submit" class="btn btn-danger my-3">
                  </form>
               <?php elseif (isset($_GET['edit'])) : ?>
                  <form action="?url=album&&edit&&albumid=<?= $val['AlbumID'] ?>" method="post">
                     <div class="form-group">
                        <label>Nama Album</label>
                        <input type="text" class="form-control" value="<?= $val['NamaAlbum'] ?>" required name="nama_album">
                     </div>
                     <div class="form-group">
                        <label>Deskripsi Album</label>
                        <textarea name="deskripsi_album" class="form-control" required cols="30" rows="5"><?= $val['Deskripsi'] ?></textarea>
                     </div>
                     <input type="submit" value="Ubah" name="submit" class="btn btn-danger my-3">
                  </form>
               <?php endif; ?>
            </div>
         </div>
      </div>
      <div class="col-7">
         <div class="card">
            <div class="card-body">
               <table class="table table-hovered">
                  <thead>
                     <tr>
                        <th>No</th>
                        <th>Nama Album</th>
                        <th>Deskripsi Album</th>
                        <th>Tanggal Dibuat</th>
                        <th>Aksi</th>
                     </tr>
                  </thead>
                  <tbody>
                     <?php
                     $i = 1;
                     $userid = @$_SESSION['user_id'];
                     $albums = mysqli_query($conn, "SELECT * FROM album WHERE UserID='$userid'");
                     foreach ($albums as $album) :
                     ?>
                        <tr>
                           <td><?= $i++ ?></td>
                           <td><?= $album['NamaAlbum'] ?></td>
                           <td><?= $album['Deskripsi'] ?></td>
                           <td><?= $album['TanggalDibuat'] ?></td>
                           <td>
                              <a href="?url=album&&edit&&albumid=<?= $album['AlbumID'] ?>" class="btn btn-sm btn-warning">Edit</a>
                              <a href="?url=album&&hapus&&albumid=<?= $album['AlbumID'] ?>" class="btn btn-sm btn-danger">Hapus</a>
                              <a href="?url=kategori&&albumid=<?= $album['AlbumID'] ?>" class="btn btn-sm btn-success">Lihat Foto</a>
                           </td>
                        </tr>
                     <?php endforeach; ?>
                  </tbody>
               </table>
            </div>
         </div>
      </div>
   </div>
</div>