invisio v2.0

<?php

include("config.php");
			date_default_timezone_set('Asia/Muscat');
 			$de = date('d-m-Y  H:i:s');
			$sno =1;
			$result = $js->query('SELECT * FROM `branches` ORDER BY `id`');
			$result->execute();
			while($row = $result->fetch(PDO::FETCH_ASSOC)) {
				$nw = $row['id'] + 1;
			}
			
				$sno = "BR".$nw;

$brname = filter_input(INPUT_POST, 'brname', FILTER_SANITIZE_STRING);
			$braddr = filter_input(INPUT_POST, 'braddr', FILTER_SANITIZE_STRING);
			$brloc = filter_input(INPUT_POST, 'brloc', FILTER_SANITIZE_STRING);
			$brperson = filter_input(INPUT_POST, 'brperson', FILTER_SANITIZE_STRING);
			$brmob = filter_input(INPUT_POST, 'brmob', FILTER_SANITIZE_STRING);
			$bremail = filter_input(INPUT_POST, 'bremail', FILTER_SANITIZE_STRING);
			$brname = strtoupper($brname);
			$js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$sql = $js->prepare('INSERT INTO `branches` (`brid`, `brname`, `braddr`, `brloc`, `brcontact`, `brmob`, `bremail`, `braddtime`) VALUES (:sno, :brname, :braddr, :brloc, :brperson, :brmob, :bremail, :de)');
			$status = $sql->execute(array(':sno' => $sno,
										':brname' => $brname,
										':braddr' => $braddr,
										':brloc' => $brloc,
										':brperson' => $brperson,
										':brmob' => $brmob,
										':bremail' => $bremail,
										':de' => $de));

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