include_once "header.php";
?>
<?php
// get ID of the bouteille to be edited
$id = isset($_GET['id']) ? $_GET['id'] : die("Erreur ! Il manque l'identifiant de la bouteille");
// include database and object files
include_once 'config/database.php';
include_once 'objects/Bouteille.php';
// get database connection
$database = new Database();
$db = $database->getConnection();
// prepare bouteille object
$bouteille = new Bouteille($db);
// set ID property of bouteille to be edited
$bouteille->id = $id;
// read the details of bouteille to be edited
$bouteille->readOne();
// Annee courante
$temp = date("Y");
// Si formulaire soumis et que utilisateur connecté
if ($_POST && $_SESSION && isset($_SESSION['id_utilisateur'])) {
// set bouteille property values
if (isset($_POST['nom'])) {
$bouteille->nom = $_POST['nom'];
}
if (isset($_POST['quantite'])) {
$bouteille->quantite = $_POST['quantite'];
}
// Entête
$page_title = "Ajout d'une bouteille";
include_once "header.php";
// Connexion DB
include_once 'config/database.php';
include_once 'objects/Bouteille.php';
include_once 'objects/Referentiel.php';
include_once 'objects/AOC.php';
$database = new Database();
$db = $database->getConnection();
// Si formulaire soumis et que utilisateur connecté
if ($_POST && $_SESSION && isset($_SESSION['id_utilisateur'])) {
try {
// Nouvel objet Bouteille
$bouteille = new Bouteille($db);
// Valeurs des propriétés de la bouteille
if (isset($_POST['nom'])) {
$bouteille->nom = $_POST['nom'];
}
if (isset($_POST['quantite'])) {
$bouteille->quantite = $_POST['quantite'];
}
if (isset($_POST['achat'])) {
$bouteille->achat = $_POST['achat'];
}
if (isset($_POST['prixachat'])) {
$bouteille->prixachat = $_POST['prixachat'];
}
if (isset($_POST['prixestime'])) {
$bouteille->prixestime = $_POST['prixestime'];
<?php
// get database connection
include_once 'config/database.php';
include_once 'objects/Bouteille.php';
$database = new Database();
$db = $database->getConnection();
// Des données ont-elles été envoyées par POST ?
if ($_POST) {
// Nouvel objet Bouteille
$bouteille = new Bouteille($db);
$id = $_POST['id'];
$qte = $_POST['qte'];
$stmt = $bouteille->drink($id, $qte);
if ($stmt == true) {
echo "Ok";
} else {
echo "Pb";
}
}
include_once "header.php";
if ($_SESSION && isset($_SESSION['id_utilisateur'])) {
echo "<div class='right-button-margin'>";
echo "<a href='ajout_bouteille.php' class='btn btn-primary pull-right'>Ajouter une bouteille </a>";
echo "</div>";
}
// 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 -->
<?php
// check if value was posted
if ($_POST) {
// include database and object file
include_once 'config/database.php';
include_once 'objects/Bouteille.php';
// get database connection
$database = new Database();
$db = $database->getConnection();
// prepare bouteille object
$bouteille = new Bouteille($db);
// set bouteille id to be deleted
$bouteille->id = $_POST['id'];
// delete the bouteille
if ($bouteille->delete()) {
echo "Ok";
} else {
echo "Pb";
}
}
