<?php
require_once 'config/database.php';

echo "Checking pending transactions...\n";

// Get a pending transaction
$stmt = $pdo->query("SELECT * FROM bank_transactions WHERE status = 'pending' LIMIT 1");
$result = $stmt->fetch();

if ($result) {
    echo "Found pending transaction:\n";
    print_r($result);
    
    echo "\nStudent ID: " . $result['student_id'] . "\n";
    echo "Amount: " . $result['amount'] . "\n";
    echo "Transaction ID: " . $result['transaction_id'] . "\n";
} else {
    echo "No pending transactions found.\n";
}
?>