1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

<?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_training`( `staff_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `start_date`, `end_date`, `remarks`) VALUES ('$currentStaff','$createby','$today','$createby','$today','$actived','$deleted','$SDate','$EDate','$Desc')";
    $sth = $dbh->prepare("INSERT INTO `staff_training`( `staff_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `start_date`, `end_date`, `remarks`) 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);

?>