/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

1 vote262 views2 answers
Laravel collection isNotEmpty
PHP Laravel
4 votes255 views2 answers
Laravel blade errors all
PHP
0 vote272 views1 answer
How to setup php mailer
PHP
0 vote259 views1 answer
Laravel development serve doesn't stop
PHP
5 votes287 views3 answers
How get some parameter from request in laravel
PHP
0 vote287 views1 answer
Join with 2 table where id match in table 1 comma separated
PHP
3 votes263 views2 answers
Case statement in php
PHP
0 vote253 views1 answer
Date between query in codeigniter
PHP
0 vote290 views1 answer
Set cookie on button click JavaScript
PHP
0 vote274 views1 answer
How to validate multi image upload in laravel
PHP