在PHP中提交日期范围后刷新高图表

Question

am working in PHP. i am using High Chart , dynamically taking data from DB. Now i want to show data between certain date range. Data between certain date range is successfully fetched from DB but now how to refresh the Chart ??

JS Code :

` function piechart() {

        var date_from   = $("#date_from").val();
        var date_to     = $("#date_to").val();
        var dataString = 'date_from=' + date_from + '&date_to=' + date_to;

        $.ajax({
            type: "GET",
            url: "pages/dashboard/chart_data.php",
            data: dataString,
            cache: false,
            success: function(html) {

        }
        });

        return false;
        }
    $(document).ready(function() {
        var options = {
            chart: {
                renderTo: 'container',
                plotBackgroundColor: null,
                plotBorderWidth: null,
                plotShadow: false
            },
            title: {
                text: 'Current Year Sales Report'
            },
            tooltip: {
                formatter: function() {
                    return '<b>'+ this.point.name +'</b>: '+ this.percentage +' %';
                }
            },
            plotOptions: {
                pie: {
                    allowPointSelect: true,
                    cursor: 'pointer',
                    dataLabels: {
                        enabled: true,
                        color: '#000000',
                        connectorColor: '#000000',
                        formatter: function() {
                            return '<b>'+ this.point.name +'</b>: '+ this.percentage +' %';
                        }
                    }
                }
            },
            series: [{
                type: 'pie',
                name: 'Sales (Rupees)',
                data: []
            }]
        }

        $.getJSON("chart_data.php", function(json) {
            options.series[0].data = json;
            chart = new Highcharts.Chart(options);
        });



    });  

`

and chart_data.php

`

if($date_from !='' AND $date_to !='')
{
    $where = "tran_date >='$date_from' AND tran_date <= '$date_to'";
    echo $db->piechart($where);
}
else
echo $db->piechart();

?> `

Any help will be highly appreciated.

Answer 1

It looks like it is JavaScript question. You should move your code inside

`$(document).ready(function() {`

block into the function and execute it each time your date range fields are changed or then document is loaded first time.