How can I parse a JSON file with PHP

Question

I tried to parse a JSON file using PHP  But I am stuck now   This is the content of my JSON file          John              status   Wait              Jennifer              status   Active              James              status   Active            age  56           count  10           progress  0 0029857           bad  0           And this is what I have tried so far    lt  php   string   file get contents   home michael test json     json a   json decode  string  true    echo  json a  John   status   echo  json a  Jennifer   status     But because I don t know the names  like  John    Jennifer   and all available keys and values  like  age    count   beforehand  I think I need to create some foreach loop   I would appreciate an example for this

User · Answer

I am using below code for converting json to array in PHP, If JSON is valid then json_decode() works well, and will return an array, But in case of malformed JSON It will return NULL,

<?php
function jsonDecode1($json){
    $arr = json_decode($json, true);
    return $arr;
}

// In case of malformed JSON, it will return NULL
var_dump( jsonDecode1($json) );
?>

If in case of malformed JSON, you are expecting only array, then you can use this function,

<?php
function jsonDecode2($json){
    $arr = (array) json_decode($json, true);
    return $arr;
}

// In case of malformed JSON, it will return an empty array()
var_dump( jsonDecode2($json) );
?>

If in case of malformed JSON, you want to stop code execution, then you can use this function,

<?php
function jsonDecode3($json){
    $arr = (array) json_decode($json, true);

    if(empty(json_last_error())){
        return $arr;
    }
    else{
        throw new ErrorException( json_last_error_msg() );
    }
}

// In case of malformed JSON, Fatal error will be generated
var_dump( jsonDecode3($json) );
?>

User · Answer

I can t believe so many people are posting answers without reading the JSON properly   If you foreach iterate  json a alone  you have an object of objects  Even if you pass in true as the second parameter  you have a two-dimensional array  If you re looping through the first dimension you can t just echo the second dimension like that  So this is wrong   foreach   json a as  k   gt   v       echo  k          v      To echo the statuses of each person  try this    lt  php   string   file get contents   home michael test json    if   string     false           deal with error        json a   json decode  string  true   if   json a     null           deal with error       foreach   json a as  person name   gt   person a        echo  person a  status         gt

User · Answer

Try    string   file get contents   home michael test json     json   json decode  string  true    foreach   json as  key   gt   value        if   is array  value             echo  key      gt      value     lt br   gt          else           foreach   value as  key   gt   val                echo  key      gt      val     lt br   gt

User · Answer

Try it   foreach   json a as  key   gt   value        echo  key            foreach  value as  v              echo  v

User · Answer

The quickest way to echo all json values is using loop in loop  the first loop is going to get all the objects and the second one the values     foreach  data as  object             foreach  object as  value                 echo  value

User · Answer

You have to give like this   echo   json a  John    status      echo   lt  gt    echo   json a  Jennifer    status     br inside  lt  gt    Which gives the result    wait active

User · Answer

To iterate over a multidimensional array  you can use RecursiveArrayIterator   jsonIterator   new RecursiveIteratorIterator      new RecursiveArrayIterator json decode  json  TRUE        RecursiveIteratorIterator  SELF FIRST    foreach   jsonIterator as  key   gt   val        if is array  val             echo   key  n         else           echo   key   gt   val n             Output   John  status   gt  Wait Jennifer  status   gt  Active James  status   gt  Active age   gt  56 count   gt  10 progress   gt  0 0029857 bad   gt  0   run on codepad

User · Answer

Try  lt  php  string   file get contents  quot  home michael test json quot     json a   json decode  string true    foreach   json a as  key   gt   value     echo   key          value      gt

User · Answer

When you decode a json string  you will get an object  not an array  So the best way to see the structure you are getting  is to make a var dump of the decode   this var dump can help you understand the structure  mainly in complex cases     lt  php       json   file get contents   home michael test json          json a   json decode  json        var dump  json a      just to see the structure  It will help you for future cases      echo   n        foreach  json a as  row            echo  row- gt status           echo   n            gt

User · Answer

Loop through the JSON with a foreach loop as key-value pairs  Do type-checking to determine if more looping needs to be done   foreach  json a as  key   gt   value        echo  key      if  gettype  value      object             foreach   value as  key   gt   value                and so on

User · Answer

Try This       json data           John              status   Wait              Jennifer              status   Active              James              status   Active            age  56           count  10           progress  0 0029857           bad  0                        decode data   json decode  json data       foreach  decode data as  key  gt  value                print r  value

User · Answer

json a   json decode  string  TRUE    json o   json decode  string      foreach  json a as  person   gt   value        foreach  value as  key   gt   personal                echo  person    with    key     is    personal          echo   lt br gt

User · Answer

The most elegant solution    shipments   json decode file get contents  shipments js    true   print r  shipments     Remember that the json-file has to be encoded in UTF-8 without BOM  If the file has BOM  then json decode will return NULL   Alternatively    shipments   json encode json decode file get contents  shipments js    true    echo  shipments

User · Answer

More standard answer    jsondata   file get contents PATH TO JSON FILE   jsonfile json      array   json decode  jsondata true    foreach  array as  k  gt  val       echo   lt b gt Name     k   lt  b gt  lt  br gt         keys   array keys  val       foreach  keys as  key           echo   amp nbsp   ucfirst  key         val  key    lt  br gt        endforeach  endforeach    And the output is   Name  John  Status   Wait Name  Jennifer  Status   Active Name  James  Status   Active  Age   56  Count   10  Progress   0 0029857  Bad   0

User · Answer

It s completely beyond me that no one pointed out that your begining  tags  are wrong  You re creating an object with     while you could create an array with             lt -- Note that I changed this                name     john      And moved the name here           status   Wait                        name     Jennifer            status   Active                        name     James            status   Active            age  56           count  10           progress  0 0029857           bad  0             lt -- And this    With this change  the json will be parsed as an array instead of an object  And with that array  you can do whatever you want  like loops etc

User · Answer

lt  php  json           response              data      identifier    Be Soft Drinker  Inc     entityName    BusinessPartner              status   0           totalRows   83           startRow   0           endRow   82            json   json decode  json  true     echo   lt pre gt    print r  json   exit  echo  json  response    data   0   identifier     json  response    data   0   entityName   echo  json  response    status     echo  json  response    totalRows     echo  json  response    startRow     echo  json  response    endRow        gt

[php] How can I parse a JSON file with PHP?

Examples related to php

Examples related to json