Tahun baru, skill baru! 🚀. Masukkan kupon "skill2025" untuk diskon 30% di kelas apa saja

Menampilkan multi data dengan Chart JS

siang kawan2, saya mau tanya untuk penggunaan Chart JS untuk menampilkan multi data dalam database. saya sudah buat scriptnya, cuma yang muncul hanya di field nya saja. need advice please.

 <?php
include "connection.php";

$time=mysql_query("SELECT b.time FROM jem1 a INNER JOIN perhour b ON a.Time_ = b.id where date_ between DATE_ADD(date(now()), INTERVAL -7 DAY) and date(now())");
$data=mysql_query("SELECT a.*, b.time FROM jem1 a INNER JOIN perhour b ON a.Time_ = b.id where date_ between DATE_ADD(date(now()), INTERVAL -7 DAY) and date(now())");

//$time1 = array();
//$mwhdel = array();$mwhrec = array();$mvardel = array();
//while($d=mysql_fetch_array($data)) {
	//$time[] = $b['time'];
	//$mwhdel[] = $d['MWHDel']; $mwhrec[] = $d['MWHRec']; $mvardel[] = $d['MVARDel'];
//}
?>

<script type="text/javascript">
	var ctx = document.getElementById( "jem1Chart" );
	ctx.height = 100;
	var myChart = new Chart( ctx, {

    type: 'line',
    data: {
        labels: [<?php while ($t = mysql_fetch_array($time)) { echo '"' . $t['time'] . '",'; } ?>],
        datasets: [
            {
                label: "MWH Del",
                borderColor: "rgba(0,0,0,.09)",
                borderWidth: "1",
                data: [<?php while ($d = mysql_fetch_array($data)) { echo '"' . $d['MWHDel'] . '",'; } ?>],
                backgroundColor: "rgba(0,0,0,.07)",
                        },
            {
                label: "MWH Rec",
                borderColor: "rgba(0,0,0,.09)",
                borderWidth: "1",
                data: [<?php while ($d = mysql_fetch_array($data)) { echo '"' . $d['MWHRec'] . '",'; } ?>],
                backgroundColor: "rgba(0,0,0,.07)",
                        },
            {
                label: "MVAR Del",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MVAR Rec",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "PF Del",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MW",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MVAR",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "F",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "KV",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MWH",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "KV (Electrical Package)",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MW (Electrical Package)",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MVAR (Electrical Package)",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "PF",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "FREQ",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MWH Counter",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "MVAR Counter",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "PTLH",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "BSLH",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "PKLH",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "BPSH",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "ATS",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "SS",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "NS",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "FS",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "TRIP",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "Peak Time",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        },
            {
                label: "Peak Numst",
                borderColor: "rgba(0, 123, 255, 0.9)",
                borderWidth: "1",
                backgroundColor: "rgba(0, 123, 255, 0.5)",
                data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
                pointHighlightStroke: "rgba(26,179,148,1)",
                        }
        				]
        },
        options: {
            responsive: true,
            tooltips: {
                mode: 'index',
                intersect: false
            },
            hover: {
                mode: 'nearest',
                intersect: true
            }

        }
    } );
</script>

avatar faalyn
@faalyn

1 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

Belum ada Jawaban. Jadi yang pertama Jawaban

Login untuk ikut Jawaban