query("INSERT INTO `notification` (title, link_url, description) VALUE ('$title', '$linkUrl', '$description')"); echo ''; } else { echo ''; } } // FIX 3: isset() lagaya aur ID ko secure kiya if (isset($_GET['action']) && $_GET['action'] == 'delete' && isset($_GET['id'])) { $id = mysqli_real_escape_string($con, $_GET['id']); $con->query("DELETE FROM `notification` WHERE id = '$id'"); echo ''; } $studentApproved = $con->query("SELECT * FROM `students` WHERE status = 1"); $studentPending = $con->query("SELECT * FROM `students` WHERE status = 0"); $certificates = $con->query("SELECT * FROM `certificates` WHERE status = 1"); $results = $con->query("SELECT * FROM results WHERE status = 1"); $admitCards = $con->query("SELECT * FROM admit_card"); $courses = $con->query("SELECT * FROM `courses`"); $centersApproved = $con->query("SELECT * FROM `centers` WHERE status = 1"); $centersPending = $con->query("SELECT * FROM `centers` WHERE status = 0"); ?>
Administration Dashboard • Government of Gujarat
| # | Title | Document Link | Description | Action |
|---|---|---|---|---|
| ' . $i++ . ' | ' . htmlspecialchars($row['title']) . ' | ' . htmlspecialchars($row['link_url']) . ' | ' . htmlspecialchars($row['description']) . ' | Delete |
|
No notifications published yet |
||||