Untitled

ob_start();
session_start();
if (isset($_SESSION['user']) != "") {
    header("Location: formulario.php");
}
$conn = mysqli_connect("localhost", "root", "admin", "usersregistados");

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$error = false;

if (isset($_POST['Inserir'])) {

    // Prevent SQL Injection

    $username = trim($_GET['username']);
    $username = strip_tags($username);
    $username = htmlspecialchars($username);

    $password = trim($_GET['password']);
    $password = strip_tags($password);
    $password = htmlspecialchars($password);

    $email = trim($_GET['email']);
    $email = strip_tags($email);
    $email = htmlspecialchars($email);

    // Check username
    if (empty($username)) {
        $error         = true;
        $usernameError = "Please fill in this field!";
    } else {
        // Does email address exist?
        $query  = "SELECT username FROM users WHERE username='{$username}'";
        $result = mysqli_query($query);
        $count  = mysqli_num_rows($result);
        if ($count != 0) {
            $error         = true;
            $usernameError = "Username is taken!";
        }
    }

    // Check email
    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        $error      = true;
        $emailError = "Please enter valid email address.";
    } else {
        // Does email address exist?
        $query  = "SELECT email FROM users WHERE email='{$email}'";
        $result = mysqli_query($query);
        $count  = mysqli_num_rows($result);
        if ($count != 0) {
            $error      = true;
            $emailError = "Email is already in use!";
        }
    }

    // password validation
    if (empty($password)) {
        $error     = true;
        $passError = "Please fill in this field!";
    } else if (strlen($password) < 6) {
        $error     = true;
        $passError = "Field must contain at least 6 characters!";
    }

    // password encrypt using SHA256();
    $password = hash('sha256', $password);

    // if there's no error, continue to signup
    if (!$error) {

        $query = "INSERT INTO users (username, password, email) VALUES ('{$username}', '{$password}', '{$email}')";
        $res = mysqli_query($conn, $query) or die(mysqli_error());

        if ($res) {
            $errTyp = "success";
            $errMSG = "Successfully registered, you may login now";
            unset($name);
            unset($email);
            unset($pass);
        } else {
            $errTyp = "danger";
            $errMSG = "Something went wrong, try again later...";
        }

    }
}
?>

<?php
session_start();
?>

    <!DOCTYPE html>
    <html>

    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,400,700" rel="stylesheet">
        <link rel="stylesheet" href="css/bulma.min.css" />
        <link rel="stylesheet" type="text/css" href="css/login.css">
    </head>

    <body>
        </form>
        <section class="hero is-success is-fullheight">
            <div class="hero-body">
                <div class="container has-text-centered">
                    <img src="ipcb_logo.png" height="40" width="150">
                    <div class="column is-4 is-offset-4">
                        <h3 class="title has-text-grey">Formulário de Registo</h3>
                        <div class="box">
                            <form action="insere.php" method="POST">
                                <div class="field">
                                    <div class="control">
                                        <input name="username" class="input is-large" placeholder="Your Username" autofocus="">
                                    </div>
                                </div>
                                <div class="field">
                                    <div class="control">
                                        <input name="password" class="input is-large" type="password" placeholder="Your Password">
                                    </div>
                                </div>
                                <div class="field">
                                    <div class="control">
                                        <input name="email" name="text" class="input is-large" placeholder="Your Email" autofocus="">
                                    </div>
                                </div>
                                <div class="input-group">
                                    <butto>
                                        <p>
                                            <input name="inserir" class="button is-block is-link is-large is-fullwidth" type="submit" value="Inserir" </p>
                                            </button>
                                </div>
                            </form>
                        </div>
                        <img src="produtech_logo.png" height="40" width="300" align="middle"></p>
                        <br>
                        <img src="Logo_financiamento.png" height="40" width="300" align="middle"></p>
                    </div>
                </div>
        </section>
    </body>

    </html><?php
session_start();
?>

    <!DOCTYPE html>
    <html>

    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,400,700" rel="stylesheet">
        <link rel="stylesheet" href="css/bulma.min.css" />
        <link rel="stylesheet" type="text/css" href="css/login.css">
    </head>

    <body>
        </form>
        <section class="hero is-success is-fullheight">
            <div class="hero-body">
                <div class="container has-text-centered">
                    <img src="ipcb_logo.png" height="40" width="150">
                    <div class="column is-4 is-offset-4">
                        <h3 class="title has-text-grey">Formulário de Registo</h3>
                        <div class="box">
                            <form action="insere.php" method="POST">
                                <div class="field">
                                    <div class="control">
                                        <input name="username" class="input is-large" placeholder="Your Username" autofocus="">
                                    </div>
                                </div>
                                <div class="field">
                                    <div class="control">
                                        <input name="password" class="input is-large" type="password" placeholder="Your Password">
                                    </div>
                                </div>
                                <div class="field">
                                    <div class="control">
                                        <input name="email" name="text" class="input is-large" placeholder="Your Email" autofocus="">
                                    </div>
                                </div>
                                <div class="input-group">
                                    <button>
                                        <p>
                                            <input name="inserir" class="button is-block is-link is-large is-fullwidth" type="submit" value="Inserir" </p>
                                            </button>
                                </div>
                            </form>
                        </div>
                        <img src="produtech_logo.png" height="40" width="300" align="middle"></p>
                        <br>
                        <img src="Logo_financiamento.png" height="40" width="300" align="middle"></p>
                    </div>
                </div>
        </section>
    </body>

    </html>