/** * edit item form * @param $id * @param $dbObj * @return string */ function editItem($id, $dbObj) { $query = "SELECT t1.itemId, t1.name, t1.image, t2.price, t1.description,\n t2.quantity, t3.onsale, t3.salePrice FROM item t1\n JOIN inventory t2 ON t1.itemId = t2.itemId\n JOIN itemsale t3 ON t2.itemId = t3.itemId WHERE t1.itemId = :itemid"; $rs = $dbObj->select($query, array(":itemid" => $id)); $html = "<div class='container'><h2>Edit Item</h2><div class='jumbotron'><form method='POST' action='admin.php'>"; //save into fields foreach ($rs as $result) { $obj = new InventoryItem($result); $html .= "<label name='id' value='" . $obj->getId() . "'>ID:" . $obj->getId() . "</label><label for='name'>Name: </label>\n <br><br><input type='text' name='name' id='name' value='" . $obj->getName() . "'>\n <br><br><label for='image'>Image: </label><input type='text' name='image' id='image' value='" . $obj->getImage() . "'>\n <br><br><label for='price'>Price: </label><input type='text' name='price' id='price' value='" . $obj->getPrice() . "'>\n <br><br><label for='quantity'>Quantity: </label><input type='text' name='quantity' id='quantity' value='" . $obj->getQuantity() . "'>\n <br><br><label for='description'>Description: </label><input type='text' name='description' id='description' value='" . $obj->getDescription() . "'>\n <br><br><label for='onsale'>On Sale: </label><input type='text' name='onsale' id='onsale' value='" . $obj->getOnSale() . "'>\n <br><br><label for='saleprice'>Sale Price: </label><input type='text' name='saleprice' id='saleprice' value='" . $obj->getSalePercent() . "'>"; } $html .= "<br><br><button class='btn btn-primary' name='submit' value='update'>Submit</button></form></div></div>"; return $html; }