| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/onesupportsys.onesolution.hk/others/ |
Upload File : |
<?php
require_once('../inc/configure.php');
session_start();
if(!empty($_SESSION['webadmin'])){
$nowdate = date("Y-m-d H:i:s");
if(isset($_GET["addholiday"]) && $_GET["addholiday"] ==1){
$remarks= $_POST["remarks"];
//$sql = "insert into sup_public_holiday (year, holiday_date, createby, createdate, lastupby, lastupdate) values ('".date("Y")."','".date("Y-m-d")."', '".$_SESSION['webadmin']['id']."', '$nowdate', '".$_SESSION['webadmin']['id']."', '$nowdate') ";
$sql = "insert into sup_public_holiday (year, holiday_date, createby, createdate, lastupby, lastupdate) values (?, ?, ?, ?, ?, ?) ";
$parameters = array(date("Y"),date("Y-m-d"),$_SESSION['webadmin']['id'],$nowdate,$_SESSION['webadmin']['id'],$nowdate);
if (!($sth = $dbh->prepare($sql))) {
throw new Exception("sql prepare statement failure: $sql");
}
$sth->setFetchMode(PDO::FETCH_ASSOC);
if (!$sth->execute($parameters)) {
throw new Exception("sql execute statement failure: $sql");
}
$lastinsertid = $dbh->lastInsertId();
}
header("Location: holiday_index.php?message=New empty holiday created." );
}
?>