1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| <?php
if(isset($_GET['date'])&&isset($_GET['date2']))
{
$date = $_GET['date'];
$date2 = $_GET['date2'];
include("connect_db.php");
if($date == $date2)
{
$sql_debug = mysql_query("select count(*) from log4j where time='$date' AND warning='error';")or die(mysql_error());
$sql_info = mysql_query("select count(*) from log4j where time='$date' AND warning='info'; ")or die(mysql_error());
$sql_warn = mysql_query("select count(*) from log4j where time='$date' AND warning='warn'; ")or die(mysql_error());
$sql_error = mysql_query("select count(*) from log4j where time='$date' AND warning='fatal';")or die(mysql_error());
$sql_fatal = mysql_query("select count(*) from log4j where time='$date' AND warning='error';")or die(mysql_error());
}
else
{
$sql_debug = mysql_query("select count(*) from log4j where (time BETWEEN'.$date' AND '$date2') AND warning='error';")or die(mysql_error());
$sql_info = mysql_query("select count(*) from log4j where (time BETWEEN'.$date' AND '$date2') AND warning='info' ;")or die(mysql_error());
$sql_warn = mysql_query("select count(*) from log4j where (time BETWEEN'.$date' AND '$date2') AND warning='warn' ;")or die(mysql_error());
$sql_error = mysql_query("select count(*) from log4j where (time BETWEEN'.$date' AND '$date2') AND warning='error';")or die(mysql_error());
$sql_fatal = mysql_query("select count(*) from log4j where (time BETWEEN'.$date' AND '$date2') AND warning='fatal';")or die(mysql_error());
}
$debug = mysql_fetch_array($sql_debug);
$info = mysql_fetch_array($sql_info) ;
$warn = mysql_fetch_array($sql_warn) ;
$error = mysql_fetch_array($sql_error);
$fatal = mysql_fetch_array($sql_fatal);
echo"<table><tr><td><b>Type</b></td><td><b>Number</b></td></tr>";
echo"<tr><td>debug</td><td>".$debug."</td></tr>";
echo"<tr><td>info </td><td>".$info."</td></tr>";
echo"<tr><td>warn </td><td>".$warn."</td></tr>";
echo"<tr><td>error</td><td>".$error."</td></tr>";
echo"<tr><td>fatal</td><td>".$fatal."</td></tr>";
echo"</table>";
}
else{
echo "Please enter select start date, end date and environment";
}
?> |
Partager