����
������������������������������������
<?php
// Set response as JSON
header("Content-Type: application/json");

// Setup DB connection
$host = 'localhost';
$db   = 'solutionscp_shawn_mingus';   // Your database name
$user = 'solutionscp_shawn_mingus';            // Your DB username
$pass = 'solutionscp_shawn_mingus';                // Your DB password
$charset = 'utf8mb4';

// Create PDO connection
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
];

try {
    $pdo = new PDO($dsn, $user, $pass, $options);

    // Get email from query string
    if (!isset($_GET['email']) || empty($_GET['email'])) {
        echo json_encode(["error" => "Missing or invalid email parameter"]);
        exit;
    }

    $email = filter_var($_GET['email'], FILTER_SANITIZE_EMAIL);

    // Fetch data
    $stmt = $pdo->prepare("SELECT yearlyIncome, loanSize, bps, appToClose, leadToApp FROM user_inputs WHERE email = :email");
    $stmt->execute([':email' => $email]);
    $result = $stmt->fetch();

    if ($result) {
        echo json_encode($result);
    } else {
        echo json_encode(["error" => "No data found for this email"]);
    }

} catch (PDOException $e) {
    echo json_encode(["error" => $e->getMessage()]);
}