<?php

include './connect.php';

    if(array_key_exists("submit", $_POST)) {

        print_r($_POST);

        $error= "";

        if(!$_POST["email"]) {
            $error .= "An email address is required!<br>";
        }

        if(!$_POST["password"]) {
            $error .= "A password is required!<br>";
        }

        if($error != "") {
            $error = "<p>There were error(s) in your form: </p>".$error."<br>";
        } else {

            $query = "SELECT id FROM `users` WHERE email = '".$db_real_escape_string($link, $_POST['email'])."' LIMIT 1";

            $result = $db_query($link, $query);

            if($db_num_rows($result) > 0) {
                $error = "That email address already exists!";
            } else {
                $query = "INSERT INTO `users` (`email`, `password`) VALUES
                ('".$db_real_escape_string($link, $_POST['email'])."',
                '".$db_real_escape_string($link, $_POST['password'])."')";

                if ($db_query($link, $query)) {
                    $error = "<p>Could not sign you up, please try again later</p>";
                } else {
                    echo "Sign up successful!";
                }
            }
        }
    }

?>

<div id="error"><?php echo $error; ?></div>

<form method="POST">
    <input type="email" name="email" placeholder="Your email" />
    <input type="password" name="password" placeholder="Password" />
    <input type="checkbox" name="stayLoggedIn" value=1 />
    <input type="submit" name="submit" value="Sign Up!" />
</form>

<?php

    $servername = getenv('IP');
    $username = getenv('C9_USER');
    $password = '';
    $database = 'c9';
    $dbport = 3306;

    $db = new mysqli($servername, $username, $password, $database, $dbport);

    if($db->connect_error) {
        die("Connection failed: ".$db->connect_error);
    } else {
        echo "Connected successfully (".db_host_info.")";
    }
?>