merci c'est bien le order by qui pose problème :
$statement = $db->query("SELECT documentation.id, documentation.code_publication_doc, documentation.description, documentation.image, documentation.categorie_publication, documentation.qte_stock, documentation.qte_demande, documentation.date_maj, categories_publications.categorie AS categorie_publication FROM documentation LEFT JOIN categories_publications ON documentation.categorie_publication = categories_publications.id ORDER BY `description`". $orderby);
par contre, si je veux essayer de trier selon deux champs différents de la table, exemple description et date_maj, je suis de nouveau bloquée, j'ai cette erreur : Fatal error: Call to a member function fetch() on a non-object
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
|
<form action="index.php" method="GET">
<input type="submit" name="orderby" value="description" />
<table class="table table-striped table-bordered">
<thead>
<tr>
<th>Code</th>
<th>Description</th>
<th>Quantité</th>
<th>Catégorie</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
require 'database.php';
$db = Database::connect();
if(isset($_GET['orderby']) && $_GET['orderby'] == "description")
{
$orderby = 'description';
}
else
{
$orderby = 'date_maj';
}
$statement = $db->query("SELECT documentation.id, documentation.code_publication_doc, documentation.description, documentation.image, documentation.categorie_publication, documentation.qte_stock, documentation.qte_demande, documentation.date_maj, categories_publications.categorie AS categorie_publication FROM documentation LEFT JOIN categories_publications ON documentation.categorie_publication = categories_publications.id ORDER BY" . $orderby);
while($item = $statement->fetch())
{
echo '<tr>';
echo '<td>'. $item['code_publication_doc'] . '</td>';
echo '<td>'. $item['description'] . '</td>';
echo '<td align="center">'. $item['qte_stock'] . '</td>';
echo '<td>'. $item['categorie_publication'] . '</td>';
$date_d = $item['date_maj'];
echo '<td>'. strftime('%d-%m-%Y',strtotime($date_d)) . '</td>';
echo '<td width=300>';
echo '<a class="btn btn-default" href="view.php?id='.$item['id'].'"><span class="glyphicon glyphicon-eye-open"></span> Voir</a>';
echo ' ';
echo '<a class="btn btn-primary" href="update.php?id='.$item['id'].'"><span class="glyphicon glyphicon-pencil"></span> Modifier</a>';
echo ' ';
echo '<a class="btn btn-danger" href="delete.php?id='.$item['id'].'"><span class="glyphicon glyphicon-remove"></span> Supprimer</a>';
echo '</td>';
echo '</tr>';
}
Database::disconnect();
?>
</tbody>
</table>
</form> |
Partager