php cannot use API data

Question

I send a request and get back JSON, so I convert that JSON to an array, but I cannot use the array with my php:

$all_transactions_raw = file_get_contents("xxx");

$all_transactions = json_decode( $all_transactions_raw );

 foreach ( $all_transaction as $transaction ) {
    echo $transaction;
  }

First part of the very long output:

Array ( 
    [data] => Array ( 
        [transactions] => Array ( 
            [0] => Array ( 
                [id] => t1rtn-gsjkadfv 
                [date] => 2017-11-01 
                [amount] => -8847
                [memo] => 
                [cleared] => reconciled 
                [approved] => 1 
                [flag_color] =>

why does the above code not print a list of transactions given by the api request?

when I use print_r( $all_transactions ); I can print out a long string of what looks like an array but I cannot access the data contained in it as separate chunks. Am I missing something?

show us your expected json result that you want to work with. — ttrasn
– ttrasn, Commented Dec 30, 2019 at 16:14
$transaction is also probably an array, so try print_r($transaction); in the loop as echo will probably fail. — Nigel Ren
– Nigel Ren, Commented Dec 30, 2019 at 16:14
You should also add true as the second argument to json_decode() to assure that you get the result as associative arrays instead of object. However, since we have no idea what the result looks like, I can't know if that's the issue or not. Please share the value of $all_transactions_raw. — M. Eriksson
– M. Eriksson, Commented Dec 30, 2019 at 16:18
@ttrasn I want to work with the result as an array so that I can say $all_transactions[1] and do something with that. — brothman01
– brothman01, Commented Dec 30, 2019 at 16:25
Something's strange here. If you're using json_decode() without true as a second argument like in your code, I don't see how the result could be associative arrays instead of objects? What exactly is that array a dump of? The raw value or inside the loop? — M. Eriksson
– M. Eriksson, Commented Dec 30, 2019 at 16:29

Abdul Moiz · Accepted Answer · 2019-12-30 16:27:22Z

1

i guess you are missing these keys in foreach

$all_transactions_raw = file_get_contents("xxx");

$all_transactions = json_decode( $all_transactions_raw );

 foreach ( $all_transaction['data']['transactions'] as $transaction ) {
    echo $transaction;
  }

answered Dec 30, 2019 at 16:27

Abdul Moiz

5002 silver badges12 bronze badges

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

6 Comments

brothman01 Over a year ago

yes! that did it, I can work with single transactions now using that, thanks

M. Eriksson Over a year ago

I'm sorry, but I'm failing to see how this would work at all? How can $all_transactions possibly be an associative array with the above code?

brothman01 Over a year ago

@MagnusEriksson idk but I am able to do ` print_r( $all_transactions['data']['transactions'][0] ); ` which prints out an array of all data associated with the 0th transaction in the output

Abdul Moiz Over a year ago

if you have online one array then you can do like $all_transactions['data']['transactions'][0] otherwise you should need loop

M. Eriksson Over a year ago

@fall3n - Yes, but as you said in your comment, you are actually using true as the second argument. This answer doesn't so it's actually wrong and could cause confusion for future visitors seeing it and trying it.

|

Collectives™ on Stack Overflow

php cannot use API data

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related