}
if (isset($_GET['ORDERBY']) && $_GET['ORDERBY'] != '') {
$query->order($_GET['ORDERBY']);
}
$sql = $query->getSql();
$entries = App::db()->fetch($sql);
//Total des entrées
$nbrResultat = count($entries);
//Si tous les résulats ne passent pas sur une page, on fais une pagination
//Pour cela on refait une requête en ne prennant que les résultats voulus
$start = 0;
if ($nbrResultat > $_SESSION['nbrResultatPage'] && isset($_GET['pageResultat']) && $_GET['pageResultat'] != '') {
//Calcul des limites des etnrées à afficher
$start = $pageResultat * $_SESSION['nbrResultatPage'] - $_SESSION['nbrResultatPage'];
//Recuperation des entrées
$query = new Core\Db\QueryBuilder();
$query->select()->from($tableName);
if (isset($_GET['queryFields'])) {
foreach ($_GET['queryFields'] as $key => $val) {
$query->where($key . " LIKE '%" . $val . "%'");
}
}
if (isset($_GET['ORDERBY']) && $_GET['ORDERBY'] != '') {
$query->order($_GET['ORDERBY']);
}
$sql = $query->limit($start, $_SESSION['nbrResultatPage']);
$sql = $query->getSql();
$entries = App::db()->fetch($sql);
}
?>
<div id="home">
}
$sql = $sql->getSql();
$categories = App::db()->fetch($sql);
foreach ($categories as $category) {
?>
<tr><td colspan="4"><h2><?php
echo $category["category"];
?>
</h2></td></tr>
<tr>
<th>Image</th>
<th>Titre</th>
<th>Prix</th>
<th>Panier</th>
</tr><?php
$query = new Core\Db\QueryBuilder();
$sql = $query->select()->from('articles')->where('category_id=' . $category["id"])->getSql();
$articles = App::db()->fetch($sql);
foreach ($articles as $article) {
?>
<tr>
<td><img src="assets/images/articles/<?php
echo $article["picture"];
?>
" alt="<?php
echo $article["title"];
?>
" /></td>
<td><a href="view?id=<?php
echo $article["id"];
?>
