<?php include('innerpageheader.php'); include('config.php'); $cid = $_GET['cid']; $hid = $_GET['id']; $i = 1; $result1 = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :cid AND id = :hid'); $result1->execute(array(':cid' => $cid, ':hid' => $hid)); while($row1 = $result1->fetch(PDO::FETCH_ASSOC)) { $resid = $row1['id']; $country = $row1['country']; $result22 = $js->prepare('SELECT * FROM `countries` WHERE id = :country '); $result22->execute(array(':country' => $country)); while($row22 = $result22->fetch(PDO::FETCH_ASSOC)) { $cname = $row22['cname']; } $govern = $row1['governate']; $result212 = $js->prepare('SELECT * FROM `governates` WHERE id = :govern '); $result212->execute(array(':govern' => $govern)); while($row212 = $result212->fetch(PDO::FETCH_ASSOC)) { $gname = $row212['gname']; } $hotel = $row1['hotel']; $result2 = $js->prepare('SELECT * FROM `hotelvendor` WHERE id = :hotel '); $result2->execute(array(':hotel' => $hotel)); while($row2 = $result2->fetch(PDO::FETCH_ASSOC)) { $hotelname = $row2['hotelname']; $location = $row2['location']; $category = $row2['category']; } $roomtype = $row1['roomtype']; $roomrate = $row1['roomrate']; $meals = $row1['meals']; $indate = $row1['cindate']; $outdate = $row1['coutdate']; $rooms = $row1['norooms']; $ebs = $row1['noebs']; $cindate = date('d-m-Y', strtotime($row1['cindate'])); $coutdate = date('d-m-Y', strtotime($row1['coutdate'])); $remarks = $row1['remarks']; $addservices = $row1['addservices']; $rstatus = $row1['res_status']; } ?> <script type="text/javascript"> function showsubheads(str) { if (str=="") { document.getElementById("governate").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("governate").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","show_subgovernates.php?q="+str,true); xmlhttp.send(); } function showgovsubheads(str1) { if (str1=="") { document.getElementById("location").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("location").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","show_sublocations.php?q="+str1,true); xmlhttp.send(); } function showgovsubheads1(str2, str3) { if (str2=="") { document.getElementById("hotels").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("hotels").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","show_subhotels.php?q="+str2+"&x="+str3,true); xmlhttp.send(); } </script> <section> <div class="content add-details"> <div class="in-content-wrapper"> <div class="box"> <div class="row"> <div class="col"> <div class="details-text"> <h4>Edit Hotel Details</h4> </div><!-- end details-text --> </div><!-- End column --> </div><!-- end row --> <div class="hotel-listing-form"> <form class="text-center" method="post" action="save_edithotelsforcustomers.php"> <input type="hidden" value="<?php echo $cid?>" id="cid" name="cid" /> <input type="hidden" value="<?php echo $hid?>" id="resid" name="resid" /> <div class="row"> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect00">Country :</label> </div> <select class="form-select" id="country" name="country" onchange="showsubheads(this.value)"> <option value="<?php echo $country?>"><?php echo $cname?></option> <option>SELECT COUNTRY</option> <?php $result = $js->prepare('SELECT * FROM `countries` ORDER BY `cname`'); $result->execute(); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $id = $row['id']; $cname = $row['cname']; echo "<option value=$id>$cname</option>"; } ?> </select> </div> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect00">Governates</label> </div> <select class="form-select" id="governate" name="governate"> <option value="<?php echo $govern?>"><?php echo $gname?></option> <option>SELECT GOVERNATE</option> </select> </div> </div><!-- end form-group --> </div><!-- end column --> </div><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect00">Hotel Category</label> </div> <select class="form-select" id="category" name="category" onchange="showgovsubheads1(this.value, document.getElementById('governate').value)"> <option value="<?php echo $category?>"><?php echo $category?> *</option> <option>SELECT CATEGORY</option> <option value="3">3 *</option> <option value="4">4 *</option> <option value="5">5 *</option> </select> </div> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect07" class="">Hotel Name:</label> </div> <select class="form-select" id="hotels" name="hotels"> <option value="<?php echo $hotel?>"><?php echo $hotelname?></option> <option>SELECT HOTEL</option> </select> </div> </div><!-- end form-group --> </div><!-- end column --> </div><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Check-in Date:</label> <input type="date" class="form-control text-center" required id="cindate" name="cindate" value="<?php echo $indate?>"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Check-out Date:</label> <input type="date" class="form-control text-center" required id="coutdate" name="coutdate" value="<?php echo $outdate?>"> </div><!-- end form-group --> </div> </div><!-- end form-row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Room Type:</label> <input type="text" class="form-control text-center" required id="roomtype" name="roomtype" value="<?php echo $roomtype?>"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Meals:</label> <input type="text" class="form-control text-center" required id="meals" name="meals" value="<?php echo $meals?>"> </div><!-- end form-group --> </div> </div> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">No of rooms:</label> <input type="text" class="form-control text-center" required id="rooms" name="rooms" value="<?php echo $rooms?>"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">No of Extra-beds:</label> <input type="text" class="form-control text-center" id="ebs" name="ebs" value="<?php echo $ebs?>"> </div><!-- end form-group --> </div> </div><!-- end form-row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Room Rate:</label> <input type="text" class="form-control text-center" required id="rrate" name="rrate" value="<?php echo $roomrate?>"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Extra-bed Rate:</label> <input type="text" class="form-control text-center" id="rebrate" name="rebrate"> </div><!-- end form-group --> </div> </div><!-- end form-row --> <div class="row"> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect00">Reservation Status</label> </div> <select class="form-select" id="rstatus" name="rstatus"> <option value="<?php echo $rstatus?>"><?php echo $rstatus?></option> <option>SELECT STATUS</option> <option value="Pending">Pending</option> <option value="Confirmed">Confirmed</option> <option value="Waiting List">Waiting List</option> </select> </div> </div><!-- end form-group --> </div><!-- end column --> </div> <div class="row"> <div class="form-group"> <textarea class="form-control textarea text-left p-3" id="remarks" name="remarks" rows="5" placeholder="Enter Remarks"><?php echo $remarks?></textarea> </div><!-- end form-group --> </div> <div class="row"> <div class="form-group"> <textarea class="form-control textarea text-left p-3" id="addservices" name="addservices" rows="5" placeholder="Additional Services"><?php echo $addservices?></textarea> </div><!-- end form-group --> </div> <ul class="list-inline"> <li class="list-inline-item"> <button type="submit" class="btn">Submit</button> </li> <li class="list-inline-item"> <a href="view_customers.php?id=<?php echo $cid?>" style="background-color:#FF3333; border-radius:5px; color:#fff;" class="btn"><strong>Back</strong></a> </li> </ul> </form> </div><!-- end hotel-listing-form --> </div><!-- end box --> </div> </div><!-- end in-content-wrapper --> </div><!-- end add-details --> </section> <!-- ===========End Innerpage-wrapper============= --> </div><!-- end wrapper --> <?php include('footer.php'); ?>