G:
/
PleskVhosts
/
seeonsoft.com
/
hp.thefalconunited.com
/
up file
home
<?php session_start(); $empids = $_SESSION['empids']; include("config.php"); date_default_timezone_set('Asia/Muscat'); $de = date('d-m-Y H:i:s'); $sno =1; $result = $js->query('SELECT * FROM `organization` ORDER BY `id`'); $result->execute(); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $nw = $row['id'] + 1; } $sno = "ORG".$nw; $cname = filter_input(INPUT_POST, 'cname', FILTER_SANITIZE_STRING); $ho = filter_input(INPUT_POST, 'ho', FILTER_SANITIZE_STRING); $crno = filter_input(INPUT_POST, 'crno', FILTER_SANITIZE_STRING); $pobox = filter_input(INPUT_POST, 'pobox', FILTER_SANITIZE_STRING); $pc = filter_input(INPUT_POST, 'pc', FILTER_SANITIZE_STRING); $brloc = filter_input(INPUT_POST, 'brloc', FILTER_SANITIZE_STRING); $brmob = filter_input(INPUT_POST, 'brmob', FILTER_SANITIZE_STRING); $bremail = filter_input(INPUT_POST, 'bremail', FILTER_SANITIZE_STRING); $owner = filter_input(INPUT_POST, 'owner', FILTER_SANITIZE_STRING); $web = filter_input(INPUT_POST, 'web', FILTER_SANITIZE_STRING); $js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = $js->prepare('INSERT INTO `organization` (`orgid`, `orgname`, `orgho`, `crno`, `pobox`, `pcode`, `orgloc`, `orgmob`, `orgemail`, `orgowner`, `orgwebsite`, `enteredby`, `addedtime`) VALUES (:sno, :cname, :ho, :crno, :pobox, :pc, :brloc, :brmob, :bremail, :owner, :web, :empids, :de)'); $status = $sql->execute(array(':sno' => $sno, ':cname' => $cname, ':ho' => $ho, ':crno' => $crno, ':pobox' => $pobox, ':pc' => $pc, ':brloc' => $brloc, ':brmob' => $brmob, ':bremail' => $bremail, ':owner' => $owner, ':web' => $web, ':empids' => $empids, ':de' => $de)); if ($status) { ?> <script type="text/javascript"> alert("Have Successfully Added the Company"); window.location='company.php' </script> <?php } ?>