invisio v2.0

<?php
	
	session_start();

$empids = $_SESSION['empids'];
	
	
	include('config.php');
	
	$cid = $_POST['cid'];
	$resid = $_POST['resid'];
	$hid = $_POST['hid'];
	$country = $_POST['country'];
	$governate = $_POST['governate'];
	$category = $_POST['category'];
	$hotels = $_POST['hotels'];
	$cindate = $_POST['cindate'];
	$coutdate = $_POST['coutdate'];
		
	date_default_timezone_set('Asia/Muscat');
 	$de = date('Y-m-d  H:i:s');
	$entry = date('Y-m-d');
	
	$month = date('m');
	$year = date('Y');
	
	$roomtype = $_POST['roomtype'];
	$meals = $_POST['meals'];
	$rooms = $_POST['rooms'];
	$ebs = $_POST['ebs'];
	$rrate = $_POST['rrate'];
	$rebrate = $_POST['rebrate'];
	$remarks = $_POST['remarks'];
	$addservices = $_POST['addservices'];
	$rstatus = $_POST['rstatus'];
	
	$sql1 = $js->prepare('UPDATE hotelreservations SET country = :country, governate = :governate, category = :category, hotel = :hotels, cindate = :cindate, coutdate = :coutdate, roomtype = :roomtype, meals = :meals, norooms = :rooms, noebs = :ebs, roomrate = :rrate, ebrate = :rebrate, remarks = :remarks, addservices = :addservices, res_status = :rstatus WHERE custid = :cid AND id = :resid');
	
	
	$statuss = $sql1->execute(array(':cid' => $cid,
											':resid' => $resid,
											':country' => $country,
											':governate' => $governate, 
											':category' => $category,
											':hotels' => $hotels,
											':cindate' => $cindate,
											':coutdate' => $coutdate,
											':roomtype' => $roomtype,
											':meals' => $meals,
											':rooms' => $rooms,
											':ebs' => $ebs,
											':rrate' => $rrate,
											':rebrate' => $rebrate,
											':remarks' => $remarks,
											':addservices' => $addservices,
											':rstatus' => $rstatus)); 	
	
?>