function validate() { include "wines.php"; $username = $_REQUEST['username']; $password = $_REQUEST['password']; $obj = new wines(); $obj->connect(); $obj->validation($username, $password); if ($row = $obj->fetch()) { echo '{"status":1, "message":"User found"}'; } else { echo '{"status":0, "message":"User not found"}'; } }
<input type="radio" name="cat" value="White">White<br> <input type="radio" name="cat" value="Red">Red<br> <input type="submit" value="BROWSE"> </form> </body> <?php if (isset($_REQUEST['cat'])) { include_once "adb.php"; include "wines.php"; if ($_REQUEST['cat'] == "Sparkling") { $cat = $_REQUEST['cat']; } elseif ($_REQUEST['cat'] == "Fortified") { $cat = $_REQUEST['cat']; } elseif ($_REQUEST['cat'] == "Sweet") { $cat = $_REQUEST['cat']; } elseif ($_REQUEST['cat'] == "White") { $cat = $_REQUEST['cat']; } elseif ($_REQUEST['cat'] == "Red") { $cat = $_REQUEST['cat']; } $obj = new wines(); $obj->browseBy($cat); echo "<table border='1'>"; echo "<tr style='background-color:purple; color:white;text-align:center'>\n\t\t\t<td>Wine ID</td><td>Wine Name</td><td>Wine Type</td><td>Year</td>\n\t\t\t<td>Winery</td></tr>"; while ($row = $obj->fetch()) { echo "<tr><td>{$row['wine_id']}</td><td>{$row['wine_name']}</td><td>{$row['wine_type']}</td><td>{$row['year']}</td><td>{$row['winery_name']}</td></tr>"; } echo "</table>"; } ?> </html>
<?php include_once "wines.php"; $obj = new wines(); $wid = $_REQUEST['wid']; $obj->view_wine($wid); $row = $obj->fetch(); echo "Wine Name : " . $row['wine_name'] . "<br>"; echo "Winery : " . $row['winery_name'] . "<br>"; echo "Quantity on Hand : " . $row['on_hand'] . "<br>"; echo "Unit Price : " . $row['cost']; echo "<br/>"; echo "Region : " . $row['region_name'] . "<br>"; ?>
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> <?php include_once "wines.php"; $obj = new wines(); $obj->get_winery(); while ($obj1 = $obj->fetch()) { if ($obj1['winery_id'] == $row['winery_id']) { echo "<option value='{$obj1['winery_id']}' selected>{$obj1['winery_name']}</option>"; } else { echo "<option value='{$obj1['winery_id']}'>{$obj1['winery_name']}</option>"; } } ?> </select></div><br> <div>Description: <textarea name="wd" id="wd" cols="30" rows="5" value="<?php echo $row['description']; ?> "></textarea></div> <input type="submit" value="UPDATE"> </form> </body>