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

<?php
include_once '../../include/DBConnect.php';

if ($_POST) {
    //echo '<script>alert("$_POST" )</script>';
    $score = $_POST['Data'];
    $deleteStaffID = $_POST['Data'];
    $deleted = 1;
    $sth = $dbh->prepare("UPDATE `staff` SET `deleted`= '$deleted' WHERE `staff_id` = '$deleteStaffID'");
    $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" => $deleteStaffID
    );
    $Arrays[] = $Array;
}
//echo $score;
echo json_encode($Array);

?>