Gecko [ 37julay.space ]

Linux moon.hostseba.com 4.18.0-553.51.1.lve.el8.x86_64 #1 SMP Tue May 6 15:14:12 UTC 2025 x86_64
LiteSpeed
Server IP : 103.174.152.68 & Your IP : 216.73.216.9
Domains : Cant Read [ /etc/named.conf ]
User : julaysp1

Name	Size	Permission	Date
Bangla.ttf	137.05 KB	-rw-r--r--	2023-12-20 13:06
admin_file_upload.php	2.96 KB	-rw-r--r--	2024-11-16 10:37
balance_add_remove.php	2.83 KB	-rw-r--r--	2024-10-26 14:38
birthKey-20250912191216.txt	24 B	-rw-r--r--	2025-05-21 11:30
birthKey-20250912213943.txt	24 B	-rw-r--r--	2025-05-21 11:30
birthKey-20250912213951.txt	24 B	-rw-r--r--	2025-05-21 11:30
card_make.txt	1 B	-rw-r--r--	2025-08-20 19:12
config.php	392 B	-rw-r--r--	2024-12-04 06:50
get_work_history.php	1.4 KB	-rw-r--r--	2024-11-14 17:27
htaccess.txt	120 B	-rw-r--r--	2025-08-21 08:56
wp-blog-header.php	0 B	-rw-r--r--	2025-09-12 19:14
wp-cron.php	2.73 KB	-rw-r--r--	2025-09-01 07:25

Rename

<?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);
?>