Forum PHP.pl > [PHP]JSON foreach

Pomoc - Szukaj - Użytkownicy - Kalendarz

rybosom

18.09.2014, 12:09:16

mam następujący JSON response

Cytat

{"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?

Turson

18.09.2014, 12:11:45

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

18.09.2014, 12:15:42

o ja! wynik to NULL

Rochu

18.09.2014, 12:26:30

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

18.09.2014, 12:32:01

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

18.09.2014, 12:44:36

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

18.09.2014, 12:58:54

dodaj do JSON [ na początku i ] na końcu stringu. Zadziała

rybosom

18.09.2014, 13:45:01

Cytat(Pyton_000 @ 18.09.2014, 13:58:54 )

dodaj do JSON [ na początku i ] na końcu stringu. Zadziała

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

18.09.2014, 13:52:03

Kod

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

Cytat

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

Brakuje ""

rybosom

18.09.2014, 14:06:08

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

Cytat

"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

Pyton_000

18.09.2014, 14:18:04

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

rybosom

18.09.2014, 17:28:55

Cytat(Pyton_000 @ 18.09.2014, 15:18:04 )

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

18.09.2014, 17:32:43

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

tak na szybko

rybosom

18.09.2014, 17:41:57

[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

18.09.2014, 17:44:47

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

rybosom

18.09.2014, 18:01:37

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

Cytat

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

Turson

18.09.2014, 18:16:25

A jak raz zdekodujesz?

rybosom

18.09.2014, 18:46:51

[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

Pyton_000

18.09.2014, 19:07:48

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

18.09.2014, 19:18:01

Cytat(Pyton_000 @ 18.09.2014, 20:07:48 )

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

cierpliwość się opłaciła

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

mam nadzieję że pójdzie łatwo

To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.