So I was thinking about getting the user table where status = online / strong>, but I know that when the user shuts down the computer without clicking Log out, the table will not be changed offline , so I want to know what is best:
-
DATETIME
-
TIMESTAMP
What do you recommend me? I want to make data with "Last Activity" where if it does any action involving $ _GET or $ _ POST updates the status table (I will convert to TIMESTAMP or DATETIME) X minutes ago or something, I want examples so I will not put my DATABASE in question here. Thanks for all the reviews, and examples discussed.
I still do not understand how Gmail-type services, Facebook among others make this relationship between offline and online, so if anyone is also willing to explain this, welcome