<?php
    $username = $_POST['username'];
    $password = $_POST['password'];
    $password = md5($password);
    $email = $_POST['email'];
    $secret_q = $_POST['secret_q'];
    $answer = $_POST['answer'];
    $validate = $_POST['validate'];

    if(isset($_POST['create'])){
        if($username == null || $password == null || $email == null || $answer == null || $validate != 8){
            echo '<div id="register_error">One, or more fields were not filled out correctly, try again.</div>';
        }
    }

    if(isset($_POST['create'])){
        $query = 'SELECT username, email FROM user_login WHERE username="'.$username.'" OR email="'.$email.'"';
                $result = $objConnect->query($query);
        if ($result->num_rows == 0){



        if($username != null && $password != null && $email != null && $answer != null && $validate == 8){
            $query = "INSERT INTO user_login SET username='$username', password='$password', email='$email', secret_q='$secret_q', answer='$answer', is_admin = 0";
            $result = $objConnect->query($query);
                        header("Location: ?page=usercreate_success");
                        //echo '<div id="register_success">Thank you! Your user has been created!.</div>';
        }
        }
        else {
            echo "Der er allerede en bruger yo!";
        }
    }

?>