<?php include("config.php"); date_default_timezone_set('Asia/Muscat'); $de = date('d-m-Y H:i:s'); $hotel = strtoupper($_POST['hotel']); $brief = $_POST['brief']; $descr = $_POST['editor']; $hotelstatus = 'Yes'; $resultx = $js->query('SELECT * FROM `websitehotels` ORDER BY `id` '); $resultx->execute(); while($row = $resultx->fetch(PDO::FETCH_ASSOC)) { $br = $row['id']; } $v = $br +1; $brid = "HOTELS".$v; $sql = $js->prepare('INSERT INTO `websitehotels` (`hotel`, `brief`, `hoteldescr`, `hotelstatus`) VALUES (:hotel, :brief, :descr, :hotelstatus)'); $status = $sql->execute(array(':hotel' => $hotel, ':brief' => $brief, ':descr' => $descr, ':hotelstatus' =>$hotelstatus)); $flag = '1'; ?> <script type="text/javascript"> alert("Have Successfully Added the Hotel to the Website"); window.location='websitehotels.php' </script>