<?php
header("Content-Type: application/json");
header("Access-Control-Allow-Origin: *"); // Allow CORS if needed

// Database configuration
$host = 'localhost';
$dbname = 'wisrod5_website';
$username = 'wisrod5_website';
$password = 'abcABC123@#@#*()(_)*&ghjnbhuy(*)';

try {
    // Create PDO connection
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8mb4", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // SQL query to fetch all loan applications
    $sql = "SELECT * FROM loan_applications";
    $stmt = $pdo->prepare($sql);
    $stmt->execute();

    // Fetch all rows as associative array
    $loanApplications = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // Return JSON response
    echo json_encode([
        'success' => true,
        'data' => $loanApplications,
        'message' => 'Loan applications fetched successfully.'
    ]);

} catch (PDOException $e) {
    // Handle errors
    echo json_encode([
        'success' => false,
        'message' => 'Database error: ' . $e->getMessage()
    ]);
}
?>