invisio v2.0

<?php
	
	session_start();

$empids = $_SESSION['empids'];
	
	
	include('config.php');
	
	$cid = $_POST['cid'];
	$vehicle = $_POST['vehicle'];
	$descr = $_POST['descr'];
	$vehcharges = $_POST['vehcharges'];
		
	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');
	
	$result = $js->query('SELECT * FROM `travelassistance` ORDER BY `id`');
	$result->execute();
	$cc = $result->rowCount();
	
	if($cc == '0')
	{
		$entryid = 'FET|'.$month.$year.'|222001';
	}
	else
	{
	  while($row = $result->fetch(PDO::FETCH_ASSOC)) 
	  {
		  $nw = $row['travelid'];
	  }
	}
	if($cc == '0')
	{
		$entryid = 'FET|'.$month.$year.'|222001';
	}
	else
	{
		$sub = substr($nw,11);
		$sno = $sub + 1;
		$entryid = 'FET|'.$month.$year."|".$sno; 
	}
		
	
		$sql = $js->prepare('INSERT INTO `travelassistance` (`custid`, `travelid`, `vehicle`, `descr`, `vehiclecharge`, `addedat`, `enteredby` ) VALUES (:cid, :entryid, :vehicle, :descr, :vehcharges, :de, :empids)');

$statuss = $sql->execute(array(':cid' => $cid,
											':entryid' => $entryid,
											':vehicle' => $vehicle,
											':descr' => $descr,
											':vehcharges' => $vehcharges, 
											':empids' => $empids, 
											':de' => $de)); 
	
?>
 
<script type="text/javascript">
	alert("Have Successfully Added the Travel Details");
	window.location = "add_travelassistance.php?cid=<?php echo $cid?>";
</script>