Untitled

html:

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <form name="form1" action="process_register.php" method="POST">
            <input type="hidden" name="check_submit" value="1"/>
            Username:<br>
            <input type="text" name="username"><br>
            Password (8 characters at least):<br>
            <input type="password" name="password" maxlength="20"><br><br>

            <br><br>Click the option that you require:<br>
            <input type="radio" name="inputting" value="signin" checked="checked"/>Sign-In
            <input type="radio" name="inputting" value="register" />Register
            <br><br>
            <input type="submit" name="submit">
        </form>
        <?php

        ?>
    </body>
</html>

php:


<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <?php

        $user = $_POST['username'];
        $pass = $_POST['password'];
        $choice = $_POST['inputting'];

        $servername = "localhost";
        $username = "seenanfb";
        $password = "password1234";
        $dbname = "phpDB";

        $conn = new mysqli($servername, $username, $password, $dbname);

        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }
        //echo "Connected successfully";

        $db1 = "CREATE DATABASE phpDBx";
        if ($conn->query($db1) === TRUE) {
            echo "Database created successfully";
        } else {
            //echo "Error creating database: " . $conn->error;
        }

        $table = "CREATE TABLE phpform (
        id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
        username VARCHAR(30) NOT NULL,
        password VARCHAR(20) NOT NULL
        )";

        if ($conn->query($table) === TRUE) {
            echo "Table phpform created successfully";
        } else {
            //echo "Error creating table: " . $conn->error;
        }


        if (strlen($user) < 6){
        echo "Usernames must be at least 6 characters";
        return;
        }
        else
        //echo "Username Accepted";


        if (strlen($pass) < 8){
        echo "Password must be at least 8 characters";
        return;
        }
        else
        //echo "Password Accepted";


        $selectstmt = "SELECT 'username' FROM 'phpform' WHERE 'username' = ?";
        if($choice === "signin")
        {
        $stmt = $conn->prepare($selectstmt);
        $stmt->bind_param('s', $username);
        $stmt->execute();
        $result = $stmt->get_result();
        if($result){
        echo "Hurray, you signed in";
        }
        else
        echo "Sign-In not found. Please register first.";
        }

        $regstmt = "INSERT INTO phpform (username, password) VALUES(?, ?)";
        if($choice === "register")
        {
        if($stmt = $conn->prepare($regstmt))
        {
        $stmt->bind_param('ss', $user, $pass);
        //$stmt->bind_param('s', $pass);
        $stmt->execute();
        //$stmt->bind_result($phpform);
        $result = $stmt->get_result();
        //$stmt->fetch();
        if($result)
        echo "Yay, you registered";
        else
        echo "Registry failed";
        }
        else{
            echo ":(";
            var_dump($user, $pass);
        }
        }


        $conn->close();


        ?>
    </body>
</html>