| 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/(Del)pathways.org.hk/MIS20140127/old20140407/staff/ |
Upload File : |
<?php
include_once '../include/DBConnect.php';
$score = "1";
//$userAnswer = $_POST['name'];
//echo $_POST['name'] . "<\br>";
if ($_POST['Data']) {
$score = $_POST['Data'];
$currentStaff = $_POST['Data'];
//$score++;
$score2 = $_POST['Data2'];
$SDate = $_POST['Data2'];
$EDate = $_POST['Data3'];
$Desc = $_POST['Data4'];
//$score2++;
date_default_timezone_set("Hongkong");
$today = date("Y-m-d H:i:s");
$createby = 0;
$actived = 1;
$deleted = 0;
//"INSERT INTO `staff_education`( `staff_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `start_date`, `end_date`, `education`) VALUES ('$currentStaff','$createby','$today','$createby','$today','$actived','$deleted','$SDate','$EDate','$Desc')";
$sth = $dbh->prepare("INSERT INTO `staff_education`( `staff_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `start_date`, `end_date`, `education`) VALUES ('$currentStaff','$createby','$today','$createby','$today','$actived','$deleted','$SDate','$EDate','$Desc')");
$sth->execute();
if ($sth)
$message = "1 campus record inserted";
else
$message = $sth->errorInfo();
$Array = array(
"1" => $message,
"2" => $score*2,
"3" => $SDate,
"4" => $EDate,
"5" => $Desc
);
$Arrays[] = $Array;
}
//echo $score;
echo json_encode($Array);
?>