prepare("SELECT d.title, d.description, d.image_path, d.created_at, c.name as category_name FROM drills d LEFT JOIN categories c ON d.category_id = c.id WHERE d.id = ?");
$stmt->execute([$drill_id]);
$drill = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$drill) {
die('Drill not found');
}
// HTML content for the PDF
$html = '
Drill Report
Category:
Description:
Created at:
';
$options = new Options();
$options->set('isHtml5ParserEnabled', true);
$dompdf = new Dompdf($options);
$dompdf->loadHtml($html);
$dompdf->setPaper('A4', 'portrait');
$dompdf->render();
$dompdf->stream("drill_" . $drill['id'] . ".pdf", ["Attachment" => false]);