index.php

<?php
    require "db.php";
    require "functions.php";
    require "header.php";

    $users = getUsers($sql);
?>
    <h1>Users administration </h1>
    <a class="action" href="user_add.php">Add user</a>
    <br><br>

    <table>
        <tr>
            <th>Avatar</th>
            <th>Name</th>
            <th>Email</th>
            <th>Role</th>
            <th>Active</th>
            <th>Actions</th>
        </tr>

        <?php foreach($users as $user): ?>
            <tr>
                <td>
                    <img class="avatar" src="uploads/<?=$user["avatar"]?>">
                </td>
                <td><?=$user["name"]?>
                <td><?=$user["email"]?>
                <td><?=$user["role_name"]?>
                <td>
                    <?php if($user["is_active"] == 1): ?>
                        YES
                    <?php else: ?>
                        NO 
                    <?php endif; ?>
                    </td>
                <td>
                    <a class="action" href="user_edit.php?id=<?=$user["id"]?>">Edit</a>
                    <a class="action danger" href="user_delete.php?id=<?=$user["id"]?>">Delete</a>
                </td >
            </tr>
        <?php endforeach; ?>
    </table>