Users Current Activity

[ayesha789]

This is my table which I used to get access time of users at every single minute.

--
-- Table structure for table `members_log`
--

CREATE TABLE IF NOT EXISTS `members_log` (
  `SrNo` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(25) NOT NULL,
  `access_time` datetime NOT NULL,
  PRIMARY KEY (`SrNo`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

I used this query in my connection file.

mysql_query("INSERT INTO members_log (UserName,access_time)
				VALUES
				('$_SESSION[myusername]',NOW())");

Now I want to add more functionality in it.
I want to know user click which page of DB when time inserted.

[ddymacek]

use $_SERVER

The filename of the currently executing script, relative to the document root. For instance, $_SERVER in a script at the address http://example.com/test.php/foo.bar would be /test.php/foo.bar.

alternatively
you could use
$_SERVER

and pass in an update to the member_log table or on the initial insert

[ayesha789]

is it possible to get name of the file currently user getting, any small example please

[ayesha789]

is it possible to get name of the file currently user getting, any small example please

[ayesha789]

Thanks . its working