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>";
