Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ads.php	13.96 KB	-rw-r--r--	2025-10-17 23:08
auth.php	343 B	-rw-r--r--	2025-10-17 23:20
dashboard.php	8.71 KB	-rw-r--r--	2025-10-18 00:40
deposit_methods.php	12.36 KB	-rw-r--r--	2025-10-17 23:06
deposits.php	13.24 KB	-rw-r--r--	2025-10-18 00:56
dpin.php	6.16 KB	-rw-r--r--	2025-10-17 23:06
footer.php	565 B	-rw-r--r--	2025-10-17 23:05
header.php	13.06 KB	-rw-r--r--	2025-10-18 02:06
login.php	3.37 KB	-rw-r--r--	2025-10-17 23:09
login_as_user.php	1020 B	-rw-r--r--	2025-10-17 23:05
logout.php	88 B	-rw-r--r--	2025-10-17 23:08
plans.php	13.65 KB	-rw-r--r--	2025-10-17 23:06
referral_commissions.php	11.93 KB	-rw-r--r--	2025-10-18 00:13
team_commissions.php	6.66 KB	-rw-r--r--	2025-10-17 23:45
test_modals.php	4.44 KB	-rw-r--r--	2025-10-18 00:49
test_referral_commissions.php	2.87 KB	-rw-r--r--	2025-10-18 00:13
test_user_edit.php	4.96 KB	-rw-r--r--	2025-10-18 00:44
transactions.php	6.36 KB	-rw-r--r--	2025-10-17 23:08
users.php	13.55 KB	-rw-r--r--	2025-10-18 00:49
withdraw_methods.php	12.49 KB	-rw-r--r--	2025-10-17 23:08
withdraws.php	9.16 KB	-rw-r--r--	2025-10-17 23:39

Rename

<?php
require_once 'header.php';

try {
    // Test database connection and table existence
    $stmt = $pdo->prepare("SHOW TABLES LIKE 'referral_commissions'");
    $stmt->execute();
    $tableExists = $stmt->fetch();
    
    if ($tableExists) {
        // Test fetching data
        $stmt = $pdo->prepare("SELECT * FROM referral_commissions ORDER BY level ASC");
        $stmt->execute();
        $levels = $stmt->fetchAll();
        
        $status = "success";
        $message = "Referral commissions table exists and is accessible";
        $data = $levels;
    } else {
        $status = "error";
        $message = "Referral commissions table does not exist";
        $data = [];
    }
    
} catch (PDOException $e) {
    $status = "error";
    $message = "Database error: " . $e->getMessage();
    $data = [];
}
?>

<div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
    <h1 class="h2">Referral Commissions Test</h1>
</div>

<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">Test Results</h5>
                <p><strong>Status:</strong> <?php echo $status; ?></p>
                <p><strong>Message:</strong> <?php echo $message; ?></p>
                
                <?php if ($status === "success" && count($data) > 0): ?>
                    <h6>Commission Levels:</h6>
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>Level</th>
                                    <th>Commission Percentage</th>
                                    <th>Created At</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($data as $level): ?>
                                    <tr>
                                        <td><?php echo $level['level']; ?></td>
                                        <td><?php echo number_format($level['commission_percentage'], 2); ?>%</td>
                                        <td><?php echo $level['created_at']; ?></td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php elseif ($status === "success"): ?>
                    <p>No commission levels found in the table.</p>
                <?php endif; ?>
                
                <a href="referral_commissions.php" class="btn btn-primary">Go to Referral Commissions Page</a>
            </div>
        </div>
    </div>
</div>

<?php include 'footer.php'; ?>