php

connect.php code:
<?php

    $conn = mysqli_connect("localhost","root","1234","User");

    if($conn -> connect_error){
        die("connection failed: ".$conn.connect_error);
    }else{
        echo "connection successful";
    }


 ?>

regist.php code:

<html>
<head>
    <title> Register  </title>
</head>
<body>

    <form action="doReg.php" method="post">

        Username: <input type="text" name="txtuser" placeholder="Username"><br>
        Password: <input type="password" name="txtpass" placeholder="Password"><br>
        <input type="submit" value="Register">


    </form>
        <p color: "red"><?php if(isset($_GET["err"])) echo $_GET["err"];  ?>
</body>

</html>


doRegist.php code:


<?php
include("connect.php");

    $user=$_POST["txtuser"];
    $pass=$_POST["txtpass"];

if($user == ""){
    header("Location: regist.php?err=Username tidak boleh kosong");

}else if($pass == ""){
    header("Location: regist.php?err=Password tidak boleh kosong");
}else{

    $query = "INSERT INTO MsMember (username,password) VALUES ('$user','$pass','user')";
    mysqli_query($conn,$query);
    header("Location: regist.php?err=Register Success!");
}
?>