?>
<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>
