23 replies to this topic

[amrosama]

hi guys,
ive finally hosted the company i work in website, and they asked for more stuff to do. but theres one thing that drives me crazy, they want to add a page in the backend that shows the currently active users.
i have no idea how to do that, because ive never worked on an online website before. how can this be done?
the only solution i thought of is making a table in database with active users that gets updated everytime a user navigates through a page, but the problem is: most users will not be inactive normally because they dont always logout normally(closing browser or leaving it open)
i want some thing like "active members" that appears at the bottom of cc pages

any ideas?

[BlaineSch]

Table:
id, ip, datetime


Every page should add a new row in there, do a query selecting rows within the past 5 minutes, based on a unique IP address.

[amrosama]

nice thnx for both of you :amr:
ill do that rightnow +rep to both

[BlaineSch]

Yes Jordan you are probably right, that was how I did mine, but I was using my own stat program for that site, not a different one so this was also how I tried which pages where visited and from where etc.

I suppose if that is all you need then yours is probably better.

[amrosama]

tried that, and its working now. i used a "replace" statement. just love it :D

[BlaineSch]

Replace? for what? lol

You should post up your code! :D

[amrosama]

/*

 * `navigation` (

`username` VARCHAR( 50 ) NOT NULL  PK,

`ip` VARCHAR( 120 ) NOT NULL ,

`time` DATETIME NOT NULL ,

`page` VARCHAR( 200 ) NOT NULL PK

)

*/

$date=date('c');

query2("replace into navigation (username,ip,time,page) values('$_SERVER[REMOTE_ADDR]','$_SERVER[REMOTE_ADDR]','$date','$_SERVER[PHP_SELF]')  ");

}

its pretty small but the size doesnt matter :amr:, now i will code the display
query2 is a function i use to check for log and checking user privileges
the $_SESSION['v_user'] is the session variable for user-name
theres three active bastards rightnow :D

[amrosama]

me, my boss, and a co-worker