note 124645 deleted from class.mysqli by cmb
| From: | cmb@php.net | Date: | Thu, 07 May 2020 07:02:36 +0000 |
| Subject: | note 124645 deleted from class.mysqli by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-214588@lists.php.net to get a copy of this message | ||
Note Submitter: user at note dot com
----
<?php
include_once("data/Book.php");
include_once("DatabaseFactory.php");
// CRUD methods for book objects
class BookDB{
private static function getConnection(){
return DatabaseFactory::getDatabase();
}
public static function getAll(){
$query = "SELECT * FROM Book";
// Execute query
$conn = self::getConnection();
$results = $conn->executeQuery($query);
$resultsArray = array();
for($i = 0; $i < $results->num_rows; $i++){
$row = $results->fetch_array(); // Retrieves the current selected row
// Make a book
$book = self::convertRowToObject($row);
// Add book to resultsArray
$resultsArray[$i] = $book;
}
return $resultsArray;
}
public static function convertRowToObject($row){
return new Book(
$row["BookId"],
$row["Title"],
$row["Releasedate"],
$row["Price"],
$row["EmailPublisher"]
);
}
public static function insert($book){
return self::getConnection()->executeQuery("INSERT INTO Book(Title, Releasedate,
Price, EmailPublisher) VALUES ('?', '?', '?', '?')",
array($book->title, $book->releasedate, $book->priceExclVAT, $book->emailPublisher));
}
}
?>