| 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/old20140414/LeaveApplication/unused/ |
Upload File : |
<?php
include_once '../../include/DBConnect.php';
if ($_POST) {
//echo '<script>alert("$_POST" )</script>';
$score = $_POST['Data'];
$UpdateLeaveRecordID = $_POST['Data'];
if (isset($_POST['Action'])) {
$CurrentAction = $_POST['Action'];
$query = "UPDATE `lesson_attendance` SET `is_cancel` = 1 WHERE `lesson_id` = '$UpdateLeaveRecordID' and deleted =0 and actived = 1";
$sth = $dbh -> prepare($query);
$sth->execute();
// if ($CurrentAction == 1) {
// $sth = $dbh->prepare("UPDATE `leave_lesson` SET `actived` = '0' WHERE `lesson_id` = '$UpdateLeaveRecordID' AND `actived` = '1'");
// $sth->execute();
// }
// if ($CurrentAction == 2) {
// $sth = $dbh->prepare("UPDATE `leave_lesson` SET `actived` = '1' WHERE `lesson_id` = '$UpdateLeaveRecordID' AND `actived` = '0'");
// $sth->execute();
// }
}
if ($sth)
$message = "1 record UPDATED";
else
$message = "Error";
$Array = array(
"1" => $message,
"2" => $score * 2,
"3" => $score * 3,
"4" => $score * 4,
"5" => $UpdateLeaveRecordID
);
$Arrays[] = $Array;
}
//echo $score;
echo json_encode($Arrays);
?>