Location: PHPKode > projects > logViewSQL > apache/view-request.php
<?php
/* 
 * This is a php frontend for mod_log_sql. It interfaces
 * with the table structure as defined in a MySql database and has been
 * tested only with version 1.16 of mod_log_sql.
 *
 * contact hide@address.com
 *
 */
	require("db-connect-apache.php");
	require("apache-common.php");
	require("header.php");
	$query = "select * from ".mysql_escape_string($dbs)." where request_uri='".base64_decode($uri).customFilter(1)."' order by time_stamp desc";
	$results=queryWithPage($query, $offset);
?>
<center>
	<table border=1 cellspacing=0 cellpadding=2>
		<tr><td bgcolor=lemonchiffon><b>Country</b></td><td bgcolor=lemonchiffon><b>Host</b></td><td bgcolor=lemonchiffon><b>Time</b></tr>
		<?php
		while($object = mysql_fetch_object($results)){
			print '<tr><td>'.geoCountry($object->remote_host).'</td><td><a href="view-host.php?dbs='.$dbs.'&remoteHost='.$object->remote_host.'">'.getShortString($object->remote_host).'</a></td>';
			print '<td>'.myDate($object-> time_stamp).'</td></tr>';
		}
		?>
	</table>
</center>
<?php
	showPageNav($offset, $query,"&uri=$uri");
	require("footer.php");
?>
Return current item: logViewSQL