visitors infomation

Junior WebHelper Joined: 10 Apr 2004 Posts: 5

I've been trying to code a simple app which will store the date, ip, hostname and referer of the visitor and store it into mysql database.
I've have so many problems with doing this. In the end i decided to start basic and i've coded and very simple one which will only get the hostname, byusing the following code.

Code:

<?php
$db = mysql_connect("host","username","password");
mysql_select_db("database",$db);
$hostname = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$query = "INSERT INTO stats(hostname) VALUES('$hostname');
$result = mysql_query($query);
?>

This still doesn't work, can someone give me some help or advice?

Regards

Team Member Joined: 06 Jan 2002 Posts: 2564

Are the entries in your database empty, or are there none at all?

Junior WebHelper Joined: 10 Apr 2004 Posts: 5

Nothing at all but also i get an error
Parse error: parse error in stats.php on line 9

Team Member Joined: 06 Jan 2002 Posts: 2564

Here is the problem:

Code:

$query = "INSERT INTO stats(hostname) VALUES('$hostname');

Replace that with

Code:

$query = "INSERT INTO stats(hostname) VALUES('$hostname')";

Junior WebHelper Joined: 10 Apr 2004 Posts: 5

Display the results in the database

Code:

<?php

$db = mysql_connect("host","user","password");
mysql_select_db("retro",$db);

Print ("Visitor Stats Logfile");
print ("<table width=\"100%\" border=\"0\"> <tr> <td width=\"242\">Date</td> <td width=\"242\">IP</td> <td width=\"242\">Hostname</td> <td width=\"242\">Referer</td></tr>");

$Query2 = "SELECT * from Stats";
$Results = mysql_db_query("retro",$query, $db);
while($Row2 = mysql_fetch_array($Result2)){
print(" <tr> <td width=\"242\"></td>
<td width=\"242\">$Row2[date]</td> <td width=\"242\">$Row2[ip]</td>
<td width=\"242\">$Row2[hostname]</td> <td width=\"242\">$Row2[referer]</td>
</tr>");} print("</table">;
?>

Parse error: parse error in /mnt/host-users/r/e/t/viewstats.php on line 15

Team Member Joined: 06 Jan 2002 Posts: 2564

Replace

Code:

print(" <tr> <td width=\"242\"></td>
<td width=\"242\">$Row2[date]</td> <td width=\"242\">$Row2[ip]</td>
<td width=\"242\">$Row2[hostname]</td> <td width=\"242\">$Row2[referer]</td>
</tr>");

with

Code:

print(' <tr> <td width="242">' . $Row2[id] . '</td>
<td width="242">' . $Row2[date] . '</td> <td width="242">' . $Row2[ip] . '</td>
<td width="242">' . $Row2[hostname] . '</td> <td width="242"> ' . $Row2[referer] . '</td>
</tr>');

Junior WebHelper Joined: 10 Apr 2004 Posts: 5

Still having problems with it
this is the full code as of now:

Code:

<?php

$db = mysql_connect(host,username,password);
mysql_select_db("retro",$db);

Print ("Visitor Stats Logfile");
print ("<table width=\"100%\" border=\"0\"> <tr> <td width=\"242\">Date</td> <td width=\"242\">IP</td> <td width=\"242\">Hostname</td> <td width=\"242\">Referer</td></tr>");

$Query2 = "SELECT * from Stats";
$Results = mysql_db_query("retro",$query, $db);

while($Row2 = mysql_fetch_array($Result2))
{
print(' <tr> <td width="242">' . $Row2[id] . '</td> <td width="242">' . $Row2[date] . '</td> <td width="242">' . $Row2[ip] . '</td> <td width="242">' . $Row2[hostname] . '</td> <td width="242"> ' . $Row2[referer] . '</td> </tr>');
}

print("</table">;
?>

Team Member Joined: 06 Jan 2002 Posts: 2564

What is the problem now?

Junior WebHelper Joined: 10 Apr 2004 Posts: 5

still getting 'Parse error' i've looked and looked and cant find anything wrong with it. I think its something to do with the loop, but like i said i cant find anything wong with it.

Posted: Tue Apr 13, 2004 4:52 pm (20 years ago)

Its this:
print("</table">;

should be:
print("</table>");