<?php include('innerpageheader.php'); include('config.php'); $id = $_GET['id']; $result = $js->prepare('SELECT * FROM `hotelvendor` WHERE id = :id'); $result->execute(array(':id' => $id)); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $vendor = $row['vendor']; /* $results = $js->prepare('SELECT * FROM `vendortypes` WHERE id = :vendor '); $results->execute(array(':vendor' => $vendor)); while($rows = $results->fetch(PDO::FETCH_ASSOC)) { $vtype = $rows['vendortype']; } */ $country = $row['country']; $resultcs = $js->prepare('SELECT * FROM `countries` WHERE id = :country '); $resultcs->execute(array(':country' => $country)); while($rowcs = $resultcs->fetch(PDO::FETCH_ASSOC)) { $cname = $rowcs['cname']; } $governate = $row['governate']; $resultsg = $js->prepare('SELECT * FROM `governates` WHERE id = :governate '); $resultsg->execute(array(':governate' => $governate)); while($rowsg = $resultsg->fetch(PDO::FETCH_ASSOC)) { $gname = $rowsg['gname']; } $category = $row['category']; $hotelname = $row['hotelname']; $address = $row['address']; $location = $row['location']; $hotelemail = $row['hotelemail']; $hotelphone = $row['hotelphone']; $managername = $row['managername']; $managerphone = $row['managerphone']; $salesemail = $row['salesemail']; $website = $row['website']; $accountno = $row['accountno']; $accname = $row['accname']; $bankname = $row['bankname']; $branch = $row['branch']; $swiftcode = $row['swiftcode']; } ?> <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(); } </script> <section> <div class="content add-details"> <div class="in-content-wrapper"> <div class="row no-gutters"> <div class="col"> <div class="heading-messages"> <h3>Edit <?php echo $hotelname." - ".$location?></h3> </div><!-- End heading-messages --> </div><!-- End column --> <div class="col-md-4"> <div class="breadcrumb"> <div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Admin</a> </div> <div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>Vendor Management </div> </div><!-- end breadcrumb--> </div><!-- end column --> </div><!-- end row --> <div class="box"> <div class="hotel-listing-form"> <form class="text-center" method="post" action="save_editvendors.php"> <input type="hidden" name="vendorid" id="vendorid" value="<?php echo $id?>" /> <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">Vendor</label> </div> <select class="form-select" id="vendor" name="vendor"> <option value="<?php $vendor?>"><?php echo $vendor?></option> <option value="">SELECT VENDOR</option> <option value="HOTEL">HOTEL</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">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><!-- 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">Governates</label> </div> <select class="form-select" id="governate" name="governate"> <option value="<?php echo $governate?>"><?php echo $gname?></option> <option>SELECT GOVERNATE</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">Hotel Category</label> </div> <select class="form-select" id="category" name="category"> <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><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Hotel Name:</label> <input type="text" class="form-control" required id="hotelname" name="hotelname" value="<?php echo $hotelname?>"> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Location:</label> <input type="text" class="form-control" required id="location" name="location" value="<?php echo $location?>"> </div><!-- end form-group --> </div><!-- end column --> </div><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Hotel Address:</label> <input type="text" class="form-control" required id="hoteladdr" name="hoteladdr" value="<?php echo $address?>"> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Reservation Email:</label> <input type="text" class="form-control" required id="hotelemail" name="hotelemail" value="<?php echo $hotelemail?>"> </div><!-- end form-group --> </div><!-- end column --> </div><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Hotel Phone:</label> <input type="text" class="form-control" required id="hotelphone" name="hotelphone" value="<?php echo $hotelphone?>"> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Hotel Email (Sales):</label> <input type="text" class="form-control" required id="hotelemails" name="hotelemails" value="<?php echo $salesemail?>"> </div><!-- end form-group --> </div><!-- end column --> </div><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Hotel Manager Name (Sales):</label> <input type="text" class="form-control" required id="managername" name="managername" value="<?php echo $managername?>"> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Hotel Manager Contact (Sales):</label> <input type="text" class="form-control" required id="managerphone" name="managerphone" value="<?php echo $managerphone?>"> </div><!-- end form-group --> </div><!-- end column --> </div> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class=""> Website:</label> <input type="text" class="form-control" id="Website" name="Website" value="<?php echo $website?>"> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Bank A/C No:</label> <input type="text" class="form-control" id="accountno" name="accountno" value="<?php echo $accountno?>"> </div><!-- end form-group --> </div><!-- end column --> </div> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class=""> A/C Name:</label> <input type="text" class="form-control" id="acname" name="acname" value="<?php echo $accname?>"> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Bank Name:</label> <input type="text" class="form-control" id="bank" name="bank" value="<?php echo $bankname?>"> </div><!-- end form-group --> </div><!-- end column --> </div> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class=""> Branch:</label> <input type="text" class="form-control" id="branch" name="branch" value="<?php echo $branch?>"> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <label for="inputGroupSelect07" class="">Swift Code:</label> <input type="text" class="form-control" id="SwiftCode" name="SwiftCode" value="<?php echo $swiftcode?>"> </div><!-- end form-group --> </div><!-- end column --> </div> <ul class="list-inline"> <li class="list-inline-item"> <button type="submit" class="btn">Submit</button> </li> <li class="list-inline-item"> <button type="reset" class="btn">Cancel</button> </li> </ul> </form> </div><!-- end hotel-listing-form --> </div><!-- end box --> </div><!-- end in-content-wrapper --> </div><!-- end add-details --> </section> <!-- ===========End Innerpage-wrapper============= --> </div><!-- end wrapper --> <?php include('footer.php'); ?>