| {$count} |
{$batch} |
{$beneficiary_name} |
{$placement_name} |
{$reg_date} |
{$row2['status']} |
{$row2['salary']} |
{$primary_phone} | ";
// Fetch follow-up data
for ($i = 1; $i <= 3; $i++) {
$follow_up = "{$i} Follow Up";
$stmt = $conn->prepare("SELECT * FROM placement_feedback WHERE beneficiary = ? AND follow_up_routine = ?");
$stmt->bind_param('is', $row2['beneficiary'], $follow_up);
$stmt->execute();
$result = $stmt->get_result();
if ($follow_up_data = $result->fetch_assoc()) {
$placement_date = date_format(date_create($follow_up_data['last_modified_by']), "d-m-Y");
echo "" . htmlspecialchars($follow_up_data['placement_id']) . " |
{$placement_date} |
" . htmlspecialchars($follow_up_data['salary']) . " |
" . htmlspecialchars($follow_up_data['remark']) . " | ";
} else {
echo " | ";
}
$stmt->close();
}
echo "
";
$count++;
}
$stmt->close();
?>