if(isset($_POST['submit'])){
    $email = mysqli_escape_string($con,$_POST['email']);
    $username = mysqli_escape_string($con,$_POST['username']);
    $password = md5($_POST['password']);
	$phone =$_POST['phone'];
	$alamat=$_POST['alamat];
	$namapersonal=$_POST['namapersonal'];
    $sqlcekemail = "SELECT emailuser FROM bf_user_santara WHERE emailuser = '$email' ";
    $resultcekemail = mysqli_query($con,$sqlcekemail);
    if(!mysqli_num_rows($resultcekemail) > 0){
        $sqlcekusername = "SELECT username FROM bf_user_santara WHERE username = '$username' ";
        $resultcekusername = mysqli_query($con,$sqlcekusername);
        if(!mysqli_num_rows($resultcekusername) > 0){
            $sqlinsertpersonal = "INSERT INTO bf_personal_user (idpersonal,namapersonal,alamat,phone) VALUES ('','$namapersonal','$alamat','$phone') ";
            mysqli_query($con,$sqlinsertpersonal);

            $selectidpersonal = "SELECT max(idpersonal) FROM bf_personal_user LIMIT 1 ";
            $resultselectid = mysqli_query($con,$selectidpersonal);
            $rowidpersonal = mysqli_fetch_assoc($resultselectid);
            $idpersonal = $rowidpersonal['max(idpersonal)'];

            $created = date("Y-m-d H:i:s");

            $sqlinsertuser = "INSERT INTO bf_user_santara (iduser, username, password, emailuser, typeuser, idclient, created_on) VALUES ('','$username','$password','$email', '1', '$idpersonal', '$created') ";
            mysqli_query($con,$sqlinsertuser);

            $sqlinsertclient = "INSERT INTO bf_client (idclient,typeid) VALUES ('$idpersonal','2') ";
            mysqli_query($con,$sqlinsertclient);

            $_SESSION['sukses'] = 1;
            header('location:success.php');
        } else {
            $error = 'Username';
        }
    } else {
        $error = 'E-mail';
    }
}
?>