Users Table Structure:
Array
(
[0] => Array
(
[Field] => id
[Type] => int(11)
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
[1] => Array
(
[Field] => full_name
[Type] => varchar(100)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[2] => Array
(
[Field] => username
[Type] => varchar(50)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
[3] => Array
(
[Field] => email
[Type] => varchar(100)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
[4] => Array
(
[Field] => password
[Type] => varchar(255)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[5] => Array
(
[Field] => role
[Type] => enum('admin','user')
[Null] => YES
[Key] =>
[Default] => user
[Extra] =>
)
[6] => Array
(
[Field] => created_at
[Type] => timestamp
[Null] => NO
[Key] =>
[Default] => current_timestamp()
[Extra] =>
)
[7] => Array
(
[Field] => updated_at
[Type] => timestamp
[Null] => NO
[Key] =>
[Default] => current_timestamp()
[Extra] => on update current_timestamp()
)
[8] => Array
(
[Field] => logout_time
[Type] => datetime
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[9] => Array
(
[Field] => profile_picture
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
)
Sample User Data:
Array
(
[id] => 4
[full_name] => admin
[username] => admin
[email] => elog.dfar@gmail.com
[password] => $2a$12$bnfsaX8B6mSVG9oUJVGLEuqPnqK/vh6dj4eaY3SQVUittNXUvM8oG
[role] => admin
[created_at] => 2025-12-31 15:20:33
[updated_at] => 2025-12-31 15:20:33
[logout_time] =>
[profile_picture] =>
)