Getting Data from PHP, JSON Highcharts?

Question

Hi I am trying to get data from MySql table and show the data in Highcharts by using PHP and Json I have try the example from internet and it is working fine but when I try to get data from my file it show nothing.

What I am trying to do: I am creating table of office attendance system and trying to show record day by day. So at y axis I want to count names of employees and x axis the date of attendance.

Problem: Nothing Is show from mu json.

Here is what my Json looks like:

[["Hamza","07\/04\/2014"],
["Junaid","07\/04\/2014"],
["Usman","07\/04\/2014"],
["Rajab","07\/04\/2014"],
["Hamza","08\/04\/2014"],
["Junaid","08\/04\/2014"],
["Usman","08\/04\/2014"],
["Rajab","08\/04\/2014"]]

I am having to value names and dates.

My PHP which is creating my Json code:

// Set the JSON header
header("Content-type: text/json");

$result = mysqli_query($con,"SELECT * FROM attendence");
$a=array();
while($row = mysqli_fetch_array($result)) {
 $row['name'] . "\t" . $row['date']. "\n";
 $b=array();
 array_push($b,$row['name']);
 array_push($b,$row['date']);
array_push($a,$b);
}
echo json_encode($a);

and this is my Jquery code:

$(function() {

    $.getJSON('highchart.php', function(data) {
        // Create the chart     
        $('#chart').highcharts('StockChart', {


            rangeSelector : {
                selected : 1,
                inputEnabled: $('#chart').width() > 480
            },

            title : {
                text : 'Attendence'
            },

            series : [{
                name : 'Empolyees',
                data : data,
                tooltip: {
                    valueDecimals: 2
                }
            }]
        });
    });

});

Your data doesn't make any sense. You have a name and a date, but no numeric y-value. Are you trying to show the count of those there on a particular day? Or how many days an individual was there in some time period? — Mark
– Mark, Commented May 16, 2014 at 12:59
this is a attendance table and everyday many employees have to add there time in and time out so in a single day there are many entries of a single day in my json code I only show one day attendance but there are many days in my table with same day. — xitas
– xitas, Commented May 16, 2014 at 13:42
you didn't answer my question. What value do you want your y axis to show? — Mark
– Mark, Commented May 16, 2014 at 14:43
sorry for late answer I want to count name and show it at y axis.! — xitas
– xitas, Commented May 17, 2014 at 9:32

Sebastian Bochan · Accepted Answer · 2014-05-16 13:49:08Z

1

In the json_encode() you need to use JSON_NUMERIC_CHECK flag to avoid use string in your JSON
In the highstock you need to have timestamps and value, not name and date.
Dates should be timestamp, and as first element in array, not second as you have.

edited May 16, 2014 at 13:49

answered May 16, 2014 at 12:53

Sebastian Bochan

37.6k3 gold badges51 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark · Accepted Answer · 2014-05-17 13:05:36Z

1

If you want to get a count of all people on a given day, you need to write a SQL query that returns that information. Assuming that date field is a datetime type and name is of varchar type:

SELECT COUNT(name) FROM attendence GROUP BY DATE(date);

answered May 17, 2014 at 13:05

Mark

109k20 gold badges180 silver badges238 bronze badges

Comments

andrew · Accepted Answer · 2014-05-16 06:28:54Z

0

perhaps you need to define what kind of data your x-axis will have
take a look at this fiddle (taken from highcharts website)

$(function () {
    $('#container').highcharts({
        xAxis: {
            type: 'datetime'
        },

        series: [{
            data: [
                [Date.UTC(2010, 0, 1), 29.9], 
                [Date.UTC(2010, 2, 1), 71.5], 
                [Date.UTC(2010, 3, 1), 106.4]
            ]
        }]
    });
});

answered May 16, 2014 at 6:28

andrew

2,1182 gold badges27 silver badges33 bronze badges

2 Comments

xitas Over a year ago

but i want to keep dates dynamic? any idea for that?

andrew Over a year ago

@Hamza i don't think this is a prolem. Just look how x-axis is defined as datetime. Also, in this example the data are [date,string]. I have no familiarity with highcharts, but i thought the above example did exactly what you wanted

Collectives™ on Stack Overflow

Getting Data from PHP, JSON Highcharts?

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related