File "download_users_log.php"

Full path: /home/mysamm/public_html/mysamm_login/download_users_log.php
File size: 1.31 B
MIME-type: text/x-php; charset=us-ascii
Charset: utf-8

Download   Open   Edit   Advanced Editor &nnbsp; Back

<?php
require_once "/home/mysamm/price_checker/lib/connections.php";

// Start session if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Check if user is superadmin
if (!isset($_SESSION['user_type']) || $_SESSION['user_type'] !== 'superadmin') {
    header("Location: login.php");
    exit();
}

$db = new Connection();

// Set headers to prompt browser download as CSV
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=users_log.csv');

// Open output stream
$output = fopen('php://output', 'w');

// Output column headings
fputcsv($output, ['ID', 'User Name', 'Admin Name', 'Last Login', 'IP Address', 'Last Page']);

// Fetch users log (you can limit to last month by uncommenting the WHERE clause below)
$query = "
    SELECT id, user_name, admin_name, last_login, ip_address, last_page 
    FROM users_log 
    
";
$i=1;
$result = $db->Query($query);

// Output each row as a line in CSV
foreach ($result as $row) {
    fputcsv($output, [
        $i++,
        ucfirst($row['user_name']),
        $row['admin_name'],
        date("F j, Y, g:i a", strtotime($row['last_login'])),
        $row['ip_address'],
        $row['last_page']
    ]);
}

// Close output stream
fclose($output);
exit;
?>