Guest User

Untitled

a guest
Nov 25th, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. <?php
  2. require '../api/dbcon.php';
  3. require '../api/apiOnly.php';
  4.  
  5. if(session_id() == '' || !isset($_SESSION)) {
  6. // session isn't started
  7. session_start();
  8. }
  9.  
  10. //FACULTY - USER LOGIN
  11.  
  12.  
  13. if(isset($_POST['login'])){
  14. //do query here
  15. $stmt = $conn->prepare('SELECT username, campus, designation FROM accounts where username = ? AND password = ? ');
  16. $stmt->bind_param('ss', $u, $p);
  17. $u=$_POST['username'];
  18. $p=md5($_POST['password']);
  19. $stmt->execute();
  20. $stmt->bind_result($username,$campus, $designation);
  21. if($stmt->fetch()>0){
  22. $_SESSION['usr_fullname'] = $username;
  23. $_SESSION['usr_type'] = $designation;
  24. $_SESSION['usr_campus'] = $campus;
  25. if($_SESSION['usr_type']=='admin'){
  26. header('location: home.php');
  27. exit();
  28. }else if($_SESSION['usr_type']=='director'){
  29. header('location: director-index.php');
  30. exit();
  31. }
  32.  
  33. }else{
  34. $faculty = json_decode($api->authenticate_student($_POST['username'],$_POST['password']),true);
  35. if(!empty($faculty[0]['usr_fullname'])){
  36. $_SESSION['usr_fullname'] = $faculty[0]['usr_fullname'];
  37. $_SESSION['usr_type'] = 'faculty';
  38. header('location: faculty-index.php');
  39. }else{
  40. echo "<script type='text/javascript'>
  41. alert ('Username and Password unmatched!');
  42. window.location.href='login.php';</script>";
  43. }
  44.  
  45.  
  46.  
  47. }
  48. $stmt->close();
  49. $conn->close();
  50.  
  51. }
  52.  
  53. ?>
  54.  
  55. <?php
  56. if(session_id() == '' || !isset($_SESSION)) {
  57. // session isn't started
  58. session_start();
  59. }
  60. error_reporting(E_ALL & E_STRICT);
  61. ini_set('display_errors', '1');
  62. ini_set('log_errors', '0');
  63. ini_set('error_log', './');
  64.  
  65. $dbhost = 'localhost';
  66. $dbuser = '------';
  67. $dbpass = '-----';
  68. $dbtable = "------";
  69. $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbtable);
  70.  
  71. if(!$conn ){
  72. die('Could not connect: ' . mysqli_error());
  73. }
  74. ?>
  75.  
  76. if(session_id() == '' || !isset($_SESSION)) {
  77. // session isn't started
  78. session_start();
  79. }
Add Comment
Please, Sign In to add comment