Retrieve the Activity Logs

After recording the administrator's activity, retrieve the records from MySQL. Use:

code php

$stmt = $pdo->query("
    SELECT
        activity_log_id,
        user_id,
        user_email,
        activity_log_action,
        activity_log_status,
        activity_log_ip_address,
        activity_log_user_agent,
        activity_log_created_at

    FROM activity_logs

    ORDER BY activity_log_created_at DESC
");

The query means:

code text

SELECT
    activity information
FROM
    activity_logs
ORDER BY
    newest activity first

The following:

code sql

ORDER BY activity_log_created_at DESC

ensures that the newest activity appears first. --- Convert the query results into a PHP array:

code php

$activities = $stmt->fetchAll(PDO::FETCH_ASSOC);

The result may look conceptually like:

code text

$activities

[
    [
        activity_log_id => 10,
        user_id => 1,
        user_email => admin@example.com,
        activity_log_action => view_activity_logs,
        activity_log_status => success,
        ...
    ],

    [
        activity_log_id => 9,
        user_id => 2,
        user_email => manager@example.com,
        activity_log_action => login,
        activity_log_status => success,
        ...
    ]
]

format_list_numbered Step 3 of 7

chevron_left Previous Next chevron_right