function.php

<?php

 //koneksi ke database

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

 function query($query) {
    global $conn;
    $result = mysqli_query($conn, $query);
    $row = [];
    while( $row = mysqli_fetch_assoc($result) ) {
        $rows[] = $row;
    }
    return $rows;
 }


function register($data) {
    global $conn;

    $username = strtolower (stripslashes($data["username"]) );
    $password = mysqli_real_escape_string($conn, $data["password"]);
    $password2 = mysqli_real_escape_string($conn, $data["password2"]);
    $email = htmlspecialchars($data["email"]);
    $notelp = htmlspecialchars($data["notelp"]);
    $kategori = htmlspecialchars($data["kategori"]);




    // 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 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);

    //tambahkan userbaru ke database
    mysqli_query($conn, "INSERT INTO users VALUES('','$username','$password','$email','$notelp','$kategori')");

    return mysqli_affected_rows($conn);

}










?>