authentication.php

<?php 
	include 'includes/config.php';

	if (isset($_POST['email'])&&isset($_POST['pass'])) {
		$conn=mysqli_connect($DBServer, $DBUser, $DBPass, $DBName);
        if ($conn->connect_error) {
            trigger_error('Database connection failed: ' .
            $conn->connect_error, E_USER_ERROR);
        }

        $em = $_POST['email'];
        $pw = $_POST['pass'];

		$sql="SELECT * FROM houser where email ='".$em."' AND pass='".$pw."'";

		$result = $conn->query($sql);
		if($result->num_rows > 0){
			while ($row = mysqli_fetch_assoc($result)) {
				$_SESSION['valid'] = true;
	        	$_SESSION['timeout'] = time();
				$_SESSION['email'] = $row['email'];
				$_SESSION['role'] = $row['role'];
				$_SESSION['uname'] = $row['name'];
			}
			if($_SESSION['role']=='user')
			{
				header('Location: index.php');
			}
			else if($_SESSION['role']=='houser')
			{
				header('Location: dashboard.php');
			}
			else if($_SESSION['role']=='admin')
			{
				header('Location: admindashboard.php');
			}
			else
			{
				header('Location: login.php');
			}
		}
		else
		{
			?>
			<script type="text/javascript">
				alert("Invalid Credentails!");
			</script>
			<?php
			header( "refresh:1;url=login.php" );
		}
}
?>