Pharsing Log Files

podman99

Hello for a first post I thourght I would make it easy for you..

I have a directory in my /var/www/html for my squid proxy server log files... all named name-dd-mm-yy-HH-MM.log....

I wish to first view all log files in decending order in a web interface made in PHP as well as be able to click on and have the files modified in to tables.. I know this is possiable as CGI can do it...

But... I cant do it in CGI or PHP so .... php is the quicker and easier ISH way of viewing and maintaining it??... what code do i use to set up the ability to list the DIR and files contained in it... and what code do i use to seperate a Spaced log file in to a table?

Thanks in advance..

Weedpacket

opendir() will provide a handle to a directory listing which can be traversed with readdir() (read them into an array and sort the array seems like a good way to go).

As for parsing out the files themselves it depends on the exact format and how much parsing you want to do (preg_match() will probably be your friend) - but to take a string and break it on spaces into an array, you'd use explode(). After that it's just a matter of walking through this array writing out its contents interspersed with judicious <td>, <tr> etc. tags.

zmola

list dir contents:

<html>
<body>
<table>
<?
$path = "/full/path/to/dir/";
$dir=opendir($path);
  while ($file = readdir ($dir)) {
    if ($file != "." && $file != ".." && eregi(".log",$file)) {
    echo "<tr><td><a href=\"$file\">View $file</a></td></tr>";
    }
  }
closedir($dir);
?>
</table>
</body>
</html>

parse log file into table:

<?
$logola = "/full/path/to/file.log";
$referersola = array();
$ipsola = array();
$fd = fopen("$logola","r"); 
while ($lineola = fgets($fd,1024)) { 
// and this depends on your log file format and what you want to see
list( $ipola , , , , , , , , , , $refererola , ) = explode(" ", $lineola);
array_push($referersola, $refererola);
array_push($ipsola, $ipola);
}
$count_end = count($ipsola);
$count_start = max(0,$count_end - 5000); // or whatever

echo "<html><body><div align=center><table border=1>";
echo "<tr><td colspan=2 align=center><font face=verdana><b>Count Start at Line:</b> $count_start <b>Count End at Line:</b> $count_end</font></td></tr>";
for ($i=$count_start;$i<$count_end;$i++){
// and then exclude whatever
  if ((!eregi("^111.",$ipsola[$i])) && (!eregi("^222.",$ipsola[$i])) && (!eregi("^333.",$ipsola[$i]))) {
    echo "<tr><td><font face=verdana><b>IP:</b> " . $ipsola[$i] . "</font></td><td><font face=verdana><b>Referer:</b> " . $referersola[$i] . "</font></td></tr>";
  }
}
echo "</table></div></body></html>";
fclose($fd); 
?>

just do a little editing to get the 1st to call the 2nd.

podman99

For somereason the thing misses out the last dir in the line the archive/ is missed offf?? Any ideas why?

podman99

how do i view the dir in decending order?