invisio v2.0

<?php
session_start();
$em_id = $_SESSION['empids'];

include("config.php");
			date_default_timezone_set('Asia/Muscat');
 			$de = date('d-m-Y  H:i:s');
			$entry = date('d-m-Y');
			
			$siresult1 = $js->prepare('SELECT * FROM `marketingclients` ORDER BY `id`');
			$siresult1->execute();
			while($row = $siresult1->fetch(PDO::FETCH_ASSOC)) {
				$id = $row['id'] + 1;
			}
			
			$dd = date('d');
			$mm = date('m');
			$yy = date('Y');
			$sno = "NSTMKT".$dd.$mm.$yy.$id;
			
			$entry = $_POST['entrydate'];
			$compname = strtoupper($_POST['compname']);
			$comploc = strtoupper($_POST['comploc']);
			$compmob = $_POST['compmob'];
			$compemail = $_POST['compemail'];
			$compcontact = strtoupper($_POST['compcontact']);
			$compremarks = $_POST['remarks'];			
			
			$js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$sql = $js->prepare('INSERT INTO `marketingclients` (`compid`, `entrydate`, `compname`, `comploc`, `compmob`, `compemail`, `contact_person`, `remarks`, `addedtime`, `enteredby`) VALUES (:sno, :entry, :compname, :comploc, :compmob, :compemail, :compcontact, :compremarks, :de, :em_id)');
			$status = $sql->execute(array(':sno' => $sno,
										':entry' => $entry,
										':compname' => $compname,
										':comploc' => $comploc,
										':compmob' => $compmob,
										':compemail' => $compemail,
										'compcontact' => $compcontact,
										':compremarks' => $compremarks,
										':em_id' => $em_id,
										':de' => $de));
			if ($status)
	{
?>
	 <script type="text/javascript">
	alert("Have Successfully Added the Entry");
//window.location='send_welcomemail.php?clientid=<?php echo $sno?>';
window.location='home.php';
</script>
<?php 
	}
	 ?>