Postingan lainnya

Insert database to chart

Assalamualaikum, Kalau Boleh tau script saya salah di bagian mana?

Highcharts.chart('container5',
<?php
    include 'koneksi_datin.php';
?>
<?php
    $jumlahdws_datin = mysqli_query("select * from nossa where customer_segment='DWS'");
    echo mysqli_num_rows($jumlahdws_datin);
?>
 {
       chart: {
        backgroundColor: '#373e44'
    },
        title: {
            text: '',
            align: 'center',
            verticalAlign: 'middle',
            y: 40
        },
        tooltip: {
            pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>'
        },
        plotOptions: {
            pie: {
                dataLabels: {
                    enabled: true,
                    distance: -50,
                    style: {
                        fontWeight: 'bold',
                        color: 'white'
                    }
                },
                startAngle: 0,
                endAngle: 360,
                center: ['50%', '50%']
            }
        },
        series: [{
            colors: ['#54d9b6', '#16d1f6', '#f38ade', '#fef372', '#ffb853'],
            type: 'pie',
            name: 'Election',
            size: '80%',
            innerSize: '80%',
            data:
            [
           {<?php echo ($jumlahdws_datin); ?>},
            {name: "", y: 10},
            {name: "", y: 15},
            {name: "", y: 15},
            {name: "", y: 25}

            ]
        }, {
            colors: ['#54d9b6', '#16d1f6', '#f38ade', '#fef372', '#ffb853'],
            type: 'pie',
            name: 'Proprietary or Undetectable',
            innerSize: '90%',
            data:
            [{name: "", y: 10},
            {name: "", y: 15},
            {name: "", y: 20},
            {name: "", y: 15},
            {name: "", y: 25}


            ]
        }]
    });

php database mysql

@Mantofani

60 Kontribusi 3 Poin

Diperbarui 5 tahun yang lalu

Tanggapan

emang errornya apa gan?

@dianarifr

errornya di chart ga muncul datanya gan

@Mantofani

data ini yg ga muncul <?php echo ($jumlahdws_datin); ?>?

@dianarifr

benar banget gan

@Mantofani

solusinya gimana ya gan?

@Mantofani

3 Jawaban:

Jawaban Terpilih

coba ini <pre> //taruh kode dibawah ini setelah echo mysqli_num_rows($jumlahdws_datin); $jmlfix = mysqli_num_rows($jumlahdws_datin); //<?php echo ($jumlahdws_datin); ?> ini ganti dengan <?php echo ($jmlfix); ?> </pre>

@dianarifr

642 Kontribusi 316 Poin

Dipost 5 tahun yang lalu

Tanggapan

masih tetap eror gan

@Mantofani

error atau solved?

@dianarifr

ga ada ngaruh gan tetap sperti awalnya charnya ga muncul, koneksi ke database sy jga udah benar

@Mantofani

kalo hanya munculkan jumlah data sudah benar pake code ane diatas, coba ini benerin juga <pre> $jumlahdws_datin = mysqli_query($konek, "select * from nossa where customer_segment='DWS'"); </pre> variable $konek sesuaikan

@dianarifr

642 Kontribusi 316 Poin

Dipost 5 tahun yang lalu

Tanggapan

tetap ga ada perubahan gan :(

@Mantofani

<pre> Highcharts.chart('container5', <?php include 'koneksi_datin.php'; ?> <?php $jumlahdws_datin = mysqli_query($koneksi_datin, "select * from nossa where customer_segment='DWS'"); echo mysqli_num_rows($jumlahdws_datin); $jmlfix = mysqli_num_rows($jumlahdws_datin); ?> { chart: { backgroundColor: '#373e44' }, title: { text: '', align: 'center', verticalAlign: 'middle', y: 40 }, tooltip: { pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>' }, plotOptions: { pie: { dataLabels: { enabled: true, distance: -50, style: { fontWeight: 'bold', color: 'white' } }, startAngle: 0, endAngle: 360, center: ['50%', '50%'] } }, series: [{ colors: ['#54d9b6', '#16d1f6', '#f38ade', '#fef372', '#ffb853'], type: 'pie', name: 'Election', size: '80%', innerSize: '80%', data: [ {<?php echo ($jmlfix); ?>}, {name: "", y: 10}, {name: "", y: 15}, {name: "", y: 15}, {name: "", y: 25}

        ]
    }, {
        colors: [&#039;#54d9b6&#039;, &#039;#16d1f6&#039;, &#039;#f38ade&#039;, &#039;#fef372&#039;, &#039;#ffb853&#039;],
        type: &#039;pie&#039;,
        name: &#039;Proprietary or Undetectable&#039;,
        innerSize: &#039;90%&#039;,
        data: 
        [{name: &quot;&quot;, y: 10},
        {name: &quot;&quot;, y: 15},
        {name: &quot;&quot;, y: 20},
        {name: &quot;&quot;, y: 15},
        {name: &quot;&quot;, y: 25}
           
            
        ]
    }]
});

</pre>

@Mantofani

60 Kontribusi 3 Poin

Dipost 5 tahun yang lalu