bubble_chart StackLab

Activity Logs using HTML + PHP + MySQL

7 steps · pending Not started · person_outline Guest
arrow_back Back

Display the Activity Data

Each database field can be displayed using:

code php
<?= htmlspecialchars(...) ?>
Example:
code php
<td>
    <?= htmlspecialchars(
        $activity['user_email']
    ) ?>
</td>
The same pattern is used for the other fields:
code php
$activity['activity_log_id']
$activity['user_id']
$activity['user_email']
$activity['activity_log_action']
$activity['activity_log_status']
$activity['activity_log_ip_address']
$activity['activity_log_user_agent']
$activity['activity_log_created_at']
--- Why Use htmlspecialchars()? Never directly print database content into HTML without escaping it. Avoid:
code php
<?= $activity['user_email'] ?>
Use:
code php
<?= htmlspecialchars(
    $activity['user_email']
) ?>
This helps prevent malicious HTML or JavaScript stored in database values from being interpreted by the browser. The basic rule is:
Escape data before displaying it in HTML.

login Sign in to save your progress permanently. info Progress is saved in your browser session
format_list_numbered Step 6 of 7