id = $params['id']; $this->username = $params['username']; $this->password = $params['password']; } else { $this->id = 0; $this->username = ''; $this->password = ''; } } public static function find($id) { if(is_object($id)) { $id = $id->id(); } if($id == null) { return null; } $sql = "select * from `admin` where id='".$id."'"; $result = mysql_query($sql); $rec = mysql_fetch_assoc($result); if($rec) { return new Admin($rec); } else { return null; } } public static function find_admin($id=null) { if($id) # search for specific category { $sql = "SELECT * from admin WHERE id='".$id."'"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); return new Admin($row); } else # search for all categories { $admins = array(); $sql = "SELECT * FROM admin"; $result = mysql_query($sql); while($row = mysql_fetch_assoc($result)) { $admins[] = new Admin($row); } return $admins; } } public static function authenticate($username,$password) { echo "UName : ".$username."
"; echo "Pwd : ".$password; $sql = "select * from `admin` where username ='" . $username . "' and password='" . $password . "'"; $result = mysql_query($sql); if($rec = mysql_fetch_assoc($result)) { $admin = new Admin($rec); return $admin; } else { return false; } } public function username() { return $this->username; } public function id() { return $this->id; } public function password() { return $this->password; } public function save() { if($this->id == 0) # got new object run insert query { $sql = "INSERT INTO admin (`username`,`password`)VALUE('$this->username','$this->password')"; mysql_query($sql); $this->id = mysql_insert_id(); } else { $sql = "UPDATE admin SET `username` = '$this->username', `password` = '$this->password' WHERE id=$this->id"; mysql_query($sql); } } public function update($params) { $this->username = $params['username']; $this->password = $params['password']; } public function delete() { $sql = "DELETE FROM admin WHERE id=$this->id"; mysql_query($sql); } } ?>