function updateWine($arr, $dbh)
{
$wine = new Wine($dbh);
if (!is_null($arr['upc']) && !is_null($arr['name']) && !is_null($arr['vintage']) && !is_null($arr['sell_price']) && !is_null($arr['wine_id']) && !is_null($arr['type'])) {
$wine->setID($arr['wine_id']);
$wine->setUPC($arr['upc']);
$wine->setType($arr['type']);
$wine->setName($arr['name']);
$wine->setVintage($arr['vintage']);
$wine->setCost($arr['cost']);
$wine->setSellPrice($arr['sell_price']);
$id = $wine->writeWineToTable();
if ($id != 0) {
die('Wine Updated.');
} else {
die('Database Error.');
}
} else {
die('You must set all parameters to update a wine.');
}
}
<?php
require_once 'inc/init.php';
require_once 'inc/class.wine.php';
echo 'Hello Wine Enthusiasts.<br>';
$dbh->query("DELETE FROM wine");
$dbh->query("DELETE FROM inventory");
$newWine = new Wine($dbh);
$newWine->setUPC('1541948561658');
$newWine->setName('Pinot Grigio');
$newWine->setVintage('1954');
$newWine->setSellPrice('150.00');
$id = $newWine->writeWineToTable();
echo $id . '<br>';
$newWine->setID($id);
$id = $newWine->addInventory(10, 15.5, 'Bought From Bob');
echo $id . '<br>';
$id = $newWine->removeInventory(5, 45.5, 'Sold To James');
echo $id;
