3 COURBES GRAPHIQUE SUR 3 MOIS

Commentaire de winsave le 08/07/2004 17:06:46

P'tit bug détecté ; le champ 'JOUR' est codé "en dur" au lieu d'utiliser $champ.

Voici le script corrigé :
-------------------------------------------------------------------------------
<?
//Connection/////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////
if (!isset($connect))
$connect = @mysql_connect($adresse,$user,$pwd);
if($connect)
{
    $select_db=@mysql_select_db($base);
    if($select_db)
    {
        //Récupération des infos/////////////////////////////////////////////
        /////////////////////////////////////////////////////////////////////
        $date_deb     = date("Y-m-d",mktime(0, 0, 0, date("m")-2 ,date("d") ,date("Y")));
        $date_fin     = date("Y-m-d",mktime(0, 0, 0, date("m")   ,date("d") ,date("Y")));

        $date_mois    = array(date("Y-m-",mktime(0, 0, 0, date("m")   ,1 ,date("Y"))),
                              date("Y-m-",mktime(0, 0, 0, date("m")-1 ,1 ,date("Y"))),
                              date("Y-m-",mktime(0, 0, 0, date("m")-2 ,1 ,date("Y"))));

        $mois         = array(date("d/m",mktime(0, 0, 0, date("m")   ,1 ,date("Y"))), //date 1er de m-0
                              date("d/m",mktime(0, 0, 0, date("m")-1 ,1 ,date("Y"))));//date 1er de m-1

        $total_nbjours = 0;
        $donnees = array();

        //Valeur maximale de la période/////////////////////////////////////
        $sql="SELECT max($champ) max
              FROM `$table`
              WHERE $champ BETWEEN '$date_deb' AND '$date_fin'";
        
        $req=mysql_query($sql);
        $requete = mysql_fetch_array($req);
        $max = (int)$requete["max"];
        if ((strtolower($champ))=="pourc") $max = 100;
        if ((strtolower($champ))=="pourc2") $max = 100;
        //Récupération des valeurs de la période////////////////////////////
        $sql = "SELECT $champ graph
                FROM `$table`
                WHERE $champ BETWEEN '$date_deb' AND '$date_fin'
                ORDER BY 1";
        
        $req = mysql_query($sql);
        $i=0;
        while ($requete = mysql_fetch_array($req))
        {
            $donnees[$i] = (int)$requete["graph"];
            $i++;
        }

        //Nb Jour Mois x //////////////////////////////////////////////////
        for ($i=0; $i<=2; $i++)
        {
            $sql="SELECT Count($champ) nbjours
                 FROM `$table`
                 WHERE $champ LIKE '$date_mois[$i]%'";
            $req=mysql_query($sql);
            $requete = mysql_fetch_array($req);
            $nbjours[$i] = $requete["nbjours"];
            //Nb Jour durant les 3 Mois///////////////////////////////////
            $total_nbjours+= $nbjours[$i];
        }
        //Recupération du min jour////////////////////////////////////////
        $sql="SELECT min($champ) jour
             FROM `$table`
             WHERE $champ LIKE '$date_mois[2]%'";

        $req=mysql_query($sql);
        $requete = mysql_fetch_array($req);
        if ($requete["jour"]==null)
        {
            $sql="SELECT min($champ) jour
                 FROM `$table`
                 WHERE $champ LIKE '$date_mois[1]%'";
            $req=mysql_query($sql);
            $requete = mysql_fetch_array($req);
            $premierjours = convdate($requete["jour"]);
        }
        else
        {
            $premierjours = convdate($requete["jour"]);
        }
        
        //Recupération du max jour////////////////////////////////////////
        $sql="SELECT max($champ) jour
             FROM `$table`
             WHERE $champ LIKE '$date_mois[0]%'";            
        $req=mysql_query($sql);
        $requete = mysql_fetch_array($req);
        if ($requete["jour"]==null)
        {
            $sql="SELECT max($champ) jour
                 FROM `$table`
                 WHERE $champ LIKE '$date_mois[1]%'";
            $req=mysql_query($sql);
            $requete = mysql_fetch_array($req);
            echo $requete["jour"];
            $dernierjours = convdate($requete["jour"]);
        }
        else
        {
            $dernierjours = convdate($requete["jour"]);
        }
//FIN//////////////////////////////////////////////////////////////////////
    }
    else
    {
       $msg = "Impossible de trouver la table dans la base de données (code = 1)";
    }
}
else
{
    $msg = "Impossible de se connecter à la base de données (code = 2)";
}

echo $msg;

//Convertion de date mysql en date php///////////////////////////////
/////////////////////////////////////////////////////////////////////
function convdate($date1)
{
    $d1 = explode("-", $date1);
    $y = $d1[0];
    $m = $d1[1];
    $d = $d1[2];
    $date2 = date("d/m",mktime(0,0,0, $m, $d, $y));
    return $date2;
}

Commentaire de bachirms le 14/03/2006 13:48:46

Tout simplement Bravo, très simple code et facilement paramétrable.

Commentaire de nounours21_6 le 02/04/2007 15:38:51

Bonjour,
moi aussi j'ai les erreurs que yurispy!
est-ce que vous avez trouvé une solution??!
sinon, merci pour cette source...
Enjoy @+

Commentaire de oapayet le 28/11/2007 12:17:08

Notice: Undefined offset: 1 in c:\program files\easyphp1-8\www\graph\reporting-recup-info.php on line 123

Notice: Undefined offset: 2 in c:\program files\easyphp1-8\www\graph\reporting-recup-info.php on line 124

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in c:\program files\easyphp1-8\www\graph\reporting-recup-info.php on line 125

Notice: Undefined offset: 1 in c:\program files\easyphp1-8\www\graph\reporting-recup-info.php on line 123

Notice: Undefined offset: 2 in c:\program files\easyphp1-8\www\graph\reporting-recup-info.php on line 124

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in c:\program files\easyphp1-8\www\graph\reporting-recup-info.php on line 125
0
Warning: Division by zero in c:\program files\easyphp1-8\www\graph\graph.php on line 98