[PHP]JSON foreach Opcje

[rybosom]

mam następujący JSON response

{"transactionId":0,"authorizationId":13,"accountNumber":"*ciach*","creditCardNumber":"*ciach*","icon":2,"iconDescription":"Nierozliczone","date":"2014-09-17T00:00:00.000","desc":"Pizzeria","subCategName":"Wyjścia i wydarzenia","amount":-37.80,"currency":"PLN"},{"transactionId":6901,"authorizationId":0,"accountNumber":"*ciach*","creditCardNumber":"","icon":0,"iconDescription":"Przelew","date":"2014-09-17T00:00:00.000","desc":"PRZELEW REGULARNE OSZCZĘDZANIE","subCategName":"Regularne oszczędzanie","amount":-9.63,"currency":"PLN"},{"transactionId":6900,"authorizationId":0,"accountNumber":"*ciach*","creditCardNumber":"","icon":0,"iconDescription":"Przelew","date":"2014-09-17T00:00:00.000","desc":"*ciach*","subCategName":"Prąd","amount":-60.37,"currency":"PLN"},{"transactionId":6899,"authorizationId":0,"accountNumber":"*ciach*","creditCardNumber":"","icon":0,"iconDescription":"Przelew","date":"2014-09-16T00:00:00.000","desc":"PRZELEW REGULARNE OSZCZĘDZANIE","subCategName":"Regularne oszczędzanie","amount":-6.52,"currency":"PLN"},{"transactionId":6898,"authorizationId":0,"accountNumber":"*ciach*","creditCardNumber":"","icon":0,"iconDescription":"Przelew","date":"2014-09-16T00:00:00.000","desc":"*ciach*","subCategName":"Wpływy - inne","amount":817.38,"currency":"PLN"},{"transactionId":51,"authorizationId":25,"accountNumber":"*ciach*","creditCardNumber":"*ciach*","icon":1,"iconDescription":"Płatność kartą","date":"2014-09-15T00:00:00.000","desc":"TESCO","subCategName":"Żywność i chemia domowa","amount":-*ciach*.48,"currency":"PLN"},{"transactionId":6897,"authorizationId":0,"accountNumber":"*ciach*","creditCardNumber":"*ciach*","icon":4,"iconDescription":"Inna operacja","date":"2014-09-15T00:00:00.000","desc":"OPŁATA ZA DODATKOWĄ KARTĘ","subCategName":"Opłaty i odsetki","amount":-3.00,"currency":"PLN"}

przy pomocy

[PHP] pobierz, plaintext 
	$obj_historia = json_decode($json_historia);
	foreach ($obj_historia as $name => $value) {
        echo $date.' '.$desc.' '.$amount.' '.$currency;
    }
[PHP] pobierz, plaintext 

chcę odczytać wybrane rzeczy jednakże zwraca Invalid argument supplied for foreach()

gdzie w pętli zrobiłem błąd?

Ten post edytował rybosom 18.09.2014, 13:49:29

[Turson]

Przed pętlą zrób

[PHP] pobierz, plaintext 
echo '<pre>'; var_dump($obj_historia); echo '</pre>';
[PHP] pobierz, plaintext 

sprawdz jak wyglada, albo wklej nam

[rybosom]

o ja! wynik to NULL

[Rochu]

Dzieje się tak z tego względu, że JSON response, który wkleiłeś jest błędny - dlatego też funkcja json_decode zwraca null.

[rybosom]

tak jest błędny bo zawiera 7 tablic ale taki ja właśnie otrzymuję.

muszę chyba najpierw rozbić {},{},{},{},{},{},{} i zrobić pętlę w pętli, dobrze myślę?

[Rochu]

ewentualnie "naprawiasz" dany JSON, by funkcja json_decode poprawnie go obsłużyła i wrzucasz go w pętlę, moim zdaniem bardziej optymalne

[Pyton_000]

dodaj do JSON [ na początku i ] na końcu stringu. Zadziała (IMG:style_emoticons/default/wink.gif)

[rybosom]

dodaj do JSON [ na początku i ] na końcu stringu. Zadziała (IMG:style_emoticons/default/wink.gif)

przy

[PHP] pobierz, plaintext 
   $obj_historia = json_decode('['.$json_historia.']');
 
    echo '<pre>'; var_dump($obj_historia); echo '</pre>';
[PHP] pobierz, plaintext 

też jest NULL

[Pyton_000]

Kod

"Żywność i chemia domowa","amount":-*ciach*.48,"currency":"PLN"},

->

amount":-*ciach*.48,"currency":"PLN"}

Brakuje ""

[rybosom]

faktycznie, teraz widzę że JSON response zawiera same błędy bo taka konstrukcja jest w każdej tablicy

"icon":0,


"transactionId":0,


"authorizationId":13,


"amount":-3.00

czyli kapota bo nie mam wpływu na kształt otrzymanych danych

chyba że dorobię jakieś sprytne wyrażenie regularne

Ten post edytował rybosom 18.09.2014, 14:11:55

[Pyton_000]

Ehh...

-3.00 zostanie poprawnie zinterpretowwa bo to liczba, ale już -ciach.48 to jes string.

Przez to że wstawiłes tam "ciach" rozsypałeś JSON

Ten post edytował Pyton_000 18.09.2014, 14:18:41

[rybosom]

Przez to że wstawiłes tam "ciach" rozsypałeś JSON

masz rację, poprawiłem JSON

[PHP] pobierz, plaintext 
{"transactionId":0,"authorizationId":13,"accountNumber":"cut","creditCardNumber":"","icon":2,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.80,"currency":"PLN"},{"transactionId":6901,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.63,"currency":"PLN"},{"transactionId":6900,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.37,"currency":"PLN"},{"transactionId":6899,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.52,"currency":"PLN"},{"transactionId":6898,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":1.38,"currency":"PLN"},{"transactionId":51,"authorizationId":25,"accountNumber":"cut","creditCardNumber":"","icon":1,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.48,"currency":"PLN"},{"transactionId":6897,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":4,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-3.00,"currency":"PLN"}
[PHP] pobierz, plaintext 

i gdy wykonuję

[PHP] pobierz, plaintext 
    $pieces = explode("},{", $json_historia);
    echo '<pre>'; var_dump($pieces); echo '</pre>';
[PHP] pobierz, plaintext 

otrzymuję

[PHP] pobierz, plaintext 
array(7) {
  [0]=>
  string(215) "{"transactionId":0,"authorizationId":13,"accountNumber":"cut","creditCardNumber":"","icon":2,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.80,"currency":"PLN""
  [1]=>
  string(216) ""transactionId":6901,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.63,"currency":"PLN""
  [2]=>
  string(216) ""transactionId":6900,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.37,"currency":"PLN""
  [3]=>
  string(216) ""transactionId":6899,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.52,"currency":"PLN""
  [4]=>
  string(215) ""transactionId":6898,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":1.38,"currency":"PLN""
  [5]=>
  string(215) ""transactionId":51,"authorizationId":25,"accountNumber":"cut","creditCardNumber":"","icon":1,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.48,"currency":"PLN""
  [6]=>
  string(217) ""transactionId":6897,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":4,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-3.00,"currency":"PLN"}"
}
[PHP] pobierz, plaintext 

teraz muszę wymyślić jakaś sprytną pętlę aby wyświetlić tylko "date - desc - amount - currency"

[Pyton_000]

[PHP] pobierz, plaintext 
foreach($decoded_json as $json)  {
$small_json = json_decode($json);
echo $small_json['date'];
}
[PHP] pobierz, plaintext 

tak na szybko

[rybosom]

[PHP] pobierz, plaintext 
$json_historia = $row["historia"];
    $jj = explode("},{", $json_historia);
    $obj_historia = json_decode($jj);
    foreach($obj_historia as $json) {
        $small_json = json_decode($json);
        echo $small_json['date'];
    }
[PHP] pobierz, plaintext 

zwraca

Warning: json_decode() expects parameter 1 to be string, array given in j.php on line 45
Warning: Invalid argument supplied for foreach() in j.php on line 46

[Pyton_000]

Ehhh....
i po cholere ta kombinacja ?

To co dałeś jako "poprawione" w poprzednim poscie umieść między [] i przepuść przez json_decode. Otrzymasz zdekodowanego jsona a nie jakieś zabawy :|

Czyli:

[PHP] pobierz, plaintext 
$json = '[{"transactionId":0,"authorizationId":13,"accountNumber":"cut","creditCardNumber":"","icon":2,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.80,"currency":"PLN"},{"transactionId":6901,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.63,"currency":"PLN"},{"transactionId":6900,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.37,"currency":"PLN"},{"transactionId":6899,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.52,"currency":"PLN"},{"transactionId":6898,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":1.38,"currency":"PLN"},{"transactionId":51,"authorizationId":25,"accountNumber":"cut","creditCardNumber":"","icon":1,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.48,"currency":"PLN"},{"transactionId":6897,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":4,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-3.00,"currency":"PLN"}]';
 
$json = json_decode($json));
var_dump(json_decode($json));
 
echo $json->date;
[PHP] pobierz, plaintext 

Ew. drugi parametr json_decode na true i masz same tablce

Ten post edytował Pyton_000 18.09.2014, 17:48:44

[rybosom]

nie wiem czy dobrze zrozumiałem, dałem

[PHP] pobierz, plaintext 
    $json = '[{"transactionId":0,"authorizationId":13,"accountNumber":"cut","creditCardNumber":"","icon":2,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.80,"currency":"PLN"},{"transactionId":6901,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.63,"currency":"PLN"},{"transactionId":6900,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.37,"currency":"PLN"},{"transactionId":6899,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.52,"currency":"PLN"},{"transactionId":6898,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":1.38,"currency":"PLN"},{"transactionId":51,"authorizationId":25,"accountNumber":"cut","creditCardNumber":"","icon":1,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.48,"currency":"PLN"},{"transactionId":6897,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":4,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-3.00,"currency":"PLN"}]';
 
    $json = json_decode($json);
    var_dump(json_decode($json), TRUE);
 
    echo $json->date[0];
[PHP] pobierz, plaintext 

i dostałem

Warning: json_decode() expects parameter 1 to be string, array given in j.php on line 5
NULL bool(true)

[Turson]

A jak raz zdekodujesz?

[rybosom]

[PHP] pobierz, plaintext 
$json_historia = '[{"transactionId":0,"authorizationId":13,"accountNumber":"cut","creditCardNumber":"","icon":2,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.80,"currency":"PLN"},{"transactionId":6901,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.63,"currency":"PLN"},{"transactionId":6900,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.37,"currency":"PLN"},{"transactionId":6899,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.52,"currency":"PLN"},{"transactionId":6898,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":1.38,"currency":"PLN"},{"transactionId":51,"authorizationId":25,"accountNumber":"cut","creditCardNumber":"","icon":1,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.48,"currency":"PLN"},{"transactionId":6897,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":4,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-3.00,"currency":"PLN"}]';
 
$pieces = explode("},{", $json_historia);
$json = json_decode($pieces);
 
echo $json->date;
[PHP] pobierz, plaintext 

daje to samo czyli Warning: json_decode() expects parameter 1 to be string

Ten post edytował rybosom 18.09.2014, 18:55:43

[Pyton_000]

Ja już straciłem cierpliwość... Chciałbym napisać kilka niecenzuralnych słów ale powstrzymam się dla swojego dobra.

[PHP] pobierz, plaintext 
$json = '[{"transactionId":0,"authorizationId":13,"accountNumber":"cut","creditCardNumber":"","icon":2,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.80,"currency":"PLN"},{"transactionId":6901,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.63,"currency":"PLN"},{"transactionId":6900,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-17T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.37,"currency":"PLN"},{"transactionId":6899,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.52,"currency":"PLN"},{"transactionId":6898,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":0,"iconDescription":"cut","date":"2014-09-16T00:00:00.000","desc":"cut","subCategName":"cut","amount":1.38,"currency":"PLN"},{"transactionId":51,"authorizationId":25,"accountNumber":"cut","creditCardNumber":"","icon":1,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-1.48,"currency":"PLN"},{"transactionId":6897,"authorizationId":0,"accountNumber":"cut","creditCardNumber":"","icon":4,"iconDescription":"cut","date":"2014-09-15T00:00:00.000","desc":"cut","subCategName":"cut","amount":-3.00,"currency":"PLN"}]';
 
$json = json_decode($json, true);
echo '<pre>'; var_dump($json); die("\n".(__FILE__)." ".(__LINE__));
[PHP] pobierz, plaintext 

[rybosom]

Ja już straciłem cierpliwość...

cierpliwość się opłaciła (IMG:style_emoticons/default/wink.gif)

bardzo ładne tablice, czyli teraz foreach aby uzyskać date - desc - amount - currency

mam nadzieję że pójdzie łatwo

Ten post edytował rybosom 18.09.2014, 19:44:39