/**
* your "controller"
* @author Antoine Chauvin <*****@*****.**>
*/
function main()
{
$boissons = BoissonMetier::getAll();
$currentPage = isset($_GET['page']) ? intval($_GET['page'], 10) : 1;
layout(function () use($boissons, $currentPage) {
boissons($boissons, $currentPage);
});
}
public static function init($pdo)
{
self::$pdo = $pdo;
self::$qselectall = $pdo->prepare('select boi_id, boi_nom, boi_degreAlcool from boisson');
self::$qinsert = $pdo->prepare('insert into boisson (boi_nom, boi_degreAlcool) values (:nom, :degreAlcool) returning boi_id');
self::$qupdate = $pdo->prepare('update boisson set boi_nom=:nom, boi_degreAlcool=:degreAlcool where boi_id=:id');
self::$qinsert = $pdo->prepare('delete from boisson where boi_id=:id');
}
public static function init($url)
{
$pdo = new PDO($url);
BoissonMetier::init($pdo);
}
