Tiny File Manager

Back Back Up Advanced Editor

<?php
include 'includes/configuration.php'; 
session_start();
$user = base64_decode($_SESSION["user_id"]);

// Get the number of days to filter by, default to 1 (today) if not specified
$days = isset($_GET['days']) && $_GET['days'] !== 'all' ? (int)$_GET['days'] : 'all';

// Prepare SQL query based on the selected days filter
if ($days === 'all') {
    // Query to get all records
    $sql = "SELECT * FROM history_work ORDER BY id DESC";
} else {
    // Query to get records within the last specified days
    $sql = "SELECT * FROM history_work WHERE order_time >= DATE_SUB(CURDATE(), INTERVAL ? DAY) ORDER BY id DESC";
}

// Use prepared statements for security
$stmt = $conn->prepare($sql);
if ($days !== 'all') {
    $stmt->bind_param("i", $days);  // Bind the days parameter if it's a number
}
$stmt->execute();
$result = $stmt->get_result();

$data = [];
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $data[] = [
            'id' => $row["id"],
            'email' => $row["email"],
            'orderType' => $row["order_type"],
            'price' => $row["price"],
            'beforeBalance' => $row["current_balance"],
            'afterBalance' => $row["balance_after_cut"],
            'orderTime' => $row["order_time"]
        ];
    }
}

// Return the data as JSON
header('Content-Type: application/json');
echo json_encode($data);
?>