Hi,
I would like to be able to automate collection of user/connection information into a database and wondering what would be some way(s) of going about this. Hopefully there are some approaches that don’t take much hand coding.
Much appreciate any suggestions.
Thank you.
Lyle
In the superglobal $_Server you will find a lot of information which is collected automatically. See http://www.w3schools.com/php/php_superglobals.asp for that. Of course you need to insert this data into your database manually. But you can generate a small scriptsample. I useually use the sql builder to create a select around a table and ‘misuse’ that to create my insert.
Not saying it’s the best way to do it nor that it’s the best idea but you could try something like making a database table with all the users in it and then a column for where they are and one for the timestamp/date and time. Then in all your applications in the onScriptinit or onLoad something like that, update the record in that table, there’s ways to check whether it’s in update/insert mode too so that shouldn’t be the problem.
However there is the thing that I don’t really know how you’d handle people closing the page.
Hi Albert,
Thank you greatly.
Lyle