/PHP/Login page php mysql check if user is verified in the database before user can be logged in

Login page php mysql check if user is verified in the database before user can be logged in

// call the login() function if register_btn is clicked
if (isset($_POST['login_btn'])) {
	login();
}

// LOGIN USER
function login(){
	global $db, $username, $errors;

	// grap form values
	$username = e($_POST['username']);
	$password = e($_POST['password']);

	// make sure form is filled properly
	if (empty($username)) {
		array_push($errors, "Username is required");
	}
	if (empty($password)) {
		array_push($errors, "Password is required");
	}

	// attempt login if no errors on form
	if (count($errors) == 0) {
		$password = md5($password);

		$query = "SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1";
		$results = mysqli_query($db, $query);

		if (mysqli_num_rows($results) == 1) { // user found
			// check if user is admin or user
			$logged_in_user = mysqli_fetch_assoc($results);
			if ($logged_in_user['user_type'] == 'admin') {

				$_SESSION['user'] = $logged_in_user;
				$_SESSION['success']  = "You are now logged in";
				header('location: admin/home.php');		  
			}else{
				$_SESSION['user'] = $logged_in_user;
				$_SESSION['success']  = "You are now logged in";

				header('location: index.php');
			}
		}else {
			array_push($errors, "Wrong username/password combination");
		}
	}
}

Source: codewithawa.com

Similar codes

0 vote107 views1 answer
Comment installer laravel avec docker
PHP
0 vote91 views1 answer
Laravel string capitalize in view
PHP
1 vote78 views1 answer
Redirect from laravel controller to another link
PHP Laravel
1 vote106 views3 answers
Laravel model to array
PHP
0 vote95 views1 answer
WithErrors laravel
PHP
1 vote117 views1 answer
Get the category wp
PHP Wordpress
0 vote119 views1 answer
Loop object property laravel
PHP Laravel
0 vote101 views1 answer
WP_Query
PHP
2 votes133 views1 answer
Laravel Call to a member function diffForHumans() on string
PHP Laravel
28 votes105 views6 answers
Laravel make model with migration
PHP