fungsi

<?php

// koneksi ke DBMS (database)
$connection = mysqli_connect("localhost", "root", "rahasia", "paytren");

// fungsi menampilkan semua data dari tabel
function query($query) {
    global $conn;

    // ambil data dari tabel mitra / query data mitra
    $result = mysqli_query($conn, $query);
    $rows   = [];

    while ($row = mysqli_fetch_assoc($result)) {
        $rows[] = $row;
    }

    return $rows;
}


// fungsi menambahkan data ke tabel
function tambah($data) {
    global $conn;

    // ambil data dari tiap element tabel mitra
    $nama       = htmlspecialchars($data["nama"]);
    $id_mitra   = htmlspecialchars($data["id_mitra"]);
    $no_hp      = htmlspecialchars($data["no_hp"]);
    $email      = htmlspecialchars($data["email"]);
    $alamat     = htmlspecialchars($data["alamat"]);

    // upload gambar
    $gambar = upload();
    if (!$gambar) {
        return false;
    }

    // query insert data
    $query = "INSERT INTO mitra
                VALUES
                ('', '$nama', '$id_mitra', '$no_hp', '$email', '$alamat', '$gambar')
                ";
    mysqli_query($conn, $query);

    return mysqli_affected_rows($conn);
}


// fungsi upload gambar
function upload() {

    $namaFile   = $_FILES["gambar"]["name"];
    $ukuranFile = $_FILES["gambar"]["size"];
    $error      = $_FILES["gambar"]["error"];
    $tmpName    = $_FILES["gambar"]["tmp_name"];
    // var_dump($ukuranFile);
    // die;

    // cek apakah ada gambar yang di upload atau tidak
    if ($error === 4) {
        echo "<script>
                alert('pilih gambar terlebih dahulu!');
            </script>";
        return false;
    }

    // cek yang di upload 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 ukuran gambar terlalu besar
    if ($ukuranFile > 1000000) {
        echo "<script>
                alert('ukuran gambar yang anda upload terlalu besar!');
            </script>";
        return false;
    }

    // cek jika gambar yang di upload tidak memiliki size
    if ($ukuranFile === 0) {
        echo "<script>
                alert('gambar yang anda masukkan tidak support. ganti gambar yang lain!');
            </script>";
        return false;
    }

    // lolos pengecekan gambar siap di upload
    move_uploaded_file($tmpName, 'img/'. $namaFile);

    return $namaFile;

}

// fungsi menghapus data dari tabel
function hapus($id) {
    global $conn;

    mysqli_query($conn, "DELETE FROM mitra WHERE id = $id");

    return mysqli_affected_rows($conn);
}


// fungsi untuk mengubah data
function ubah($data) {

    global $conn;

    // ambil data dari tiap element tabel mitra
    $id         = $data["id"];
    $nama       = htmlspecialchars($data["nama"]);
    $id_mitra   = htmlspecialchars($data["id_mitra"]);
    $no_hp      = htmlspecialchars($data["no_hp"]);
    $email      = htmlspecialchars($data["email"]);
    $alamat     = htmlspecialchars($data["alamat"]);
    $gambar     = htmlspecialchars($data["gambar"]);

    // query insert data
    $query = "UPDATE mitra SET
                nama = '$nama',
                id_mitra = '$id_mitra',
                no_hp = '$no_hp',
                email = '$email',
                alamat = '$alamat',
                gambar = '$gambar'

            WHERE id = $id
        ";

    mysqli_query($conn, $query);

    return mysqli_affected_rows($conn);
}

// fungsi untuk mencari data mitra
function cari($keyword) {

    $query = "SELECT * FROM mitra WHERE
            id_mitra LIKE '%$keyword%'
            ";

    return query($query);

}


// fungsi registrasi
function registrasi($data) {

    global $conn;

    $username = strtolower(stripcslashes($data["username"]));
    $password = mysqli_real_escape_string($conn, $data["password"]);
    $password2 = mysqli_real_escape_string($conn, $data["password2"]);

    // cek username sudah ada atau belum
    $result = mysqli_query($conn, "SELECT username FROM user WHERE username = '$username'");

    if (mysqli_fetch_assoc($result)) {
        echo "<script>
                alert('username sudah terdaftar');
            </script>";
        return false;
    }

    // cek konfirmasi password
    if ($password !== $password2) {
        echo "<script>
                alert('konfirmasi password tidak sesuai');
            </script>";
        return false;
    }

    // enkripsi password
    $password = password_hash($password, PASSWORD_DEFAULT);
    // var_dump($password); die;
    // var_dump($username); die;

    // tambahkan username baru ke database
    $sql = mysqli_query($conn, "INSERT INTO user VALUES('', '$username','$password')");
    var_dump($sql); die;

    return mysqli_affected_rows($conn);
}




?>