Gecko [ 36julay.space ]

Name	Size	Permission	Date
includes	[ DIR ]	drwxr-xr-x	2025-09-10 18:31
order	[ DIR ]	drwxr-xr-x	2025-09-10 09:14
pages	[ DIR ]	drwxr-xr-x	2025-09-11 03:30
.htaccess	237 B	-rw-r--r--	2025-09-01 07:26
amount_auto.php	2.39 KB	-rw-r--r--	2025-05-29 16:26
balance_add_remove.php	2.83 KB	-rw-r--r--	2024-10-26 14:38
bio_complete.php	5.35 KB	-rw-r--r--	2024-11-20 16:14
bonus_control.php	4.55 KB	-rw-r--r--	2024-10-25 15:29
file_success.php	6.1 KB	-rw-r--r--	2024-11-20 16:25
index.php	4.7 KB	-rw-r--r--	2024-12-04 08:13
logout-20250910220935.php	313 B	-rw-r--r--	2024-11-13 15:50
logout.php	313 B	-rw-r--r--	2024-11-13 15:50
nid_pending.php	14.65 KB	-rw-r--r--	2024-11-20 16:25
recharge_history.php	2.64 KB	-rw-r--r--	2024-10-26 14:25
update_marquee.php	4.88 KB	-rw-r--r--	2024-10-27 17:24
user_list.php	7.29 KB	-rw-r--r--	2024-10-31 14:05
wp-blog-header.php	2.73 KB	-rw-r--r--	2025-09-01 07:25

Rename

<?php include_once("header.php");

// Prepare the SQL query
$sql = "SELECT * FROM transactions";

// Execute the query
$result = $conn->query($sql);

// Initialize an array to store the users
$users = array();

// Check if any records were found
if ($result->num_rows > 0) {
    // Fetch all rows as an associative array and store them in the $users array
    while($row = $result->fetch_assoc()) {
        $users[] = $row;
    }
} else {
    $users = []; // No users found
}

<main id="main-container">
<div class="content card px-2" >
          
          <div class="block block-rounded">
            <div class="block-header block-header-default">
              <h3 class="text-center mt-4"> ইউজারদের সকল রিচার্জ হিস্টোরি</h3>
            </div>
            <div class="block-content block-content-full overflow-x-auto">
            <table id="myTable" class="display table text-center table-striped text-nowrap table-bordered">
    <thead>
        <tr style="background:black!important;" >
            <th class="text-center">#</th>
            <th class="text-center">পেমেন্ট আইডি</th>
            <th class="text-center">ট্রানজিশন আইডি</th>
            <th class="text-center">স্যাটাস</th>
            <th class="text-center">টাকার পরিমান</th>
            <th class="text-center">রির্চাজের সময়</th>
        </tr>
    </thead>
    <tbody >
    <?php if (!empty($users)): ?>
        <?php foreach ($users as $index => $user): ?>
            <tr>
                    <td><pre><?php echo $index + 1; ?></pre></td>

</tr>
        <?php endforeach; ?>
    <?php else: ?>
        <?php endif; ?>
    </tbody>
</table>
            </div>
            </div>
            </div>
<?php include_once("footer.php");?>
<link rel="stylesheet" href="https://cdn.datatables.net/2.1.7/css/dataTables.dataTables.css" />

// Initialize DataTable
        var table = $('#myTable').DataTable({
            "ordering": false
        });
});

</script>