public static function getPublisher($publisher_id)
{
global $db;
$query = 'SELECT * FROM publishers WHERE publisherID = :publisher_id';
try {
$statement = $db->prepare($query);
$statement->bindValue(':publisher_id', $publisher_id);
$statement->execute();
$row = $statement->fetch();
$statement->closeCursor();
$publisher = new Publisher($row['publisherID'], $row['publisherName']);
return $publisher;
} catch (PDOException $e) {
$error_message = $e->getMessage();
DBContext::displayDBError($error_message);
}
}
function is_array($fname, $lname, $dob)
{
global $db;
$query = 'SELECT userID FROM users
WHERE fname = :fname AND lname= :lname AND dob = :dob AND isAdmin = 1';
try {
$statement = $db->prepare($query);
$statement->bindValue(':fname', $fname);
$statement->bindValue(':lname', $lname);
$statement->bindValue(':dob', $dob);
$statement->execute();
$valid = $statement->rowCount() >= 1;
$statement->closeCursor();
} catch (PDOException $e) {
$error_message = $e->getMessage();
DBContext::displayDBError($error_message);
}
return $valid;
}
public static function addBook($book)
{
global $db;
$query = 'INSERT INTO books
(publisherID, isbn, bookTitle, bookPrice)
VALUES
(:publisher_id, :isbn, :title, :price)';
try {
$statement = $db->prepare($query);
$statement->bindValue(':publisher_id', $publisher_id);
$statement->bindValue(':isbn', $isbn);
$statement->bindValue(':title', $title);
$statement->bindValue(':price', $price);
$statement->execute();
$statement->closeCursor();
// Get the last product ID that was automatically generated
$book_id = $db->lastInsertId();
return $book_id;
} catch (PDOException $e) {
$error_message = $e->getMessage();
DBContext::displayDBError($error_message);
}
}
