"; } else if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $error .= "The format you have entered for you email is invalid
"; }; if(!isset($pass) OR $pass == null) { $error .= "You have not entered a password
"; }; if($error != "" OR $error != null) { $alert = "The following errors are present above:
" . $error . "Please fix these and try again."; } else { $link = mysqli_connect("shareddb1a.hosting.stackcp.net", "cl59-diary", "nXhHC3B/c", "cl59-diary"); //enter db details $email = mysqli_real_escape_string($link, $email); $pass = mysqli_real_escape_string($link, $pass); if(mysqli_connect_error()) { die("Could not connect to server"); } else { if (isset ($_POST["stay_signed_in"])) { setcookie("email_cook", $email, time() + 60 * 60 * 24 * 365); } else { setcookie("email_cook", '', time() - 3600); }; if(isset($_POST["signup_button"])) { $query = "SELECT `email` FROM `users` WHERE `email` = '" . $email . "'"; $result = mysqli_query($link, $query); if(mysqli_num_rows($result) > 0) { $alert = "There is already an account with this email. Login instead!"; } else { $query = "INSERT INTO `users` (`email`, `password`) VALUES ('" . $email . "', '" . password_hash($pass, PASSWORD_DEFAULT) . "')"; if(mysqli_query($link, $query)) { $alert = "You have successfully signed up, try logging in now!"; } else { $alert = "We could not sign you up at this time. Please try again later."; }; }; } else if (isset($_POST["login_button"])) { $query = "SELECT `id`, `email`, `password` FROM `users` WHERE `email` = '" . $email . "'"; $result = mysqli_query($link, $query); $row = mysqli_fetch_array($result); if (password_verify($pass, $row["password"])) { $_SESSION["email"] = $row["email"]; $_SESSION["id"] = $row["id"]; header("Location: login.php"); } else { $alert = "The login details you have provided are incorrect. Please try again. If you have not got an account, click here to Sign up!"; }; }; }; }; }; }; ?> Secret Diary

Click here to return