PHP Hit/Visitor Log
I'm trying to create a PHP hit log. My object is to track my entire site, and sort the results into six different tables: Home page, Images page, Downloads page, About page, Other pages (I run a blog, so other pages would be the posts) and Admin visits. The hits are stored in a mysql database. Here is my current code:
Report Page
Database Creation PagePHP Code:<HTML><HEAD></HEAD><BODY>
<script type="text/javascript">
//JK Popup Window Script (version 3.0)- By JavaScript Kit (http://www.javascriptkit.com)
//Visit JavaScriptKit.com for free JavaScripts
//This notice must stay intact for legal use
function openpopup(popurl){
var winpops=window.open(popurl,"","width=1000,height=800,location,status,scrollbars")
}
</script>
<CENTER><H1>REPORT OF HITS</H1></CENTER>
<?PHP
function ConnectDB(){ // connects to database
$conn = mysql_connect('*********', '********, '********') or die('Could not connect: ' . mysql_error());
mysql_select_db('********') or die('Could not select database');
return $conn;
}
function ShowBrief(){
echo"<br>";
echo"<h3>Home</h3>";
echo "<TABLE border=1><THEAD><TR><TH>ID</TH><TH>DATE</TH><TH>TIME</TH><TH>IP</THEAD><TBODY>";
$results=mysql_query("SELECT * FROM log WHERE l_page='fogarty4.co.cc' AND l_remoteIP!='************'");
while ($row = mysql_fetch_array($results)) {
echo "<TR><TD>$row[0]</TD><TD>$row[1]</TD><TD>$row[2]</TD><TD><a href='javascript:openpopup('http://cqcounter.com/whois/?query=$row[3]&map=1')'>$row[3]</a></TD></TR>";
}
echo "</TBODY>";
echo"<br>";
echo"<h3>Images</h3>";
echo "<TABLE border=1><THEAD><TR><TH>ID</TH><TH>DATE</TH><TH>TIME</TH><TH>IP</THEAD><TBODY>";
$results2=mysql_query("SELECT * FROM log WHERE l_page='fogarty4.co.cc/images' AND l_remoteIP!='************'");
while ($row2 = mysql_fetch_array($results2)) {
echo "<TR><TD>$row2[0]</TD><TD>$row2[1]</TD><TD>$row2[2]</TD><TD><a href='javascript:openpopup('http://cqcounter.com/whois/?query=$row[3]&map=1')'>$row2[3]</a></TD></TR>";
}
echo "</TBODY>";
echo"<br>";
echo"<h3>Downloads</h3>";
echo "<TABLE border=1><THEAD><TR><TH>ID</TH><TH>DATE</TH><TH>TIME</TH><TH>IP</THEAD><TBODY>";
$results3=mysql_query("SELECT * FROM log WHERE l_page='fogarty4.co.cc/downloads' AND l_remoteIP!='************'");
while ($row3 = mysql_fetch_array($results3)) {
echo "<TR><TD>$row3[0]</TD><TD>$row3[1]</TD><TD>$row3[2]</TD><TD><a href='javascript:openpopup('http://cqcounter.com/whois/?query=$row[3]&map=1')'>$row3[3]</a></TD></TR>";
}
echo "</TBODY>";
echo"<br>";
echo"<h3>About</h3>";
echo "<TABLE border=1><THEAD><TR><TH>ID</TH><TH>DATE</TH><TH>TIME</TH><TH>IP</THEAD><TBODY>";
$results4=mysql_query("SELECT * FROM log WHERE l_page='fogarty4.co.cc/about' AND l_remoteIP!='************'");
while ($row4 = mysql_fetch_array($results4)) {
echo "<TR><TD>$row4[0]</TD><TD>$row4[1]</TD><TD>$row4[2]</TD><TD><a href='javascript:openpopup('http://cqcounter.com/whois/?query=$row[3]&map=1')'>$row4[3]</a></TD></TR>";
}
echo "</TBODY>";
echo"<br>";
echo"<h3>Other</h3>";
echo "<TABLE border=1><THEAD><TR><TH>ID</TH><TH>DATE</TH><TH>TIME</TH><TH>IP</THEAD><TBODY>";
$results4=mysql_query("SELECT * FROM log WHERE l_page!='fogarty4.co.cc' OR l_page!='fogarty4.co.cc/images' OR l_page!='fogarty4.co.cc/downloads' OR l_page!='fogarty4.co.cc/about' AND l_remoteIP!='************'");
while ($row4 = mysql_fetch_array($results4)) {
echo "<TR><TD>$row4[0]</TD><TD>$row4[1]</TD><TD>$row4[2]</TD><TD><a href='javascript:openpopup('http://cqcounter.com/whois/?query=$row[3]&map=1')'>$row4[3]</a></TD></TR>";
}
echo "</TBODY>";
echo"<br>";
echo"<h3>Admin</h3>";
echo "<TABLE border=1><THEAD><TR><TH>ID</TH><TH>DATE</TH><TH>TIME</TH><TH>IP</THEAD><TBODY>";
$results6=mysql_query("SELECT * FROM log WHERE l_remoteIP = '************'");
while ($row6 = mysql_fetch_array($results6)) {
echo "<TR><TD>$row6[0]</TD><TD>$row6[1]</TD><TD>$row6[2]</TD><TD><a href='javascript:openpopup('http://cqcounter.com/whois/?query=$row[3]&map=1')'>$row6[3]</a></TD></TR>";
}
echo "</TBODY>";
}
$conn=ConnectDB();
ShowBrief();
$conn->close;
?>
</BODY></HTML>
Tracking CodePHP Code:<?PHP
function ConnectDB(){ // connects to database
$conn = mysql_connect('*********', '*********', '*********') or die('Could not connect: ' . mysql_error());
mysql_select_db('*********') 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), l_page longtext);";
$results=mysql_query($query);
$conn->close;
echo "Complete.";
}
$conn=ConnectDB();
MakeDB();
$conn->close;
?>
I starred out my mysql connection and my IPPHP Code:<?PHP
function ConnectDB(){ // connects to database
$conn = mysql_connect('*********', '*********', '*********') or die('Could not connect: ' . mysql_error());
mysql_select_db('*********') or die('Could not select database');
return $conn;
}
function WriteLog(){
$remoteIP=$_ENV["REMOTE_ADDR"];
$current = $_SERVER["HTTP_HOST"] . $_SERVER["REQUEST_URI"];
$query="INSERT INTO log SET l_date=CURDATE(), l_time=CURTIME(), l_remoteIP=\"$remoteIP\", l_page=\"$current\"";
$results=mysql_query($query);
}
$conn=ConnectDB();
WriteLog();
$conn->close;
?>
If anyone could help me that would be great.
Thanks in advance.
CSS Codes
Reply With Quote
Bookmarks