Transaction Ledger - <?php echo htmlspecialchars($site

prepare("SELECT * FROM users WHERE id = :id"); $stmt->execute([':id' => $_SESSION['user_id']]); $user = $stmt->fetch(PDO::FETCH_ASSOC); // 2. Pagination Logic $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; $records_per_page = 25; $offset = ($page - 1) * $records_per_page; // Get total number of transactions for the user $total_stmt = $db->prepare("SELECT COUNT(*) FROM transactions WHERE user_id = :user_id"); $total_stmt->execute([':user_id' => $user['id']]); $total_records = $total_stmt->fetchColumn(); $total_pages = ceil($total_records / $records_per_page); // 3. Fetch Transactions for the current page $stmt = $db->prepare("SELECT * FROM transactions WHERE user_id = :user_id ORDER BY created_at DESC LIMIT :limit OFFSET :offset"); $stmt->bindValue(':user_id', $user['id'], PDO::PARAM_INT); $stmt->bindValue(':limit', $records_per_page, PDO::PARAM_INT); $stmt->bindValue(':offset', $offset, PDO::PARAM_INT); $stmt->execute(); $transactions = $stmt->fetchAll(PDO::FETCH_ASSOC); $site_name = 'Kutumbh Infra'; ?> Transaction Ledger - <?php echo htmlspecialchars($site_name); ?>

Your Transactions

Wallet Balance

₹

Date	Type	Amount	Description
No transactions found.
		= 0 ? '+' : '-') . ' ₹' . number_format(abs($tx['amount']), 2); ?>