/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 vote344 views1 answer
Laravel create project with auth 2021
PHP Laravel
1 vote309 views1 answer
Php check regular string
PHP
7 votes316 views3 answers
Self submit form php
PHP
44 votes397 views6 answers
Laravel migrate seed
PHP Laravel
0 vote297 views1 answer
Why php is not using datatype
PHP
8 votes333 views1 answer
Laravel symlink command
PHP
8 votes375 views1 answer
Laravel custom attributes
PHP
14 votes368 views2 answers
Laravel change value to intger
PHP Laravel
4 votes363 views6 answers
Create middleware laravel
PHP
1 vote325 views1 answer
Google client php get inbox messages
PHP