prepare($query)) {
$stmt->bind_param("i", $program_id); // Bind program_id as an integer
$stmt->execute();
$stmt->bind_result($activity_ids);
$stmt->fetch();
$stmt->close();
// Check if activity_ids is not empty
if (!empty($activity_ids)) {
// Prepare the next query to fetch activity details based on the IDs
$query_activities = "SELECT program_id, program_name FROM program_master WHERE program_id IN ($activity_ids)";
error_log("Check_activity_query : ".$query_activities);
if ($result = $conn->query($query_activities)) {
// Create the options for the activity dropdown
$activity_options = "";
while ($row = $result->fetch_assoc()) {
$activity_options .= "";
}
echo $activity_options; // Return the dropdown options
} else {
error_log("Error fetching activities: " . $conn->error);
}
} else {
echo "";
}
} else {
error_log("Prepare statement failed: " . $conn->error);
}
} else {
echo "";
}
?>