<?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;
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.'); } }