public static function getBook($book_id)
{
global $db;
$query = 'SELECT * FROM books WHERE bookID = :book_id';
try {
$statement = $db->prepare($query);
$statement->bindValue(':book_id', $book_id);
$statement->execute();
$row = $statement->fetch();
$statement->closeCursor();
$publisher = PublisherRepository::getPublisher($row['publisherID']);
$book = new Book($row['isbn'], $row['bookTitle'], $row['bookPrice'], $publisher);
$book->setID($row['bookID']);
return $book;
} catch (PDOException $e) {
$error_message = $e->getMessage();
DBContext::displayDBError($error_message);
}
}
<?php
/*
* Student Info: Name=Chapadia Shruti, ID=15574CS
* Subject: CS526(B)_HWNo3_Summer_2016
* Author: shruti
* Filename: add_book.php
* Date and Time: Jul 27, 2016 10:29:09 AM
* Project Name: BookstoreMVC_Authentication_update
*/
$addBookSubmitted = isset($_POST['addbook_submitted']);
if ($addBookSubmitted) {
$publisher_id = $_POST['publisher_id'];
$isbn = $_POST['isbn'];
$title = $_POST['book_title'];
$price = $_POST['book_price'];
// Validate the inputs
if (empty($isbn) || empty($title) || empty($price)) {
$error = "Invalid book data. Check all fields and try again.";
include '../errors/error.php';
} else {
$publisher = PublisherRepository::getPublisher($publisher_id);
$book = new Book($isbn, $title, $price, $publisher);
BookRepository::addBook($book);
// Display the Book List page for the current publisher
header("Location: .?controller=admin&publisher_id={$publisher_id}");
}
} else {
$publishers = PublisherRepository::getPublishers();
return 'views/add_book_view.php';
}
<?php
/*
* Student Info: Name=Chapadia Shruti, ID=15574CS
* Subject: CS526(B)_HWNo3_Summer_2016
* Author: shruti
* Filename: list_books.php
* Date and Time: Jul 27, 2016 10:32:52 AM
* Project Name: BookstoreMVC_Authentication_update
*/
$publisher_id = 1;
if (isset($_GET['publisher_id'])) {
$publisher_id = $_GET['publisher_id'];
}
$publishers = PublisherRepository::getPublishers();
$publisher = PublisherRepository::getPublisher($publisher_id);
$books = BookRepository::getBooksByPublisher($publisher_id);
return 'views/manage_book_list_view.php';
