/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 vote135 views6 answers
Check if all values in array are equal php
PHP
32 votes192 views1 answer
How to count the characters in laravel
PHP Laravel
2 votes160 views2 answers
Factorial function php
PHP
0 vote154 views2 answers
Php constant
PHP
0 vote167 views1 answer
Create a text file in laravel
PHP
0 vote159 views1 answer
PaymentIntent::create laravel
PHP
0 vote156 views1 answer
Read file and convert each line in array php
PHP
0 vote201 views1 answer
Multiple databases user validation in Laravel
PHP Laravel
0 vote192 views1 answer
Boot add schema in laravel
PHP
127 votes278 views6 answers
Php parse json
PHP