note 124645 added to class.mysqli
| From: | user at note dot com | Date: | Fri, 24 Jan 2020 05:14:04 +0000 |
| Subject: | note 124645 added to class.mysqli | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-213952@lists.php.net to get a copy of this message | ||
<?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));
}
}
?>
----
Server IP: 45.112.84.4
Probable Submitter: 185.85.3.195 (proxied: 193.190.238.3)
----
Manual Page -- http://php.net/manual/en/class.mysqli.php
Edit -- https://master.php.net/note/edit/124645
Del: integrated -- https://master.php.net/note/delete/124645/integrated
Del: useless -- https://master.php.net/note/delete/124645/useless
Del: bad code -- https://master.php.net/note/delete/124645/bad+code
Del: spam -- https://master.php.net/note/delete/124645/spam
Del: non-english -- https://master.php.net/note/delete/124645/non-english
Del: in docs -- https://master.php.net/note/delete/124645/in+docs
Del: other reasons-- https://master.php.net/note/delete/124645
Reject -- https://master.php.net/note/reject/124645
Search -- https://master.php.net/manage/user-notes.php