List of online users

Asked

Viewed 154 times

0

I need to create a list of online users at the moment, or even 20 minutes ago. Being that the table with the data of the users is called 'User', and the table that has the accesses of these users is called 'Core.logs'.

I have no idea how to do this! Can someone at least give me a hint?

php

  • What are these tables? Database tables? If so, which database? What is the structure of the tables? If not, are they text files? How they are organized?

  • Yes, from a database, Mysql. Table structure: user Columns: user_id int(11) AI PK user_type int(11) name varchar(255) nickname varchar(255) email varchar(255) password varchar(255) image varchar(255) sessao varchar(255) telephone varchar(45) cargo varchar(255) sector varchar(255) status int(1) api_key varchar(255) Table: core_logs Columns: core_logs_id int(11) AI PK usuario_id int(11) cliente_id int(11) references varchar(45) acao Enum('C','R','U',’D') sessao_alias varchar(255) Metadata longtext data timestamp

1 answer

2


As far as I could tell, Core.logs is an audit table.

The date field should probably store date of actions that were performed by users.

You can take this date and do a check, where the last actions within 20 minutes you show the user data in a list.

  • But how would I make that check?

Browser other questions tagged php

You are not signed in. Login or sign up in order to post.