extract($row_type); echo "<option value='{$id}'>{$libelle}</option>"; } echo "</select>"; ?> </div> </div> <div class="form-group"> <label for="id_contenance" class="col-sm-2 control-label">Contenance</label> <div class="col-sm-10"> <?php // Recherche les diverses contenances en BD include_once 'objects/Contenance.php'; $nom = new Contenance($db); $stmt = $nom->read(); // Remplissage de la liste echo "<select class='form-control' name='id_contenance' id='id_contenance'>"; echo "<option>Choisir le type ...</option>"; while ($row_type = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row_type); // Par défaut, la taille 0,75cl est sélectionnée if ($id == 2) { echo "<option value='{$id}' selected>{$nom} ({$volume} soit {$equivalence})</option>"; } else { echo "<option value='{$id}'>{$nom} ({$volume} soit {$equivalence})</option>"; } } echo "</select>"; ?>
} echo "{$libelle}</option>"; } echo "</select>"; ?> </div> </div> <div class="form-group"> <label for="id_contenance" class="col-sm-2 control-label">Contenance</label> <div class="col-sm-10"> <?php // read the bouteille categories from the database include_once 'objects/Contenance.php'; $contenance = new Contenance($db); $stmt = $contenance->read(); // put them in a select drop-down echo "<select class='form-control' name='id_contenance'>"; echo "<option>Choisir la contenance ...</option>"; while ($row_contenance = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row_contenance); // current cepage of the product must be selected if ($bouteille->id_contenance == $id) { echo "<option value='{$id}' selected>"; } else { echo "<option value='{$id}'>"; } echo "{$nom} ({$volume} soit {$equivalence})</option>"; } echo "</select>";
<?php // page given in URL parameter, default page is one $page = isset($_GET['page']) ? $_GET['page'] : 1; // set number of records per page $records_per_page = 15; // calculate for the query LIMIT clause $from_record_num = $records_per_page * $page - $records_per_page; // include database and object files include_once 'config/database.php'; include_once 'objects/Contenance.php'; // instantiate database and product object $database = new Database(); $db = $database->getConnection(); $contenance = new Contenance($db); // query products $stmt = $contenance->readAll($page, $from_record_num, $records_per_page); $num = $stmt->rowCount(); // display the products if there are any if ($num > 0) { echo "<table class='table table-striped table-hover table-responsive'>"; echo "<tr>"; echo "<th>Nom</th>"; echo "<th>Volume</th>"; echo "<th>Equivalence</th>"; echo "</tr>"; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); echo "<tr>"; echo "<td>{$nom}</td>";