douhuibo5635 2017-04-03 21:53
浏览 113
已采纳

如何在highcharts中显示所有数据? [关闭]

I have input all of my data in controller and view. I took data from database anyway. When I try to run my code, not all of the data appeared in chart display. For example, I want to display 11 data in xAxis. But, only 10 data that can be displayed in xAxis.

I have table like this:

enter image description here

I have controller like this: https://pastebin.com/M2QFF73V

I have view like this: https://pastebin.com/cZ2B4hXM

my codes result:

enter image description here

there is year 2015 in table but why 2015 didn't display in chart? why the chart just displayed 10 data?

How to display all of data?

Thanks in advance

  • 写回答

1条回答 默认 最新

  • dongyan8929 2017-04-03 21:56
    关注

    Your query has limit set to 10

     durasistudi = (new \yii\db\Query())
            ->select(['TahunMasuk'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
    
        $durasistudi1 = (new \yii\db\Query())
            ->select(['lessthan2'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
    
        $durasistudi2 = (new \yii\db\Query())
            ->select(['btween2,0to2,4'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
        $durasistudi3 = (new \yii\db\Query())
            ->select(['btween2,5to2,9'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
        $durasistudi4 = (new \yii\db\Query())
            ->select(['btween3,0to3,4'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
        $durasistudi5 = (new \yii\db\Query())
            ->select(['btween3,5to3,9'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
        $durasistudi6 = (new \yii\db\Query())
            ->select(['morethaneqs4,0'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
        $durasistudi7 = (new \yii\db\Query())
            ->select(['TidakDiketahui'])
            ->from('temp_jmlhdurasisstudimagister')
            ->limit(10)
            ->column();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?