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.

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

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

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

Thanks . its working

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.