</ul> </div> </div> </div><!--end of dashboard--> </div><!--end of header---> <div style="clear: both;"></div> <div id="content" class="content"> <h1> Add Room</h1> <div class="main-content"> <div class="data-form"> <form action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post"> <label>Room Number</label><input type="text" name="room_number" value="<?php echo getRoomId(); ?> " disabled> <label>Name </label><input type="text" name="name" required> <label>Room Type </label> <select name="room_type" class="select" ><?php $type = getRoomType(); foreach ($type as $value) { ?> <option value="<?php echo $value['cat_id']; ?> "><?php echo $value['category']; ?> </option> <?php
$_SESSION["last_acted_on"] = time(); if (isset($_POST['update'])) { $no = $_POST['room_number']; $name = $_POST['name']; $tp = $_POST['room_type']; $des = $_POST['description']; $query = "update room set name='" . $name . "' , cat_id='" . $tp . "' , room_id='" . $des . "' where room_no='" . $no . "'"; updateRoom($query); header('Location: room.php'); } if (isset($_GET['number'])) { $number = $_GET['number']; $rooms = getRoom($number); } if (isset($_POST['add'])) { $no = getRoomId(); $name = $_POST['name']; $tp = $_POST['room_type']; $des = $_POST['description']; $query = "insert into room values ('" . $no . "','" . $name . "' , '" . $tp . "' , '" . $des . "' )"; UpdateRoom($query); } ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>Accommodation</title> <link href="css/style.css" type="text/css" rel="stylesheet"> </head>