oop.php

<?php
class Library{
public function __construct(){
$this->db = new PDO('mysql:host=localhost;dbname=koperasi','root','');
}
public function loginuser($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;
}
?>