/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

8 votes280 views1 answer
Laravel show routes artisan
PHP
0 vote355 views2 answers
Wordpress wp_logout_url redirect
PHP Wordpress
0 vote352 views1 answer
Laravel Customizing Missing Model Behavior
PHP Laravel
5 votes287 views5 answers
Convert php array to javascript array
PHP
0 vote278 views1 answer
Wordpress php query randomise
PHP
0 vote279 views1 answer
Wc php get acf fields product category
PHP
0 vote320 views2 answers
What is echo 1 < 2 in php
PHP
0 vote288 views2 answers
Php 5.6 xampp
PHP
0 vote322 views1 answer
Wordpress wpdb delete
PHP Wordpress
3 votes346 views1 answer
What is directory_separator in php
PHP