Problem z wykresem Opcje

[UszaTek]

Witam,
próbuje wstawić wykres na swoją stronę lecz mam takie problemy:

Kod

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 13
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 22
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 13
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 22
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 45
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 54
Warning: implode(): Invalid arguments passed in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 70
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 77
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 86
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 110
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/graphy.php on line 119

A o to mój kod:

Kod

<?php

    $conn = mysqli_connect("xxx", "xxxt", "xxxx2$", "xst");xxxx
    
    if($conn === false)
    {
        die("ERROR: Could not connect. " .mysqli_connect_error());
    }

    function hourly($od,$do)
    {
        $query="SELECT * FROM `stat` WHERE `time` >= '{$od}' AND `time` <= '{$do}' ORDER BY `time` ASC";
        $result=mysqli_query($conn, $query);
    
        $g = Array();
        $wg = Array();
        $tg = Array();
        $elem = Array();
        $hours = Array();
        $dzz = 0;
    
        while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC))
        {
            $godzina = date('G',$r['time']);
            $g[$godzina] = $g[$godzina]+$r['Temperature'];
            $wg[$godzina]++;
        }

        foreach($g as $godz=>$Temperature)
        {
            $tg[$godz] = round($Temperature/$wg[$godz],2);
            $dzz++;
            $elem[] = "[{$dzz},{$tg[$godz]}]";
            $hours[] = "'{$godz}:00'";
        }

        $elem = implode(',',$elem);
        $hours = implode(',',$hours);
        return Array('e'=>$elem,'h'=>$hours);
    }

    function daily($od,$do,$mon)
    {
        $query="SELECT * FROM `stat` WHERE `time` >= '{$od}' AND `time` <= '{$do}' ORDER BY `time` ASC";
        $result=mysqli_query($conn, $query);
        
        $g = Array();
        $wg = Array();
        $tg = Array();
        $elem = Array();
        $hours = Array();
        $dzz = 0;

        while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC))
        {
            $dzien = date('d',$r['time']);
            $g[$dzien] = $g[$dzien]+$r['Temperature'];
            $wg[$dzien]++;
        }

        foreach($g as $dz=>$Temperature)
        {
            $tg[$dz] = round($Temperature/$wg[$dz],2);
            $dzz++;
            $elem[] = "[{$dzz},{$tg[$dz]}]";
            $days[] = "'{$dz}.{$mon}'";
        }

        $elem = implode(',',$elem);
        $days = implode(',',$days);
        return Array('e'=>$elem,'d'=>$days);
    }    

    function daily_day($od,$do,$mon)
    {
        $query="SELECT * FROM `stat` WHERE `time` >= '{$od}' AND `time` <= '{$do}' ORDER BY `time` ASC";
        $result=mysqli_query($conn, $query);
        
        $g = Array();
        $wg = Array();
        $tg = Array();
        $elem = Array();
        $days = Array();
        $dzz = 0;
    
        while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC))
        {
            $dzien = date('d',$r['time']);
            if(date('G',$r['time']) >= 23 OR date('G',$r['time']) < 6) { continue; }
            $g[$dzien] = $g[$dzien]+$r['Temperature'];
            $wg[$dzien]++;
        }

        foreach($g as $dz=>$Temperature)
        {
            $tg[$dz] = round($Temperature/$wg[$dz],2);
            $dzz++;
            $elem[] = "[{$dzz},{$tg[$dz]}]";
            $days[] = "'{$dz}.{$mon}'";
        }

        $elem = implode(',',$elem);
        $days = implode(',',$days);
        return Array('e'=>$elem,'d'=>$days);
    }

    function daily_night($od,$do,$mon)
    {
        $query="SELECT * FROM `stat` WHERE `time` >= '{$od}' AND `time` <= '{$do}' ORDER BY `time` ASC";
        $result=mysqli_query($conn, $query);
        
        $g = Array();
        $wg = Array();
        $tg = Array();
        $elem = Array();
        $days = Array();
        $dzz = 0;
    
        while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC))
        {
            $dzien = date('d',$r['time']);
            if(date('G',$r['time']) < 23 AND date('G',$r['time']) >= 6) { continue; }
            $g[$dzien] = $g[$dzien]+$r['Temperature'];
            $wg[$dzien]++;
        }
    
        foreach($g as $dz=>$Temperature)
        {
            $tg[$dz] = round($Temperature/$wg[$dz],2);
            $dzz++;;
            $elem[] = "[{$dzz},{$tg[$dz]}]";
            $days[] = "'{$dz}.{$mon}'";
        }

        $elem = implode(',',$elem);
        $days = implode(',',$days);
        return Array('e'=>$elem,'d'=>$days);
    }

    $hd = hourly(strtotime(date('d.m.Y').' 00:00'),strtotime(date('d.m.Y').' 23:59'));
    $hdy = hourly(strtotime('-1 day 00:00'),strtotime('-1 day 23:59'));
    $lm_o = daily(strtotime('01.'.date('m.Y').' 00:00'),strtotime(date('d.m.Y G:i')),date('m'));
    $lm_d = daily_day(strtotime('01.'.date('m.Y').' 00:00'),strtotime(date('d.m.Y G:i')),date('m'));
    $lm_n = daily_night(strtotime('01.'.date('m.Y').' 00:00'),strtotime(date('d.m.Y G:i')),date('m'));

?>

Ten post edytował UszaTek 17.01.2022, 20:08:17