Skip to content

Instantly share code, notes, and snippets.

@nielsmh
Forked from InukVT/login.php
Last active January 12, 2017 18:02
Show Gist options
  • Save nielsmh/4f08af0e1e6400d5d05fa1f57f6d6835 to your computer and use it in GitHub Desktop.
Save nielsmh/4f08af0e1e6400d5d05fa1f57f6d6835 to your computer and use it in GitHub Desktop.
$username = $_POST['username'];
$password = $_POST['password'];
$username = stripslashes($username);
$username = mysqli_real_escape_string($db, $username);
$sql = "SELECT * FROM users WHERE username='$username'";
$res = mysqli_query($db, $sql) or die(mysqli_error($db));
if (mysqli_num_rows($res) > 0)
{
$row = mysqli_fetch_assoc($res);
$hash = $row['password'];
if (password_verify($password, $hash))
{
$_SESSION['username'] = $username; // Initializing Session
header("location: $uri_cookie"); // Redirecting To Other Page
$error = "Your username is: $username";
$_SESSION['role'] = $row['role']; //////// allerede hentet i den originale SELECT *
$admin = $_SESSION['role'];
echo "$admin";
}
else {
$error = "Incorrect username or password.<br>".$hash. "<br>" .$password;
}
}
$username = $_POST['username'];
$password = $_POST['password'];
// To protect from MySQL injection
$username = mysqli_real_escape_string($db, $username);
$hash = password_hash($password, PASSWORD_DEFAULT);
//Check username and password from database
$sql = "INSERT INTO users(`username`,`password`,`role`) VALUES ('$username','$hash','0')";
if(mysqli_query($db, $sql))
{
//Code here for successful login!
$register = true;
}
else
{
//Error code, should be removed before primetime!
echo "Something happened!<br>".mysqli_error($db);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment