<?php
// Include database connection
require_once 'db_connection.php';

// Check if ID is provided
if (!isset($_GET['id'])) {
    header("Location: payments.php");
    exit();
}

$paymentId = intval($_GET['id']);

// Delete the payment
$query = "DELETE FROM payments WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $paymentId);
$stmt->execute();

header("Location: payments.php");
exit();