invisio v2.0

<?php
			session_start();
			$empids = $_SESSION['empids'];
			include("config.php");
			date_default_timezone_set('Asia/Muscat');
 			$de = date('d-m-Y  H:i:s');
			$sno =1;
			$result = $js->query('SELECT * FROM `bankaccounts` ORDER BY `id`');
			$result->execute();
			while($row = $result->fetch(PDO::FETCH_ASSOC)) {
				$nw = $row['id'] + 1;
			}
				$sno = "BANKACCT".$nw;
			$stat = 'Active';
			$bname = filter_input(INPUT_POST, 'bname', FILTER_SANITIZE_STRING);
			$branch = filter_input(INPUT_POST, 'branch', FILTER_SANITIZE_STRING);
			$aname = filter_input(INPUT_POST, 'aname', FILTER_SANITIZE_STRING);
			$acctno = filter_input(INPUT_POST, 'acctno', FILTER_SANITIZE_STRING);
			$swift = filter_input(INPUT_POST, 'swift', FILTER_SANITIZE_STRING);
			
			$js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$sql = $js->prepare('INSERT INTO `bankaccounts` (`bankid`, `bankname`, `bankbranch`, `accountno`, `accountname`, `swift`, `status`,	`enteredby`, `addedtime`) VALUES (:sno, :bname, :branch, :acctno,   :aname, :swift, :stat, :empids, :de)');
			$status = $sql->execute(array(':sno' => $sno,
										':bname' => $bname,
										':branch' => $branch,
										':aname' => $aname,
										':acctno' => $acctno,
										':swift' => $swift,
										':stat' => $stat,
										':empids' => $empids,
										':de' => $de));

if ($status)
	{
?>
	 <script type="text/javascript">
	alert("Have Successfully Added the Bank Account");
window.location='add_bankdetails.php'
</script>
<?php 
	}
	 ?>