Bonjour je me demande comment je pourrais optimiser ce code très repetitif.
Je pensais mettre les valeurs debug, info, warn, error, fatal dans un table
et ensuite faire des boucles.

Mais je vois aps trop comment je pourrais faire ca ?

Si quelqu'un pouvait me filer un coup de main, ca serait bien sympatique.

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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";
}
?>