?> <html> <head> <title>Add Wine</title> </head> <body> <h><b>ADD WINE</b></h> <br> <form method="post" action="addwine.php"> <div>Wine Name: <input type="text" name="wn" required></div><br> <div>Wine Type: <select name="type_id"> <option value="0">--Select Wine Type--</option> <?php include_once "wines.php"; $obj1 = new wines(); $obj1->get_wine_type(); while ($row = $obj1->fetch()) { echo "<option value='{$row['wine_type_id']}''>{$row['wine_type']}</option>"; } ?> </select> </div><br> <div>Year: <input type="text" name="yr" size="30" required></div><br> <div>Winery: <select name="winery_id"> <option value="0">--Select Winery--</option> <?php include_once "wines.php"; $obj2 = new wines(); $obj2->get_winery(); while ($row = $obj2->fetch()) { echo "<option value='{$row['winery_id']}''>{$row['winery_name']}</option>";
?> <form method="GET" action="editwine.php"> <input type="hidden" name="wid" value="<?php echo $wid; ?> "> <div>Wine Name: <input type="text" value="<?php echo $row['wine_name']; ?> " name="wn" id="wn"></div><br> <div>Wine Type: <select name="type_id" id="type_id"> <option value="0">--Select Wine Type--</option> <?php include_once "wines.php"; $obj = new wines(); $obj->get_wine_type(); while ($obj1 = $obj->fetch()) { if ($obj1['wine_type_id'] == $row['wine_type']) { echo "<option value='{$obj1['wine_type_id']}' selected>{$obj1['wine_type']}</option>"; } else { echo "<option value='{$obj1['wine_type_id']}'>{$obj1['wine_type']}</option>"; } } ?> </select></div><br> <div>Year: <input type="text" value="<?php echo $row['year']; ?> " name="yr" id="yr"></div><br> <div>Winery: <select name="winery_id" id="winery_id"> <option value="0">--Select Winery--</option>