huhha

<?php
class Library{
	public function __construct(){
		$this->db = new PDO('mysql:host=localhost;dbname=bismillah','root','');
	}


	public function loginuser($username, $password) {
		if($this->cekanggota($username)){
			$this->loginanggota($username,$password);
		}else{
			$this->loginpetugas($username,$password);

		}

	}


	public function cekanggota($idAnggota) {
		$result = $this->db->prepare("SELECT * FROM anggota WHERE id_anggota= '$idAnggota'");

		$result->bindParam(1, $idAnggota);
		$result->execute();
		if($result->fetchColumn()>0){
			return true;
		}
		return false;
	}

	public function loginpetugas($username, $password) {

		$result = $this->db->prepare("SELECT * FROM user WHERE username='$username' AND password= '$password'");
		$result->bindParam(1, $username);
		$result->bindParam(2, $password);
		$result->execute();
		$rows = $result->fetch();
		return $rows;
	}


	public function loginanggota($id_anggota, $nama) {
		$result = $this->db->prepare("SELECT * FROM anggota WHERE nama='$nama' AND id_anggota= '$id_anggota'");
		$result->bindParam(1, $username);
		$result->bindParam(2, $password);
		$result->execute();
		$rows = $result->fetch();
		return $rows;
	}