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

[nospor]

No przeciez komunikat bledu mowi wszystko. Znowu

Kod js, ktory odnosi sie do elementu HTML nie moze byc wykonany wczesniej niz ten element HTML sie pojawi. Wiec przenies swoj kod JS za kodem HTML a nie przed . Oczywiscie mozna to zrobic inaczej ale na twoj stan wiedzy to bedzie najprostrze rozwiazanie. A na prszylosc czytaj te komunikaty i jak nie ogarniasz to uzyj google bo nie ty jeden masz takie problemy i odpowiedz byla podana juz milion razy