25 lines
757 B
PHP
25 lines
757 B
PHP
<?php
|
|
include('includes/config/config.php');
|
|
$data=array();
|
|
if (isset($_POST['plan_id'])) {
|
|
|
|
$sql = "SELECT * FROM program_achievement WHERE plan_id = '".$_POST['plan_id']."'";
|
|
error_log("SQL Query: ss " . $sql);
|
|
$result = mysqli_query($conn, $sql);
|
|
if ($result && mysqli_num_rows($result) > 0) {
|
|
while($row=mysqli_fetch_assoc($result)){
|
|
array_push($data,$row) ;
|
|
}
|
|
|
|
|
|
echo json_encode($data);
|
|
} else {
|
|
error_log("No data found for year: " . $_POST['year']);
|
|
echo json_encode(['status' => 200, 'message' => 'Data not found!']);
|
|
}
|
|
} else {
|
|
error_log("Invalid request: subject_id not set");
|
|
echo json_encode(['status' => 400, 'message' => 'Invalid request!']);
|
|
}
|
|
?>
|