How to convert a recursive array into a string using PHP?

Question

I have an array with nested arrays inside that I need to convert into a string with a given format.

This is for a PHP website. I get the information from a database, it comes as an array, and I need to pass it to charts.js so that I can plot it.

This is the varDump I get when I query the DB:

array(4) { [0]=> array(2) { ["date"]=> string(19) "2019-05-19 00:00:00" ["price"]=> string(3) "120" } [1]=> array(2) { ["date"]=> string(19) "2019-05-12 00:00:00" ["price"]=> string(3) "100" } [2]=> array(2) { ["date"]=> string(19) "2019-05-05 00:00:00" ["price"]=> string(3) "120" } [3]=> array(2) { ["date"]=> string(19) "2019-04-28 00:00:00" ["price"]=> string(3) "110" } }

This is what I would need as a result in a text string:

data: [{
    x: 2019-05-19 00:00:00,
    y: 120
}, {
    t: 2019-05-12 00:00:00,
    y: 100
}, {
    t: 2019-05-05 00:00:00,
    y: 120
}, {
    t: 2019-04-28 00:00:00,
    y: 110
}]

Rahul · Accepted Answer · 2019-05-29 05:44:59Z

2

You can use array_map as below,

$temp = array_map(function ($item) {return array_combine(["x", "y"], $item); }, $temp);

I created ['x','y'] to combine as key as replacement for $item's keys.

array_combine — Creates an array by using one array for keys and another for its values

Working demo.

edited May 29, 2019 at 5:44

answered May 28, 2019 at 11:40

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

1 Comment

Rahul Over a year ago

Check now. I give explanation.

Ozan Kurt · Accepted Answer · 2019-05-28 11:36:01Z

1

Just loop through the array and make a new one, and then json_encode it.

$data = [];
foreach ($rows as $row) {
    $data['x'] = $row['date'];
    $data['y'] = $row['price'];
}

json_encode($data);

answered May 28, 2019 at 11:36

Ozan Kurt

3,8634 gold badges22 silver badges36 bronze badges

Collectives™ on Stack Overflow

How to convert a recursive array into a string using PHP?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related