Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require '../api/dbcon.php';
- require '../api/apiOnly.php';
- if(session_id() == '' || !isset($_SESSION)) {
- // session isn't started
- session_start();
- }
- //FACULTY - USER LOGIN
- if(isset($_POST['login'])){
- //do query here
- $stmt = $conn->prepare('SELECT username, campus, designation FROM accounts where username = ? AND password = ? ');
- $stmt->bind_param('ss', $u, $p);
- $u=$_POST['username'];
- $p=md5($_POST['password']);
- $stmt->execute();
- $stmt->bind_result($username,$campus, $designation);
- if($stmt->fetch()>0){
- $_SESSION['usr_fullname'] = $username;
- $_SESSION['usr_type'] = $designation;
- $_SESSION['usr_campus'] = $campus;
- if($_SESSION['usr_type']=='admin'){
- header('location: home.php');
- exit();
- }else if($_SESSION['usr_type']=='director'){
- header('location: director-index.php');
- exit();
- }
- }else{
- $faculty = json_decode($api->authenticate_student($_POST['username'],$_POST['password']),true);
- if(!empty($faculty[0]['usr_fullname'])){
- $_SESSION['usr_fullname'] = $faculty[0]['usr_fullname'];
- $_SESSION['usr_type'] = 'faculty';
- header('location: faculty-index.php');
- }else{
- echo "<script type='text/javascript'>
- alert ('Username and Password unmatched!');
- window.location.href='login.php';</script>";
- }
- }
- $stmt->close();
- $conn->close();
- }
- ?>
- <?php
- if(session_id() == '' || !isset($_SESSION)) {
- // session isn't started
- session_start();
- }
- error_reporting(E_ALL & E_STRICT);
- ini_set('display_errors', '1');
- ini_set('log_errors', '0');
- ini_set('error_log', './');
- $dbhost = 'localhost';
- $dbuser = '------';
- $dbpass = '-----';
- $dbtable = "------";
- $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbtable);
- if(!$conn ){
- die('Could not connect: ' . mysqli_error());
- }
- ?>
- if(session_id() == '' || !isset($_SESSION)) {
- // session isn't started
- session_start();
- }
Add Comment
Please, Sign In to add comment