pokeloken

Back Back Up Advanced Editor

<?php
require_once('/home/leadltht/fastlinkinternet.com/administrator/data-provider/config.php');

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (session_status() == PHP_SESSION_NONE) {
        session_start();
    }

$data = $_POST;
    $data['created_at'] = date('Y-m-d H:i:s');
    $data['Status'] = 'Pending';  // Setting default status to 'Pending'

// Log form data for debugging
    error_log("Form data: " . print_r($data, true));

// Check database connection
    if ($conn->connect_error) {
        error_log("Database connection failed: " . $conn->connect_error);
        echo json_encode(['status' => 'failed', 'msg' => 'Database connection failed: ' . $conn->connect_error]);
        exit;
    }

// Prepare the statement
    $stmt = $conn->prepare("INSERT INTO pop (PaymentDate, ReceiptNumber, PaymentMethod, ClientName, AmountPaid, created_at, Status, note) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");

if ($stmt === false) {
        error_log("Error preparing statement: " . $conn->error);
        echo json_encode(['status' => 'failed', 'msg' => 'Error preparing statement: ' . $conn->error]);
        exit;
    }

$stmt->bind_param(
        'ssssssss',
        $data['date_collected'],
        $data['receipt'],
        $data['collection_method'],
        $data['client_name_display'],
        $data['total_amount'],
        $data['created_at'],
        $data['Status'],
        $data['note']
    );

if ($stmt->execute()) {
        echo json_encode(['status' => 'success']);
    } else {
        error_log("Error saving data: " . $stmt->error);
        echo json_encode(['status' => 'failed', 'msg' => 'Error saving data: ' . $stmt->error]);
    }

$stmt->close();
    $conn->close();
} else {
    echo json_encode(['status' => 'failed', 'msg' => 'Invalid request method.']);
}
?>