Created
April 7, 2016 05:02
-
-
Save alxngyn/bef06bf300c6d08a8953af0fb5a5eab6 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php include("static/header.php"); ?> | |
<?php | |
require_once('dbConVars.php'); | |
// Connect to the database | |
$dbc = mysqli_connect($DB_HOST, $DB_USER, $DB_PASSWORD, $DB_NAME); | |
if (isset($_POST['submit'])) { | |
// Grab the profile data from the POST | |
$userName = mysqli_real_escape_string($dbc, trim($_POST['username'])); | |
$password1 = mysqli_real_escape_string($dbc, trim($_POST['password'])); | |
$firstName = mysqli_real_escape_string($dbc, trim($_POST['firstName'])); | |
$lastName = mysqli_real_escape_string($dbc, trim($_POST['lastName'])); | |
if (!empty($userName) && !empty($password1)) { | |
// Make sure someone isn't already registered using this username | |
$query = "SELECT * FROM CS290_Users WHERE userName = '$userName'"; | |
$data = mysqli_query($dbc, $query); | |
if (mysqli_num_rows($data) == 0) { | |
// sha1 the password | |
$password1 = sha1($password1); | |
// The username is unique, so insert the data into the database | |
$query = "INSERT INTO CS290_Users (userName, password, firstName, lastName) VALUES ('$userName', '$password1', '$firstName' , '$lastName')"; | |
if( mysqli_query($dbc, $query) ){ | |
// Confirm success with the user | |
echo '<p>Your new account has been successfully created. You\'re now ready to log in.</p>'; | |
} else { | |
echo '<p>Error, could not insert to database. Error:' . mysqli_error() .' </p>'; | |
} | |
mysqli_close($dbc); | |
exit(); | |
} | |
else { | |
// An account already exists for this username, so display an error message | |
echo '<p class="error">An account already exists for this username. Please use a different username.</p>'; | |
$userName = ""; | |
} | |
} | |
else { | |
echo '<p class="error">You must enter all of the sign-up data.</p>'; | |
} | |
} | |
mysqli_close($dbc); | |
?> | |
<div class="container"> | |
<div class="col-lg-4 col-lg-offset-4 form-group"> | |
<form method="post" class="form-signin" name="form" onsubmit="return validate(this);" action="<?php echo $_SERVER['PHP_SELF']; ?>"> | |
<h2 class="form-signup-heading">Sign up</h2> | |
<label for="firstName" class="sr-only">First Name</label> | |
<input type="text" id="firstName" name="firstName" class="form-control" placeholder="First name" required autofocus> | |
<label for="lastName" class="sr-only">Last Name</label> | |
<input type="text" id="lastName" name="lastName" class="form-control" placeholder="Last name" required> | |
<label for="username" class="sr-only">Username</label> | |
<input type="text" id="username" name="username" class="form-control" placeholder="Username" required> | |
<label for="password" class="sr-only">Password</label> | |
<input type="password" id="password" name="password" class="form-control" placeholder="Password" required> | |
<button class="btn btn-lg btn-primary btn-block" type="submit" name="submit">Sign up</button> | |
</form> | |
<script type="text/javascript" src="js/signup.js"></script> | |
</div> | |
</div> | |
<?php include("static/footer.php"); ?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment