coba2.zip_php_zip

<?php // koneksi ke databasr $conn = mysqli_connect("localhost", "root", "", "beeaja"); function query($query) { global $conn; $result = mysqli_query($conn, $query); $rows = []; while ( $row = mysqli_fetch_assoc($result) ) { $rows[] = $row; } return $rows; } function tambah ($data) { global $conn; $nama = htmlspecialchars($data["nama"]); $kesibukan = htmlspecialchars($data["kesibukan"]); $tgl_lahir = htmlspecialchars($data["tgl_lahir"]); $alamat = htmlspecialchars($data["alamat"]); // upload gambar $gambar = upload(); if ( !$gambar ) { return false; } // query insert data $query = "INSERT INTO anggota VALUES ('', '$nama', '$kesibukan', '$tgl_lahir', '$alamat', '$gambar') "; mysqli_query($conn, $query); return mysqli_affected_rows($conn); } function upload() { $namaFile = $_FILES["gambar"]["name"]; $ukuranFile = $_FILES["gambar"]["size"]; $error = $_FILES["gambar"]["error"]; $tmpName = $_FILES["gambar"]["tmp_name"]; // cek apakah tidak ada gambar yang diupload if ( $error === 4 ) { echo "<script> alert('Pilih gambar terlebih dahulu!'); </script>"; return false; } // cek apakah yang diupload adalah gambar $ekstensiGambarValid = ['jpg', 'jpeg', 'png']; $ekstensiGambar = explode('.', $namaFile); $ekstensiGambar = strtolower(end($ekstensiGambar)); if( !in_array($ekstensiGambar, $ekstensiGambarValid) ) { echo "<script> alert('Yang anda upload bukan gambar!'); </script>"; return false; } // cek jika ukurannya terlalu besar if ( $ukuranFile > 15000000 ) { echo "<script> alert('Ukuran gambar terlalu besar!'); </script>"; return false; } // lolos pengecekan gambar siap diuplaod // generate nama gambar baru $namaFileBaru = uniqid(); $namaFileBaru .= '.'; $namaFileBaru .= $ekstensiGambar; move_uploaded_file($tmpName, 'img/' . $namaFileBaru); return $namaFileBaru; } function hapus($id) { global $conn; mysqli_query($conn, "DELETE FROM anggota WHERE id = $id"); return mysqli_affected_rows($conn); } function ubah($data) { global $conn; $id = ($data["id"]); $nama = htmlspecialchars($data["nama"]); $kesibukan = htmlspecialchars($data["kesibukan"]); $tgl_lahir = htmlspecialchars($data["tgl_lahir"]); $alamat = htmlspecialchars($data["alamat"]); $gambarLama= ($data["gambarLama"]); // cek apakah user pilih gambar baru atau tidak if ( $_FILES['gambar']['error'] === 4 ) { $gambar = $gambarLama; } else { $gambar = upload(); } $query = "UPDATE anggota SET nama = '$nama', kesibukan = '$kesibukan', tgl_lahir = '$tgl_lahir', alamat = '$alamat', gambar = '$gambar' WHERE id = $id "; mysqli_query($conn, $query); return mysqli_affected_rows($conn); } function cari ($katakunci) { $query = "SELECT * FROM anggota WHERE nama LIKE '%$katakunci%' OR alamat LIKE '%$katakunci%' "; return query($query); } function registrasi($data) { global $conn; $username = strtolower(stripslashes($data["username"])); $password = mysqli_real_escape_string($conn, $data["password"]); $conpassword = mysqli_real_escape_string($conn, $data["conpassword"]); // cek username sudah ada atau belum $result = mysqli_query($conn, "SELECT username FROM users WHERE username = '$username'"); if( mysqli_fetch_assoc($result) ) { echo "<script> alert('Username sudah ada!') </script>"; return false; } // cek konfirmasi password if ( $password !== $conpassword ) { echo "<script> alert('Konfirmasi password tidak sesuai!') </script>"; return false; } // enkripsi password $password = password_hash($password, PASSWORD_DEFAULT); // tambahkan user baru ke database mysqli_query($conn, "INSERT INTO users VALUES ('', '$username', '$password')"); return mysqli_affected_rows($conn); } ?>