how do you track down how many time a file was accessed?

[vboyz]

how do you track down how many time a file was accessed?

[herve]

Hi,

there's many way of doing so;

If the "file" you are speaking about is a regular HTML file,
you can include something like that :

$sql_cmd="UPDATE stats SET hits_nb=hits_nb+1 WHERE id=$id";

where $id is the identifier used for your HTML page
for instance.

Hervé.

[Kerry_Kobashi]

You could create a generic class, say something like this - algorithm below:

class FileHits
{
function Hit()
{
$filename = $_SERVER["SCRIPT_NAME"];
// connect to database
// open database
// query to see if $filename exists
// if it exists UPDATE count by 1
// if it doesn't exist insert the filename and set count to 1
// disconnect from database
}
}

The trick is to use the SCRIPT_NAME as an index so you don' t have to go out and type in tons of filenames into the database to start things off! 😃

Kerry Kobashi
Kobashi Computing