submit_cheque.php

<?php
require "database.php";

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Retrieve and sanitize form data
    
    $accountNumber = $conn->real_escape_string($_POST['accountNumber']);
    $checkNumber = $conn->real_escape_string($_POST['checkNumber']);
    $payee = $conn->real_escape_string($_POST['payee']);
    $amount = $conn->real_escape_string($_POST['amount']);
    $amountWords = $conn->real_escape_string($_POST['amountWords']);
    $chequeDate = $conn->real_escape_string($_POST['chequeDate']);
    $dvNumber = $conn->real_escape_string($_POST['dvNumber']);

    

    // Insert data into database
    $sql = "INSERT INTO tbcheckrecords (check_number, amount, date, payee, dv_number, account_number) 
            VALUES ('$checkNumber', '$amount', '$chequeDate', '$payee', '$dvNumber', '$accountNumber')";
    if ($conn->query($sql) === TRUE) {
        echo '<script>alert("New record created successfully");</script>';
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }

    // Close connection
    $conn->close();
}
?>