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); } }