prepare("SELECT * FROM training_sessions WHERE id = ?");
$stmt->execute([$session_id]);
$session = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$session) {
die('Training session not found');
}
// Fetch associated drills
$stmt = db()->prepare("SELECT d.title, d.description, d.image_path, c.name as category_name FROM drills d JOIN training_session_drills tsd ON d.id = tsd.drill_id LEFT JOIN categories c ON d.category_id = c.id WHERE tsd.training_session_id = ?");
$stmt->execute([$session_id]);
$drills = $stmt->fetchAll(PDO::FETCH_ASSOC);
// HTML content for the PDF
$html = '
Training Session Report
';
$options = new Options();
$options->set('isHtml5ParserEnabled', true);
$dompdf = new Dompdf($options);
$dompdf->loadHtml($html);
$dompdf->setPaper('A4', 'portrait');
$dompdf->render();
$dompdf->stream("training_session_" . $session['id'] . ".pdf", ["Attachment" => false]);