<?php session_start(); $empids = $_SESSION['empids']; include('config.php'); $typename = $_POST['typename']; $remarks = $_POST['remarks']; date_default_timezone_set('Asia/Muscat'); $de = date('Y-m-d H:i:s'); $js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = $js->prepare('INSERT INTO `vendortypes` (`vendortype`, `remarks`, `addedat`, `addedby`) VALUES (:typename, :remarks, :de, :empids)'); $status = $sql->execute(array(':typename' => $typename, ':remarks' => $remarks, ':de' => $de, ':empids' => $empids)); if ($status) { ?> <script type="text/javascript"> alert("Have Successfully Added <?php echo $typename?> as Vendor Type"); window.location='vendortype.php' </script> <?php } ?>