Misschien is het handiger als ik de rest van mijn code er ook even bij zet.
De twee bestand uit mijn model :
<?php
class tabel
{
protected $db;
public function __construct($db)
{
$this->db = $db;
}
protected function makeStatement($sql,$data = null){
$statement = $this->db->prepare($sql);
try{
$statement->execute($data);
} catch (Exception $e) {
$msg = "<p>You tried to run this query: $sql</p>
<p>Exeption: $e</p>";
trigger_error($msg);
}
return $statement;
}
?>
<?php
include_once "models/Table.class.php";
class Book_Table extends Tabel
{
public function getAllBooks()
{
$sql = "SELECT * FROM boeken";
$statement = $this->makeStatement($sql);
return $statement;
}
public function getDetails($id)
{
$sql = 'SELECT boeken.*, categorieen.categorie, categorieen.categorie_id FROM boeken
JOIN categorieen WHERE boek_id=?';
$statement = $this->db->prepare($sql);
$data = array($id);
$statement = $this->makeStatement($sql, $data);
$model = $statement->fetchObject();
return $model;
}
}
?>
Mijn controllers :
<?php
include_once 'models/Book_Table.class.php';
$bookTable = new Book_Table($db);
$books = $bookTable->getAllBooks();
$booksAsHTML = include_once "views/admin/books_html.php";
return $booksAsHTML;
?>
<?php
include_once 'models/Book_Table.class.php';
$bookTable = new Book_Table($db);
$isBookClicked = isset($_GET['id']);
if($isBookClicked){
$bookId = $_GET['id'];
$bookData = $bookTable->getDetails($bookId);
$bookOutput = include_once "views/admin/details_html.php";
} else {
$books = $bookTable->getAllBooks();
$bookOutput = include_once "views/admin/books_html.php";
}
return $bookOutput;
?>
en mijn views :
<?php
$booksFound = isset ($books);
if ($booksFound === false){
trigger_error ( 'views/admin/books_html.php needs $books' );
}
$booksAsHTML = "
<div class='container'>
<form method='post' action='index.php?page=search' id='search-form'>
<input type='search' name='search-term' class='form-control'>
<button type='submit' value='Search' class='form-control' id='button-zoek'>Zoek</button>
</form>
<div id='booklistAdmin' class='table-responsive'>
<h2>Boekenlijst</h2>
<table id='adminTableBooks' class='table table-striped borderless '>
<thead>
<tr>
<td>Titel</td>
<td>Details</td>
<td>Aanpassen</td>
<td>Verwijderen</td>
</tr>
</thead>
<tbody>
";
while($book = $books->fetchObject()){
$href = "admin.php?page=details&id=$book->boek_id";
$booksAsHTML .= "
<tr>
<td>$book->titel</td>
<td><a class='fa fa-info-circle' href=\"$href\" ></a></td>
<td><a class='fa fa-wrench'></a></td>
<td><a class='fa fa-trash-o'></a></td>
</tr>
";
}
$booksAsHTML .= "
</tbody>
</table>
</div>
</div>
";
return $booksAsHTML;
?>
<?php
$bookFound = isset($bookData);
if($bookFound === false) {
trigger_error('views/entry-html.php needs an $bookData object');
}
return "
<div class='container'>
<h2>Boekfiche van : $bookData->isbn</h2>
<div class='info-onderdeel'>
<table id='boekdetails'>
<tr>
<td>IISBN :</td>
<td>$bookData->isbn</td>
</tr>
<tr>
<td>Prijs :</td>
<td>€ $bookData->prijs</td>
</tr>
<tr>
<td>Categorie :</td>
<td><$bookData->categorie_id></td>
</tr>
</table>
</div>
<div class='info-onderdeel'>
</div>
<div class='info-onderdeel'>
<img src='' alt='$bookData->titel'>
</div>
</div>
";
?>
Als resultaat krijg ik al mijn gegevens, alleen bij de categorie krijg ik het id 1 waar eigenlijk kookboek zou moeten komen.
