query("INSERT INTO fee_structure (category_id, class_name, fee_amount, frequency, description, status) VALUES ('$category_id', '$class_name', '$fee_amount', '$frequency', '$description', '$status')"); echo ''; exit(); } // Edit Fee Structure if(isset($_POST['action']) && $_POST['action'] == 'edit_fee') { $id = mysqli_real_escape_string($con, $_POST['id']); $category_id = mysqli_real_escape_string($con, $_POST['category_id']); $class_name = mysqli_real_escape_string($con, $_POST['class_name']); $fee_amount = mysqli_real_escape_string($con, $_POST['fee_amount']); $frequency = mysqli_real_escape_string($con, $_POST['frequency']); $description = mysqli_real_escape_string($con, $_POST['description']); $status = mysqli_real_escape_string($con, $_POST['status']); $con->query("UPDATE fee_structure SET category_id='$category_id', class_name='$class_name', fee_amount='$fee_amount', frequency='$frequency', description='$description', status='$status' WHERE id='$id'"); echo ''; exit(); } // Delete Fee Structure if(isset($_GET['action']) && $_GET['action'] == 'delete') { $id = mysqli_real_escape_string($con, $_GET['id']); $con->query("DELETE FROM fee_structure WHERE id='$id'"); echo ''; exit(); } // Fetch all fee structures $fee_structures = $con->query("SELECT fs.*, fc.category_name FROM fee_structure fs LEFT JOIN fee_categories fc ON fs.category_id = fc.id ORDER BY fs.id DESC"); // Fetch categories for dropdown $categories = $con->query("SELECT * FROM fee_categories WHERE status = 1 ORDER BY category_name ASC"); ?>

Fee Structure Management

num_rows > 0): ?> fetch_assoc()): ?>
#ID Category Class Fee Amount (₹) Frequency Description Status Actions
# ₹
Delete
No fee structure found