setQuery(" SELECT * FROM tbl_learners "); $cur = $mydb->executeQuery(); $learners = $mydb->num_rows($cur); $mydb->setQuery(" SELECT * FROM tbl_employer "); $cur = $mydb->executeQuery(); $employers = $mydb->num_rows($cur); $mydb->setQuery(" SELECT * FROM tbl_funder "); $cur = $mydb->executeQuery(); $funders = $mydb->num_rows($cur); $mydb->setQuery(" SELECT * FROM tbl_projects "); $cur = $mydb->executeQuery(); $projects = $mydb->num_rows($cur); if(isset($_POST['btnLogin'])){ $user_name = ($_POST['user_name']); $user_pass = sha1(($_POST['user_pass'])); $sql = "SELECT * FROM `tbl_users` WHERE `usr_username`= '". $user_name ."' AND `usr_password` = '". $user_pass ."' "; $mydb->setQuery($sql); $user_found = $mydb->loadSingleResult(); $_SESSION['usr_userID'] = $user_found->usr_userID; $_SESSION['usr_role'] = $user_found->usr_role; $_SESSION['usr_system'] = $user_found->usr_system; $_SESSION['usr_username'] = $user_found->usr_username; $_SESSION['usr_password'] = $user_found->usr_password; $_SESSION['usr_firstName'] = $user_found->usr_firstName; $_SESSION['usr_propID'] = $user_found->usr_propID; $_SESSION['usr_status'] = $user_found->usr_status; $_SESSION['usr_emailVer'] = $user_found->usr_emailVer; $_SESSION['usr_mobileVer'] = $user_found->usr_mobileVer; $_SESSION['usr_employer'] = $user_found->usr_employer; // if ($user_name == '' OR $user_pass == '') { // $message = '