prepare($sql);
$query->execute(array($username,$password));
$row = $query->rowCount();
$fetch = $query->fetch();
if($row > 0) {
$_SESSION['user'] = $fetch['user_id'];
$_SESSION['username'] = $fetch['username'];
$_SESSION['first_name'] = $fetch['first_name'];
$_SESSION['last_name'] = $fetch['last_name'];
$_SESSION['middle_name'] = $fetch['middle_name'];
$_SESSION['department'] = $fetch['department'];
$user_role = $fetch['user_role'];
if($user_role=="student")
{
header("location:cont!!!..._~~@!!form4!student");
}
}else{
echo "
";
}
}else{
echo "
";
}
}
?>