PHP array foreach item

Question

I'm Having issues grabbing values in a multi level array.

This is my JSON I am grabbing with CURL and putting into a variable.

{
  "id": 454626,
  "results": [
    {
      "iso_3166_1": "SK",
      "release_dates": [
        {
          "certification": "U",
          "iso_639_1": "sk",
          "note": "",
          "release_date": "2020-02-20T00:00:00.000Z",
          "type": 3
        }
      ]
    },
    {
      "iso_3166_1": "DE",
      "release_dates": [
        {
          "certification": "6",
          "iso_639_1": "",
          "note": "",
          "release_date": "2020-02-13T00:00:00.000Z",
          "type": 3
        }
      ]
    },
    {
      "iso_3166_1": "TW",
      "release_dates": [
        {
          "certification": "G",
          "iso_639_1": "",
          "note": "",
          "release_date": "2020-02-21T00:00:00.000Z",
          "type": 3
        }
      ]
    }
  ]
}

This is my PHP code that I'm having issues with.

$id_tmdb = $row[id_tmdb];

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => "https://api.themoviedb.org/3/movie/$id_tmdb/release_dates?api_key=API-KEY",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET"
));

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

$result = json_decode($response, true);


foreach($result[results][release_dates] as $key=>$val){
    echo "$val[release_date]";
}

I'm trying to get the release_date but it just shows blank.

I have another page that is formatted the same way so I am unsure why it isn't working.... Thank you for all your help.

Do you have error reporting turned on? Also, did you copy/paste the code or did you write some of it by hand here? — El_Vanja
– El_Vanja, Commented Mar 8, 2020 at 21:39
Also error reporting is turned on and not reporting anything — StephenM
– StephenM, Commented Mar 8, 2020 at 21:53
That is weird as you should be seeing at least 4 warnings/notices. So, is your goal just getting all the release dates from all the results? — El_Vanja
– El_Vanja, Commented Mar 8, 2020 at 21:59

Nick · Accepted Answer · 2020-03-08 22:37:59Z

2

Your $result['results'] value is also an array and you need to iterate over that as well as the release_dates array:

foreach($result['results'] as $results) {
    foreach ($results['release_dates'] as $val){
        echo "$val[release_date]\n";
    }
}

Output (for the sample JSON provided):

2020-02-20T00:00:00.000Z
2020-02-13T00:00:00.000Z
2020-02-21T00:00:00.000Z

Demo on 3v4l.org

answered Mar 8, 2020 at 22:37

Nick

147k23 gold badges67 silver badges106 bronze badges

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

1 Comment

StephenM Over a year ago

Ahhhh yes that makes sense. Been hitting my head against the wall for hours. Thanks for your help

Rob Moll · Accepted Answer · 2020-03-08 22:19:44Z

0

This should get you there:

foreach($result['results'] as $res){
    echo $res['release_dates'][0]['release_date']."\n";
}

3v4l link

On a side-note, I put the array keys in quotes to prevent php warnings.

edited Mar 8, 2020 at 22:19

answered Mar 8, 2020 at 22:09

Rob Moll

3,4732 gold badges12 silver badges15 bronze badges

Collectives™ on Stack Overflow

PHP array foreach item

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related