<?php session_start(); $empids = $_SESSION['empids']; include('config.php'); $cname = $_POST['country']; $gname = $_POST['governate']; $loc = $_POST['location']; 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 `location` (`country`, `governate`, `locname`) VALUES (:cname, :gname, :loc)'); $status = $sql->execute(array(':cname' => $cname, ':gname' => $gname, ':loc' => $loc)); if ($status) { ?> <script type="text/javascript"> alert("Have Successfully Added <?php echo $loc?> as Location"); window.location='Location.php' </script> <?php } ?>