<?php
if(isset($_POST['register'])) {
    $username      = htmlentities($_POST['username'], ENT_QUOTES);
    $usernamel     = strtolower($username);
    $password      = htmlentities($_POST['password'], ENT_QUOTES);
    $password_hash = password_hash($password, PASSWORD_BCRYPT);
    $email         = htmlentities($_POST['email'], ENT_QUOTES);
    $ip            = $_SERVER['REMOTE_ADDR'];
    $time          = date("Y-m-d");

    if($username == ""){
        echo "Username is empty";
        exit;
    }

    if($password == ""){
        echo "Password is empty";
        exit;
    }

    if($email == ""){
        echo "Email is empty";
        exit;
    }

    if (strlen($username) < 10 && preg_match('/[^a-z0-9]+/i', $username) < 1) {
        if (strlen($password) > 8) {
            $mysqli_query  = sprintf("SELECT username FROM users WHERE username = '$username'", mysqli_real_escape_string($db_mysqli, $username));
            $conn         = $db_mysqli->query($mysqli_query);

            if ($conn->num_rows <= 0) {
                $conn->close();
                $mysqli_query = sprintf("SELECT email FROM users WHERE email = '$email'", mysqli_real_escape_string($db_mysqli, $email));
                $conn         = $db_mysqli->query($mysqli_query);

                if ($conn->num_rows <= 0) {
                    $conn->close();
                    $stmt = $db_mysqli->prepare("INSERT INTO users (username, password, email, date, ip) VALUES (?, ?, ?, ?, ?)");
                    $stmt->bind_param("sssss", $username1, $password_hashed, $email, $time, $ip);
                    $stmt->execute();
                    $stmt->close();

                    echo "<center>Registered, redirecting in 3 seconds.</center>";
                    echo "<meta http-equiv='refresh' content='3;url=index.php'>";
                }


            } else {
                $stmt->close();
                echo "Email is already in use.";
                exit;
            }
        } else {
            $stmt->close();
            echo "Username is already in use.";
            exit;
        }
    }
    else {
        $stmt->close();
        echo "Password isnt enough strong, minimum is 8.";
        exit;
    }
}
else {
    $stmt->close();
        echo "Username needs to be less than 10 and cant contains special characters.";
    exit;
}
    ?>