/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 vote222 views1 answer
Php ord deprecated
PHP
0 vote307 views1 answer
Wordpress set category front end
PHP Wordpress
0 vote300 views1 answer
How to use custome functions in laravel
PHP Laravel
3 votes241 views1 answer
Detecting russian characters on a form in PHP
PHP
0 vote230 views1 answer
Best Security tools for php
PHP
1 vote253 views2 answers
Linux set alternatives /etc/alternatives
PHP
-1 vote236 views3 answers
Remove duplicate characters in a string in php
PHP
2 votes277 views1 answer
Wordpress custom fields variable dump
PHP Wordpress
13 votes232 views2 answers
If condition in php
PHP
3 votes320 views1 answer
Laravel validation number greater than 0
PHP