source: Admin Actions/IssueFine.php

<?php

require_once '../connect.php';  

header('Content-Type: application/json');


// Issue fine
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Get data from the form
    $loanid = $_POST['loan-id'];
    $fineamount = $_POST['fine-amount'];
    $finedate = date('Y-m-d'); 
    $status = 'Unpaid'; 

    try {
        $query = "
            INSERT INTO fine (fineamount, finedate, status, loanid)
            VALUES (:fineamount, :finedate, :status, :loanid)
        ";
        
        $stmt = $conn->prepare($query);
        $stmt->bindParam(':fineamount', $fineamount);
        $stmt->bindParam(':finedate', $finedate);
        $stmt->bindParam(':status', $status);
        $stmt->bindParam(':loanid', $loanid);
        
        // Execute the query
        $stmt->execute();

        echo json_encode(['success' => true, 'message' => 'Fine issued successfully!']);
    } catch (PDOException $e) {
        echo json_encode(['success' => false, 'message' => 'Error: ' . $e->getMessage()]);
    }
}
?>