prepare("DELETE FROM survey_answers WHERE submission_id = ?"); $delete_answers_stmt->execute([$submission_id]); // Then, delete the submission itself $delete_submission_stmt = db()->prepare("DELETE FROM feedback_submissions WHERE id = ?"); $delete_submission_stmt->execute([$submission_id]); // Redirect to the same page to see the changes header('Location: admin.php?page=' . (isset($_GET['page']) ? $_GET['page'] : 1)); exit; } // Pagination $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; $records_per_page = 10; $offset = ($page - 1) * $records_per_page; // Get total number of submissions $total_stmt = db()->query("SELECT COUNT(*) FROM feedback_submissions"); $total_records = $total_stmt->fetchColumn(); $total_pages = ceil($total_records / $records_per_page); // Fetch submissions for the current page $submissions_stmt = db()->prepare("SELECT s.id, s.name, s.email, s.created_at, sv.title as survey_title, sv.id as survey_id FROM feedback_submissions s JOIN surveys sv ON s.survey_id = sv.id ORDER BY s.created_at DESC LIMIT :limit OFFSET :offset"); $submissions_stmt->bindValue(':limit', $records_per_page, PDO::PARAM_INT); $submissions_stmt->bindValue(':offset', $offset, PDO::PARAM_INT); $submissions_stmt->execute(); $submissions = $submissions_stmt->fetchAll(PDO::FETCH_ASSOC); $pageTitle = "Admin - Feedback Submissions"; require_once 'templates/header.php'; ?>

Feedback Submissions

Survey Submitter Email Submitted At Actions
No feedback submissions yet.
View