Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ari/tracker

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: get_transactions.php

<?php
header('Content-Type: application/json');
require_once 'database.php';

try {
    // Get transactions
    $stmt = $pdo->query("SELECT * FROM transactions ORDER BY date DESC");
    $transactions = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Calculate totals
    $incomeStmt = $pdo->query("SELECT SUM(amount) as total FROM transactions WHERE type = 'income'");
    $income = $incomeStmt->fetch(PDO::FETCH_ASSOC)['total'] ?? 0;
    
    $expenseStmt = $pdo->query("SELECT SUM(amount) as total FROM transactions WHERE type = 'expense'");
    $expenses = $expenseStmt->fetch(PDO::FETCH_ASSOC)['total'] ?? 0;
    
    $balance = $income - $expenses;
    
    // Generate HTML for transactions
    $html = '';
    foreach($transactions as $transaction) {
        $amountClass = $transaction['type'] == 'income' ? 'text-green-600' : 'text-red-600';
        $amountPrefix = $transaction['type'] == 'income' ? '+' : '-';
        
        $html .= '<tr class="border-b">';
        $html .= '<td class="p-2">' . $transaction['date'] . '</td>';
        $html .= '<td class="p-2">' . htmlspecialchars($transaction['description']) . '</td>';
        $html .= '<td class="p-2">' . ucfirst($transaction['category']) . '</td>';
        $html .= '<td class="p-2 text-right ' . $amountClass . '">' . $amountPrefix . '$' . number_format($transaction['amount'], 2) . '</td>';
        $html .= '<td class="p-2"><button onclick="deleteTransaction(' . $transaction['id'] . ')" class="text-red-600 hover:text-red-800">Delete</button></td>';
        $html .= '</tr>';
    }
    
    echo json_encode([
        'html' => $html,
        'totals' => [
            'income' => floatval($income),
            'expenses' => floatval($expenses),
            'balance' => floatval($balance)
        ]
    ]);
} catch(PDOException $e) {
    echo json_encode(['html' => '<tr><td colspan="5">Error loading transactions</td></tr>', 'totals' => ['income' => 0, 'expenses' => 0, 'balance' => 0]]);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get_transactions.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation