Simple User Test

1. Database Connection Test:

✅ Database connection successful

2. tbl_users Table Test:

Total users in database: 41

3. tbl_roles Table Test:

Total roles in database: 4

4. All Roles:

Array
(
    [0] => Array
        (
            [role_id] => 1
            [role_name] => Super Admin
        )

    [1] => Array
        (
            [role_id] => 2
            [role_name] => Admin
        )

    [2] => Array
        (
            [role_id] => 3
            [role_name] => Teacher
        )

    [3] => Array
        (
            [role_id] => 4
            [role_name] => Parent
        )

)

5. Users with Role IDs:

Array
(
    [0] => Array
        (
            [user_id] => 1
            [user_firstname] => Chansss
            [user_lastname] => Clarino
            [user_role] => 1
            [user_status] => Active
        )

    [1] => Array
        (
            [user_id] => 2
            [user_firstname] => Kristopher
            [user_lastname] => Dichos
            [user_role] => 2
            [user_status] => Active
        )

    [2] => Array
        (
            [user_id] => 3
            [user_firstname] => Andrew
            [user_lastname] => Nerona
            [user_role] => 2
            [user_status] => Active
        )

    [3] => Array
        (
            [user_id] => 4
            [user_firstname] => Angela
            [user_lastname] => Borres
            [user_role] => 3
            [user_status] => Active
        )

    [4] => Array
        (
            [user_id] => 5
            [user_firstname] => Jessa
            [user_lastname] => Decena
            [user_role] => 3
            [user_status] => Active
        )

    [5] => Array
        (
            [user_id] => 6
            [user_firstname] => Carla
            [user_lastname] => Tan
            [user_role] => 4
            [user_status] => Active
        )

    [6] => Array
        (
            [user_id] => 7
            [user_firstname] => Bryan
            [user_lastname] => Lopez
            [user_role] => 4
            [user_status] => Active
        )

    [7] => Array
        (
            [user_id] => 8
            [user_firstname] => Elaine
            [user_lastname] => Mendoza
            [user_role] => 4
            [user_status] => Active
        )

    [8] => Array
        (
            [user_id] => 9
            [user_firstname] => Jess
            [user_lastname] => Morcillos
            [user_role] => 3
            [user_status] => Active
        )

    [9] => Array
        (
            [user_id] => 10
            [user_firstname] => Johanna
            [user_lastname] => Ebarat
            [user_role] => 3
            [user_status] => Active
        )

)

6. Testing JOIN Query (API Logic):

Array
(
    [0] => Array
        (
            [user_id] => 1
            [user_firstname] => Chansss
            [user_lastname] => Clarino
            [user_role] => 1
            [role_name] => Super Admin
        )

    [1] => Array
        (
            [user_id] => 2
            [user_firstname] => Kristopher
            [user_lastname] => Dichos
            [user_role] => 2
            [role_name] => Admin
        )

    [2] => Array
        (
            [user_id] => 3
            [user_firstname] => Andrew
            [user_lastname] => Nerona
            [user_role] => 2
            [role_name] => Admin
        )

    [3] => Array
        (
            [user_id] => 4
            [user_firstname] => Angela
            [user_lastname] => Borres
            [user_role] => 3
            [role_name] => Teacher
        )

    [4] => Array
        (
            [user_id] => 5
            [user_firstname] => Jessa
            [user_lastname] => Decena
            [user_role] => 3
            [role_name] => Teacher
        )

)

7. Users with NULL role_name (Potential Issue):

Array
(
)

✅ No users found with NULL role_name