prepare("SELECT title, description FROM surveys WHERE id = ?");
$stmt->execute([$survey_id]);
$survey = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$survey) {
http_response_code(404);
echo "Error: Survey not found.";
exit;
}
// Fetch questions
$stmt = $pdo->prepare("SELECT id, question_text, question_type, options FROM questions WHERE survey_id = ? ORDER BY id ASC");
$stmt->execute([$survey_id]);
$questions = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
http_response_code(500);
echo "Database error: " . htmlspecialchars($e->getMessage());
exit;
}
?>
<?php echo htmlspecialchars($survey['title']); ?> - Survey