Peraksian

 Proses_album 

<?php

session_start();

include 'koneksi.php';

if (isset($_POST['tambah'])) {

  $namaalbum = $_POST['namaalbum'];

  $deskripsi = $_POST['deskripsi'];

  $tanggal = date('Y-m-d');

  $userid = $_SESSION['userid'];

  $sql=mysqli_query($conn,"insert into album values('','$namaalbum','$deskripsi','$tanggal','$userid')");

  echo "<script>

        alert('Data Berhasil Disimpan!');

        location.href='../admin/album.php';

        </script>";

}

if(isset($_POST['edit'])){

  $albumid = $_POST['albumid'];

  $namaalbum = $_POST['namaalbum'];

  $deskripsi = $_POST['deskripsi'];

  $tanggal = date('Y-m-d');

  $userid = $_SESSION['userid'];

  $sql=mysqli_query($conn,"update album set namaalbum='$namaalbum', deskripsi='$deskripsi', tanggaldibuat='$tanggal' where albumid='$albumid'");

  echo "<script>

        alert('Data Berhasil Diedit!');

        location.href='../admin/album.php';

        </script>";

}

if (isset($_POST['hapus'])) {

  $albumid = $_POST['albumid'];

  $sql = mysqli_query($conn, "delete from album where albumid='$albumid'");

  echo "<script>

        alert('Data Berhasil Dihapus!');

        location.href='../admin/album.php';

        </script>";

}

?>

Proses_foto

<?php

include "koneksi.php";

session_start();

if(isset($_POST['tambah'])){

  $judulfoto = $_POST['judulfoto'];

  $deskripsifoto = $_POST['deskripsifoto'];

  $tanggalunggah = date('Y-m-d');

  $albumid = $_POST['albumid'];

  $userid = $_SESSION['userid'];

  $foto = $_FILES['lokasifile']['name'];

  $tmp = $_FILES['lokasifile']['tmp_name'];

  $lokasi = '../assets/img/';

  $namafoto = rand() . '_' . $foto;

  move_uploaded_file($tmp, $lokasi . $namafoto);

  $sql=mysqli_query($conn,"insert into foto values('','$judulfoto','$deskripsifoto','$tanggalunggah','$namafoto','$albumid','$userid')");

  echo "<script>

        alert('Data Berhasil Disimpan!');

        location.href='../admin/foto.php';

        </script>";

}

if(isset($_POST['edit'])){

  $fotoid = $_POST['fotoid'];

  $judulfoto = $_POST['judulfoto'];

  $deskripsifoto = $_POST['deskripsifoto'];

  $tanggalunggah = date('Y-m-d');

  $albumid = $_POST['albumid'];

  $userid = $_SESSION['userid'];

  $foto = $_FILES['lokasifile']['name'];

  $tmp = $_FILES['lokasifile']['tmp_name'];

  $lokasi = '../assets/img/';

  $namafoto = rand() . '_' . $foto;

  if ($foto == null){

    $sql = mysqli_query($conn, "update foto set judulfoto='$judulfoto', deskripsifoto='$deskripsifoto', tanggalunggah='$tanggalunggah', albumid='$albumid' where fotoid='$fotoid'");

  }else{

    $query = mysqli_query($conn, "select * from foto where fotoid='$fotoid'");

    $data = mysqli_fetch_array($query);

    if (is_file('../assets/img/'.$data['lokasifile'])){

        unlink('../assets/img/'.$data['lokasifile']);

    }

    move_uploaded_file($tmp, $lokasi . $namafoto);

    $sql = mysqli_query($conn, "update foto set judulfoto='$judulfoto', deskripsifoto='$deskripsifoto', tanggalunggah='$tanggalunggah', lokasifile='$namafoto', albumid='$albumid' where fotoid='$fotoid'");

  }

  echo "<script>

        alert('Data Berhasil Diedit!');

        location.href='../admin/foto.php';

        </script>";

}

if(isset($_POST['hapus'])){

  $fotoid = $_POST['fotoid'];

  $query = mysqli_query($conn, "select * from foto where fotoid='$fotoid'");

    $data = mysqli_fetch_array($query);

  if (is_file('../assets/img/' . $data['lokasifile'])) {

    unlink('../assets/img/' . $data['lokasifile']);

  }

  $sql = mysqli_query($conn, "delete from foto where fotoid='$fotoid'");

  echo "<script>

        alert('Data Berhasil Dihapus!');

        location.href='../admin/foto.php';

        </script>";

}

?>

Proses_komentar

<?php

session_start();

include 'koneksi.php';

$fotoid=$_POST['fotoid'];

$userid=$_SESSION['userid'];

$isikomentar=$_POST['isikomentar'];

$tanggalkomentar=date("Y-m-d");

$query=mysqli_query($conn, "insert into komentarfoto values('','$fotoid', '$userid','$isikomentar','$tanggalkomentar')");

echo "<script>

location.href='../admin/index.php';

</script>";

if (isset($_POST['hapus'])) {

    $userid = $_POST['userid'];

    $isikomentar=$_POST['isikomentar'];

    

  

    $sql = mysqli_query($conn, "delete from komentarfoto where userid='$userid'");

  

    echo "<script>

          alert('Data Berhasil Dihapus!');

          location.href='../admin/index.php';

          </script>";

  }

  ?>

Proses_like

<?php

session_start();

include 'koneksi.php';

$fotoid = $_GET['fotoid'];

$userid = $_SESSION['userid'];

$ceksuka = mysqli_query($conn, "select * from likefoto where fotoid='$fotoid' and userid='$userid'");

if (mysqli_num_rows($ceksuka) == 1) {

  while($row = mysqli_fetch_array($ceksuka)){ 

  $likeid = $row['likeid'];

  $query = mysqli_query($conn, "delete from likefoto where likeid='$likeid'");

  echo "<script> 

  location.href='../admin/home.php';

  </script>";

}

}else{

$tanggallike = date('Y-m-d');

$query = mysqli_query($conn, "insert into likefoto values('','$fotoid','$userid','$tanggallike')");

echo "<script>

location.href='../admin/home.php';

</script>";

}

?>

Proses_register

<?php

include "koneksi.php";

$username = $_POST['username'];

$password = md5($_POST['password']);

$email = $_POST['email'];

$namalengkap = $_POST['namalengkap'];

$alamat = $_POST['alamat'];

$sql = mysqli_query($conn, "insert into user values('','$username','$password','$email','$namalengkap','$alamat')");

if($sql){

  echo "<script>

  alert('Pendaftaran Akun Berhasil!');

  location.href='../login.php';

  </script>";

  

}

?>

Proses_login

<?php

include "koneksi.php";

session_start();

$username = $_POST['username'];

$password = md5($_POST['password']);

$sql = mysqli_query($conn,"select * from user where username='$username' and password='$password'");

$cek=mysqli_num_rows($sql);

if($cek > 0){

  $data = mysqli_fetch_array($sql);

        $_SESSION['username']= $data['username'];

        $_SESSION['userid'] = $data['userid'];

        $_SESSION['status']= 'login';

    echo "<script>

        alert('Login Berhasil');

        location.href='../admin/index.php';

        </script>";

    }else{

      echo "<script>

        alert('Username atau Password Salah!');

        location.href='../login.php';

        </script>";

    }

?>

Proses_logout

<?php

//mengaktifkan session php

session_start();

//menghapus semua session

session_destroy();

echo "<script>

alert('Logout Berhasil');

location.href='../index.php';

</script>";

?>

Koneksi 

<?php

$hostname = "localhost";

$userdb = "root";

$passdb = "";

$namedb = "galleryz";

$conn = mysqli_connect($hostname, $userdb, $passdb, $namedb);

?>

Opsi dua

<?php

$conn = mysqli_connect("localhost", "root", "", "db_gallery_eliyani");

?>