<?php
// This script displays the number of hits you received from each ISP.
// It reads the database used in ahostlookup class and extracts the
// information for those records with a count greater than zero. It then
// displays the information in a table.
//
// ****** edit next two lines to put your own username, password and database_name.
$db = mysql_connect("localhost","username","password");
mysql_select_db("database_name",$db);
?>
<h4>A List of all table entries with a count greater than 0</h4>
<table border="5" bordercolor="000088" cellspacing="0" cellpadding="2">
<tr bgcolor="#000088">
<td><font color="#FFFFFF"><b>IDnum</b></font></td>
<td><font color="#FFFFFF"><b>Host Name</b></font></td>
<td><font color="#FFFFFF"><b>Zip Code</b></font></td>
<td><font color="#FFFFFF"><b>Count</b></font></td>
<td><font color="#FFFFFF"><b>Date</b></font></td>
<td><font color="#FFFFFF"><b>Time</b></font></td>
</tr>
<?php
$i=0;
$result = mysql_query("SELECT * FROM isps WHERE count>0 ORDER BY count");
while ($myrow = mysql_fetch_array($result)) {
$id = $myrow["id"];
printf("<tr bgcolor='#bbddee'><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td>", $id, $myrow["host"],$myrow["zip"], $myrow["count"], $myrow["date"], $myrow["time"]);
$i=$i+1;
}
print("</table><br>");
?>
|
Download
