How to parse this multi-dimensional array properly

Question

I have tried everything I know and I have failed totally to parse this multi dimensional array so that I can get the "symbol" keys and corresponding values of "contractType" , but I can't seem to get it.

The array is generated here: https://fapi.binance.com/fapi/v1/exchangeInfo So I am doing the following:

    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl, CURLOPT_HEADER, false);
    $data = curl_exec($curl);
    curl_close($curl);

    $results = [];
    foreach ($data['symbols'] as $info) {
        $results[] = $info['symbol'];        
    }
    print_r($results);

I tried a foreach loop, for loop, tried various offsets eg. $data[0]['symbols'].. to $data[9]['symbols'] etc. but can't seem to get the correct array offset.

10000"}],"symbols":[{"symbol":"BTCUSDT","pair":"BTCUSDT","contractType":"PERPETUAL","deliveryDate

I'm trying to loop through the "symbols" offset within this main array, and get 1. the "symbol" 2. its corresponding "contractType"

Ty..

It's hard to answer this when you've only posted a partial of the array structure. Without knowing the full structure, we can only make unfounded guesses. — M. Eriksson
– M. Eriksson, Commented Jan 31, 2022 at 15:33
try to decode the json response you get from the CURL, $data = json_decode($data);. and now $data is an object that you can have accesses like $data->symbols — Alireza Farokhi
– Alireza Farokhi, Commented Jan 31, 2022 at 15:43

naamhierzo · Accepted Answer · 2022-01-31 15:41:27Z

1

It doesn't work because the CURL result is in JSON.

You got to convert it to an array before you can loop through it.

$data = json_decode($data, true);

answered Jan 31, 2022 at 15:41

naamhierzo

5403 silver badges12 bronze badges

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

2 Comments

metokitt Over a year ago

Warning: json_decode() expects parameter 1 to be string, array given ...

naamhierzo Over a year ago

@metokitt the $data in your original question is a string, this works with that code.

Simon K · Accepted Answer · 2022-01-31 16:01:16Z

1

It looks like you need to convert the JSON response into an array before you loop over it.

    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl, CURLOPT_HEADER, false);
    $data = curl_exec($curl);
    curl_close($curl);

    $results = [];
    $data = json_decode($data);
    $i = 0;
    foreach ($data->symbols as $info) {
        $results[$i]['symbol'] = $info->symbol;
        $results[$i]['contractType'] = $info->contractType;
        $i++;    
    }
    print_r($results);

edited Jan 31, 2022 at 16:01

answered Jan 31, 2022 at 15:42

Simon K

1,5231 gold badge9 silver badges10 bronze badges

2 Comments

metokitt Over a year ago

Warning: Invalid argument supplied for foreach() in /data/www/.....

Simon K Over a year ago

My bad, I posted the concept without testing. I have updated the answer for you now.

metokitt · Accepted Answer · 2022-01-31 16:13:07Z

0

Yes. Thankyou.. (didn't understand answer properly.)

    $url = 'https://fapi.binance.com/fapi/v1/exchangeInfo';
    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl, CURLOPT_HEADER, false);
    $data = curl_exec($curl);
    curl_close($curl);

    $data = json_decode($data, true);

    $results = [];
    $symbols = $data['symbols'];
    $i = 0;
    foreach ($symbols as $info) {
        $results[$i]['symbol'] = $info['symbol'];
        $results[$i]['contractType'] = $info['contractType'];
        $i++;    
    }
    print_r($results);

Much appreciated, ty..

answered Jan 31, 2022 at 16:13

metokitt

537 bronze badges

Collectives™ on Stack Overflow

How to parse this multi-dimensional array properly

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related