Buat Form regisrtasi.php
</html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>REGISTRASI ACCOUNT</title>
</head>
<body class="bg-gradient-primary">
<div class="container">
<!-- Outer Row -->
<div class="row justify-content-center">
<div class="col-xl-4 col-lg-6 col-md-5">
<br>
<div class="card o-hidden border-0 shadow-lg my-5">
<div class="card-body p-0">
<!-- Nested Row within Card Body -->
<div class="row">
<div class="col-lg-6 d-none d-lg-block"></div>
<div class="col-lg-12">
<div class="p-4">
<div class="text-center">
<div class="alert alert-success " role="alert"> <i class="fas fa-fw fa-users"></i>
FORM REGISTRASI ACCOUNT
</div>
<form method="post" action="" >
<div class="form-group"> <strong>Username</strong> </div>
<div class="form-group">
<input class="form-control" type="text" name="username" required="Data harus diisi" ></div>
<div class="form-group"> <strong>Password</strong><div>
<div class="form-group">
<input class="form-control" type="password" name="password" required="Data harus diisi" ></div>
<div class="form-group"> <strong>Konfirmasi Password</strong><div>
<div class="form-group">
<input class="form-control" type="password" name="password2" required="Data harus">
<input type="hidden" name="level" value="Siswa" >
<input type="hidden" name="id_sesion" value="Siswa" >
<button class="btn btn-primary" type="submit" name="register">Simpan</button>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
kemudian uat file dengan nama function.php
<?php
include "config_conn.php";
function registrasi ($data){
global $koneksi;
$username = strtolower(stripcslashes($data["username"]));
$password = mysqli_real_escape_string ($koneksi, $data["password"]);
$password2 = mysqli_real_escape_string ($koneksi, $data["password2"]);
$level = ($data["level"]);
$id_sesion = ($data["id_sesion"]);
//Cek username sudah tersedia atau belum
$result = mysqli_query ($koneksi, "SELECT username FROM data_user WHERE username = '$username' " );
if( mysqli_fetch_assoc ($result) ) {
echo "<script>
alert ('Username yang anda pilih sudah terdaftar')
</script>";
return false;
}
//cek konfirmasi pasword
if($password !== $password2){
echo "<script>
alert ('Konfirmasi password tidak sesuai');
</script>";
return false;
}
// Enskripsi password
$password = password_hash($password, PASSWORD_DEFAULT);
// tambahkan data User
mysqli_query($koneksi, "INSERT INTO data_user VALUES ('', '$username', '$password', '$level', '$id_sesion') ");
return mysqli_affected_rows ($koneksi);
}
?>
</html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>REGISTRASI ACCOUNT</title>
</head>
<body class="bg-gradient-primary">
<div class="container">
<!-- Outer Row -->
<div class="row justify-content-center">
<div class="col-xl-4 col-lg-6 col-md-5">
<br>
<div class="card o-hidden border-0 shadow-lg my-5">
<div class="card-body p-0">
<!-- Nested Row within Card Body -->
<div class="row">
<div class="col-lg-6 d-none d-lg-block"></div>
<div class="col-lg-12">
<div class="p-4">
<div class="text-center">
<div class="alert alert-success " role="alert"> <i class="fas fa-fw fa-users"></i>
FORM REGISTRASI ACCOUNT
</div>
<form method="post" action="" >
<div class="form-group"> <strong>Username</strong> </div>
<div class="form-group">
<input class="form-control" type="text" name="username" required="Data harus diisi" ></div>
<div class="form-group"> <strong>Password</strong><div>
<div class="form-group">
<input class="form-control" type="password" name="password" required="Data harus diisi" ></div>
<div class="form-group"> <strong>Konfirmasi Password</strong><div>
<div class="form-group">
<input class="form-control" type="password" name="password2" required="Data harus">
<input type="hidden" name="level" value="Siswa" >
<input type="hidden" name="id_sesion" value="Siswa" >
<button class="btn btn-primary" type="submit" name="register">Simpan</button>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
kemudian uat file dengan nama function.php
<?php
include "config_conn.php";
function registrasi ($data){
global $koneksi;
$username = strtolower(stripcslashes($data["username"]));
$password = mysqli_real_escape_string ($koneksi, $data["password"]);
$password2 = mysqli_real_escape_string ($koneksi, $data["password2"]);
$level = ($data["level"]);
$id_sesion = ($data["id_sesion"]);
//Cek username sudah tersedia atau belum
$result = mysqli_query ($koneksi, "SELECT username FROM data_user WHERE username = '$username' " );
if( mysqli_fetch_assoc ($result) ) {
echo "<script>
alert ('Username yang anda pilih sudah terdaftar')
</script>";
return false;
}
//cek konfirmasi pasword
if($password !== $password2){
echo "<script>
alert ('Konfirmasi password tidak sesuai');
</script>";
return false;
}
// Enskripsi password
$password = password_hash($password, PASSWORD_DEFAULT);
// tambahkan data User
mysqli_query($koneksi, "INSERT INTO data_user VALUES ('', '$username', '$password', '$level', '$id_sesion') ");
return mysqli_affected_rows ($koneksi);
}
?>
