query("INSERT INTO fee_categories (category_name, description, status) VALUES ('$category_name', '$description', '$status')"); echo ''; exit(); } // Edit Fee Category if(isset($_POST['action']) && $_POST['action'] == 'edit_category') { $id = mysqli_real_escape_string($con, $_POST['id']); $category_name = mysqli_real_escape_string($con, $_POST['category_name']); $description = mysqli_real_escape_string($con, $_POST['description']); $status = mysqli_real_escape_string($con, $_POST['status']); $con->query("UPDATE fee_categories SET category_name='$category_name', description='$description', status='$status' WHERE id='$id'"); echo ''; exit(); } // Delete Fee Category if(isset($_GET['action']) && $_GET['action'] == 'delete') { $id = mysqli_real_escape_string($con, $_GET['id']); $con->query("DELETE FROM fee_categories WHERE id='$id'"); echo ''; exit(); } // Fetch all categories $categories = $con->query("SELECT * FROM fee_categories ORDER BY id DESC"); ?>

Fee Categories

num_rows > 0): ?> fetch_assoc()): ?>
#ID Category Name Description Status Actions
#
Delete
No fee categories found