Instead of simply a hit-counter, it would be nice to have a record of the time of the day your site has been visited, and by whom. This example will do just that.
It is a three part procedure that consists of
1. Make and execute a file containing the procedure to create a hit-log database at a location designated by your service provider,
2. Insert PHP code at the end of your HTML pages, but rename them to .php instead of the usual .htm or .html extension.
3. Make a procedure file that displays the report of the hit-log database.
Here are the details.
1. Make a procedure file in your home directory to create a table in a database
You will have to find out from your service provider the following information:
- the name of the MySql database server, or computer (name_of_server)
- the name of the account (account_name) and password (password)
- and the name of the database (database_name)
Insert following code in a file called MakeDB.php in your site's home directory to create a new table called "log", or any other name of your choice. If you are using someone else's account, make sure that he/she does not already have a table called "log". Execute the procedure once. In fact, you could execute it as many times as you wish, it will wipe out all the data already stored in the table, if there was any.
<?PHP
function ConnectDB(){ // connects to database
$conn = mysql_connect('name_of_server', 'account_name', 'password') or die('Could not connect: ' . mysql_error());
mysql_select_db('database_name') or die('Could not select database');
return $conn;
}
function MakeDB(){
$conn=ConnectDB();
$query="drop table log;"; $results=mysql_query($query);
$query="create table log (l_index int auto_increment primary key,l_date date, l_time char(8), l_remoteIP varchar(15));";
$results=mysql_query($query);
$conn->close;
}
$conn=ConnectDB();
MakeDB();
$conn->close;
?>
2. Insert the following code at the end of your HTML files where you want the hits recorded, not forgetting to rename your file's extension htm or .html to .php:
<?PHP
function ConnectDB(){ // connects to database
$conn = mysql_connect('name_of_server', 'account_name', 'password') or die('Could not connect: ' . mysql_error());
mysql_select_db('database_name') or die('Could not select database');
return $conn;
}
function WriteLog(){
$remoteIP=$_ENV["REMOTE_ADDR"];
$query="INSERT INTO log SET l_date=CURDATE(), l_time=CURTIME(), l_remoteIP=\"$remoteIP\" ";
$results=mysql_query($query);
}
$conn=ConnectDB();
WriteLog();
$conn->close;
?>
3. Getting a report of the hits.
It would be nice to view your hit-log, execute the following code that you put in a file called Report.php:
<HTML><HEAD></HEAD><BODY>
<CENTER><H1>REPORT OF HITS</H1></CENTER>
<?PHP
function ConnectDB(){ // connects to database
$conn = mysql_connect('name_of_server', 'account_name', 'password') or die('Could not connect: ' . mysql_error());
mysql_select_db('database_name') or die('Could not select database');
return $conn;
}
function ShowBrief(){
echo "<TABLE border=1><THEAD><TR><TH>ID</TH><TH>DATE</TH><TH>TIME</TH><TH>IP</THEAD><TBODY>";
$query='select * from log';
$results=mysql_query($query);
while ($row = mysql_fetch_array($results)) {
echo "<TR><TD>$row[0]</TD> <TD>$row[1]</TD><TD>$row[2]</TD><TD>$row[3]</TD></TR>";
}
echo "</TBODY>";
}
$conn=ConnectDB();
ShowBrief();
$conn->close;
?>
</BODY></HTML>
Here it is, a simple but useful code example using PHP and MySql to record your hits.
Updates to this example, if any, will be posted at http://www.mathpath.uni.cc
and look under programming.
