query("SELECT * FROM surveys WHERE id = $survey_id");
$survey = $result->fetch_assoc();
if (!$survey) {
$_SESSION['message'] = "Survey not found.";
$_SESSION['message_type'] = "error";
header("Location: index.php");
exit;
}
$pages = $db->query("SELECT * FROM pages WHERE survey_id = $survey_id ORDER BY page_number");
// Construct the take survey URL
$take_survey_url = "http://{$_SERVER['HTTP_HOST']}/take_survey.php?id={$survey_id}&unique_id={$survey['unique_id']}=";
?>
<?= htmlspecialchars($survey['title']) ?>
Survey URL:
Welcome Content
fetch_assoc()): ?>
Page
query("SELECT * FROM choices WHERE page_id = {$page['id']}");
while ($choice = $choices->fetch_assoc()):
?>
Redirect:
query("SELECT * FROM choices WHERE page_id = {$page['id']} LIMIT 1")->fetch_assoc();
?>