<?php
header('Content-Type: text/plain');
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once __DIR__ . '/config.php';
require_once __DIR__ . '/includes/db.php';

try {
    $pdo = getDB();
    
    // Print connection info
    echo "Host: " . DB_HOST . "\n";
    echo "DB Name: " . DB_NAME . "\n";
    echo "DB Username: " . DB_USERNAME . "\n";
    echo "Environment: " . (ENVIRONMENT === 'production' ? 'PRODUCTION' : 'DEVELOPMENT') . "\n";
    echo "----------------------------------------\n";
    
    $q = $pdo->query("DESCRIBE `affiliation_applications`");
    $rows = $q->fetchAll(PDO::FETCH_ASSOC);
    
    echo "Columns in affiliation_applications table:\n";
    echo "----------------------------------------\n";
    foreach ($rows as $r) {
        echo "Field: " . $r['Field'] . " | Type: " . $r['Type'] . "\n";
    }
} catch (Exception $e) {
    echo "Error executing query: " . $e->getMessage() . "\n";
}