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 `employees` ORDER BY `id`');
			$result->execute();
			while($row = $result->fetch(PDO::FETCH_ASSOC)) {
				$nw = $row['id']+1;
			}
			
			$branch = $_POST['branch'];
			if($branch == 'MUSCAT')
			{
			
				if($nw < '10')
				{
					$sno = 'FETOM000'.$nw;
				}
				else
				{
					$sno = 'FETOM00'.$nw;	
				}
			}
			elseif($branch == 'INDIA')
			{
				if($nw < '10')
				{
					$sno = 'FETIN000'.$nw;
				}
				else
				{
					$sno = 'FETIN00'.$nw;	
				}	
			}
			$pass = "falcon";

$name = $_POST['empname'];
			$loc = $_POST['location'];
			
			$brmob = $_POST['mob'];
			$bremail = $_POST['emailid'];			
			$dept = $_POST['dept'];
			$desig = $_POST['desig'];
			$branch = $_POST['branch'];
			
			$js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$sql = $js->prepare('INSERT INTO `employees` (`empid`, `empname`, `mobile`, `email`, `location`, `desig`, `dept`, `branch`) VALUES (:sno, :name, :brmob, :bremail, :loc, :desig, :dept, :branch)');
			$status = $sql->execute(array(':sno' => $sno,
										':name' => $name,
										':loc' => $loc,
										':brmob' => $brmob,
										':bremail' => $bremail,
										':desig' => $desig,
										':dept' => $dept,
										':branch' => $branch));
			$js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$sql1 = $js->prepare('INSERT INTO `login` (`userid`, `userpassword`) VALUES (:sno, :pass)');
			$status1 = $sql1->execute(array(':sno' => $sno,
										':pass' => $pass));
		
?>
	 <script type="text/javascript">
	alert("Have Successfully Added the Employee with userid - <?php echo $sno?> and Password - <?php echo $pass?>");
window.location='employees.php'
</script>