// include database and object files include_once 'config/database.php'; include_once 'objects/Bouteille.php'; include_once 'objects/AOC.php'; include_once 'objects/Type.php'; include_once 'objects/Emplacement.php'; // instantiate database and product object $database = new Database(); $db = $database->getConnection(); $bouteille = new Bouteille($db); // show page header $total_rows = $bouteille->countAll(''); $sum = $bouteille->sumAll(''); echo "<h3><span id='totalVins'>{$total_rows}</span> vins, <span id='totalBouteilles'>{$sum}</span> bouteilles</h3>"; // query products $stmt = $bouteille->readAll(); $num = $stmt->rowCount(); ?> <div class="pager"> <img src="lib/tablesorter/addons/pager/icons/first.png" class="first" alt="First" /> <img src="lib/tablesorter/addons/pager/icons/prev.png" class="prev" alt="Prev" /> <span class="pagedisplay"></span> <!-- this can be any element, including an input --> <img src="lib/tablesorter/addons/pager/icons/next.png" class="next" alt="Next" /> <img src="lib/tablesorter/addons/pager/icons/last.png" class="last" alt="Last" /> <select class="pagesize" title="Nombre de vins / page"> <option value="10">10</option> <option value="20">20</option> <option value="50">50</option>