convert string into array for highcharts js

Question

My code PHP generate a string variable

<?php
foreach($rows as $row){

    $result .= "['" .$row["Name"]."'," .$row['Value']. "] , ";
}

$result = rtrim($result, ' , ');

//echo $result returns: ['FirstName1 LastName1',10] , ['FirstName2 LastName2',12] , ['FirstName3 LastName3 ',40]

?>

In js how can I convert the 'name' variable into a functional variable for 'data:' ?

<script>
var name = "<?php echo $result; ?>";

Highcharts.chart('container', {
...

data: [
    ['Shanghai', 23.7],
    ['Lagos', 16.1],
    ['Istanbul', 14.2]
  ];

...
});
</script>

Thank you!

Related: stackoverflow.com/q/9858448/266535

styfle
– styfle

2017-10-09 20:50:18 +00:00
Commented Oct 9, 2017 at 20:50 — styfle
– styfle, Commented Oct 9, 2017 at 20:50

Community · Accepted Answer · 2023-11-14 22:27:54Z

2

You need to wrap $result in an array:

$result = "[$result]";

But you really should use json_encode like this:

$resultArr = [];
foreach ($rows as $row) {
    $resultArr[] = [$row['Name'], $row['Value']];
}
$result = json_encode($resultArr);

edited Nov 14, 2023 at 22:27

CommunityBot

11 silver badge

answered Oct 9, 2017 at 20:55

Ethan

4,4054 gold badges27 silver badges49 bronze badges

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

1 Comment

Hexman Over a year ago

Does not work because $row['Value'] is string, I need number: 9 not "9". Thank you!

Collectives™ on Stack Overflow

convert string into array for highcharts js

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related