functions.php

<?php

//returns ALL users in table

    function getUsers($sql) {
        return $sql->query("
        SELECT users.*, roles.name AS role_name
        FROM users
        JOIN roles ON role_id = roles.id
        ORDER BY name DESC")->fetchAll();
    }
// selects ONE user, which ID = id (is used for edit / delete or click on detail page)
    function getUser($sql, $id) {
        $stmt = $sql->prepare("
        SELECT * FROM users WHERE id = ?");

        $stmt->execute([$id]);
        return $stmt->fetch();
    }

    //(prepares to)insert new data to the table USERS. 
    //execute -> INSERTS data to table
    function addUser($sql, $name, $email, $role_id, $is_active, $avatar) {
        $stmt = $sql->prepare("
        INSERT INTO users (name, email, role_id, is_active, avatar)
        VALUES (?,?,?,?,?)");

        $stmt->execute([$name, $email, $role_id, $is_active, $avatar]);

    }
    //edits values on an ID you click on basically, due to the where id = ?. 
    function editUser($sql, $id, $name, $email, $role_id, $is_active, $avatar) {
        $stmt = $sql->prepare("
        UPDATE users
        SET name = ?, email = ?, role_id = ?, is_active = ?, avatar = ?
        WHERE id = ?");

        $stmt->execute([$name, $email, $role_id, $is_active, $avatar, $id]);
    }

    //deletes row where id = ?. 
    function deleteUser($sql, $id) {
        $stmt = $sql->prepare("DELETE FROM users WHERE id = ?");

        $stmt->execute([$id]);
    }
    
    //returns all roles 
    function getRoles($sql){
        return $sql->query("SELECT * FROM roles ORDER BY name DESC")->fetchAll();
    }