import values from PHP with JS for chart column

Question

I have this code in javascript for chart column:

$(function () {
  $('#grafic_column').highcharts({
    chart: {
            type: 'column'
        },
    series: [{
      name: 'Population',
      data: [
        ['Shanghai', 23.7],
        ['Lagos', 16.1],
        ['Istanbul', 14.2]
      ]
    }]
  });
});

And this cod in php:

<?php
$ar = array(
  ['Shanghai', 23.7],
  ['Lagos', 16.1],
  ['Istanbul', 14.2]
);
echo json_encode($ar);
?>

How do import the values results from php in series.data:? Thank you!

@Sherif, I tried so: data: [ <?php include'myfile.php'; echo json_encode($ar); ?> ], and not work. — ster
– ster, Commented Aug 31, 2016 at 23:49
does myfiles.php contain your data? if so include it in the top of your script and assing the data content to $ar and just do data: [ <?php echo json_encode($ar); ?> ] — Sherif
– Sherif, Commented Aug 31, 2016 at 23:51

Rob M. · Accepted Answer · 2016-08-31 23:09:15Z

2

Assuming your PHP file is accessible with a server, you can just perform $.get to make an AJAX request to the file serving the data:

$(function () {
    $.get('/yourphpfile.php').then(function(data) {
        $('#grafic_column').highcharts({
            chart: {
                type: 'column'
            },
            series: [{
                name: 'Population',
                data: data
            }]
        });
    })
});

answered Aug 31, 2016 at 23:09

Rob M.

36.6k6 gold badges56 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

import values from PHP with JS for chart column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related