Advertisement
Guest User

Untitled

a guest
Jun 14th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.21 KB | None | 0 0
  1. <?php
  2. session_start();
  3.  
  4. class Admin {
  5.   private $username;
  6.   private $password;
  7.   private $conn;
  8.  
  9.   public function __construct($conn=NULL) {
  10.     $this->conn = $conn;
  11.   }
  12.  
  13.   public function adminExists($username,$password) {
  14.     $adminQuery = mysql_query("SELECT id, username, password FROM admin WHERE username='".$username."' AND password='".md5($password)."'") or die ('Admin Query Error --- MySQL Error No: '.mysql_errno().' --- '.mysql_error());
  15.     $count = mysql_num_rows($adminQuery);
  16.     $adminRow = mysql_fetch_assoc($adminQuery);
  17.     $uid = $adminRow['id'];
  18.     $exists = ($count > 0 ? 1 : 0);
  19.     $result = array('exists'=>$exists,'uid'=>$uid,'count'=>$count);
  20.     return $result;
  21.   }
  22.  
  23.   public function adminLoggedin($uid) {
  24.       $loggedQuery = mysql_query("SELECT COUNT(*), id, uid, loggedIn, loggedOut FROM adminLog WHERE uid='".$uid."' AND ISNULL(loggedOut)") or die ('Logged In Query Error --- MySQL Error No: '
  25.               .mysql_errno().' --- '.mysql_error());
  26.       $loggedRow = mysql_fetch_array($loggedQuery);
  27.       $count = ($loggedRow['COUNT(*)'] > 0 ? 1 : 0);
  28.       $logID = $loggedRow['id'];
  29.       $logged = array('count'=>$count,'logID'=>$logID);
  30.       return $logged;
  31.   }
  32.  
  33. }
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement