PHP convert XML to JSON

Question

I am trying to convert xml to json in php  If I do a simple convert using simple xml and json encode none of the attributes in the xml show    xml   simplexml load file  states xml    echo json encode  xml     So I am trying to manually parse it like this   foreach  xml- gt children   as  state         states    array  state    gt   state- gt name             echo json encode  states     and the output for state is   state    0   Alabama    rather than   state   Alabama    What am I doing wrong   XML    lt  xml version  1 0    gt   lt states gt       lt state id  AL  gt            lt name gt Alabama lt  name gt       lt  state gt       lt state id  AK  gt           lt name gt Alaska lt  name gt       lt  state gt   lt  states gt    Output      state    0   Alabama      state    0   Alaska     var dump   object SimpleXMLElement  1  1      state    gt  array 2     0   gt  object SimpleXMLElement  3  2         attributes    gt    array 1          id    gt      string 2   AL          name    gt    string 7   Alabama     1   gt  object SimpleXMLElement  2  2         attributes    gt    array 1          id    gt      string 2   AK          name    gt    string 6   Alaska

User · Answer

This is better solution   fileContents  file get contents  https   www feedforall com sample xml     fileContents   str replace array   n     r     t         fileContents    fileContents   trim str replace            fileContents     simpleXml   simplexml load string  fileContents    json   json encode  simpleXml    array   json decode  json TRUE   return  array

User · Answer

Best solution which works like a charm   fileContents  file get contents  url     fileContents   str replace array   n     r     t         fileContents     fileContents   trim str replace            fileContents      simpleXml   simplexml load string  fileContents       json   json encode  simpleXml      Remove    if you want to store the result in  json variable  echo   lt pre gt   json encode  simpleXml JSON PRETTY PRINT    lt  pre gt      Source

User · Answer

I figured it out  json encode handles objects differently than strings  I cast the object to a string and it works now   foreach  xml- gt children   as  state         states    array  state    gt   string  state- gt name             echo json encode  states

User · Answer

I guess I m a bit late to the party but I have written a small function to accomplish this task  It also takes care of attributes  text content and even if multiple nodes with the same node-name are siblings   Dislaimer  I m not a PHP native  so please bear with simple mistakes   function xml2js  xmlnode         root    func num args    gt  1   false   true        jsnode   array         if    root            if  count  xmlnode- gt attributes     gt  0                jsnode        array                foreach  xmlnode- gt attributes   as  key   gt   value                   jsnode       key     string  value                      textcontent   trim  string  xmlnode           if  count  textcontent   gt  0               jsnode         textcontent           foreach   xmlnode- gt children   as  childxmlnode                 childname    childxmlnode- gt getName                if   array key exists  childname   jsnode                    jsnode  childname    array                array push  jsnode  childname   xml2js  childxmlnode  true                      return  jsnode        else            nodename    xmlnode- gt getName             jsnode  nodename    array            array push  jsnode  nodename   xml2js  xmlnode  true            return json encode  jsnode                Usage example    xml   simplexml load file  myfile xml    echo xml2js  xml     Example Input  myfile xml     lt family name  Johnson  gt       lt child name  John  age  5  gt           lt toy status  old  gt Trooper lt  toy gt           lt toy status  old  gt Ultrablock lt  toy gt           lt toy status  new  gt Bike lt  toy gt       lt  child gt   lt  family gt    Example output     family          name   Johnson    child          name   John   age   5    toy          status   old        Trooper          status   old        Ultrablock          status   new        Bike           Pretty printed          family                                            name     Johnson                              child                                                            name     John                            age     5                                              toy                                                                            status     old                                                                    Trooper                                                                                                    status     old                                                                    Ultrablock                                                                                                    status     new                                                                    Bike                                                                                                      Quirks to keep in mind  Several tags with the same tagname can be siblings  Other solutions will most likely drop all but the last sibling  To avoid this each and every single node  even if it only has one child  is an array which hold an object for each instance of the tagname   See multiple    elements in example   Even the root element  of which only one should exist in a valid XML document is stored as array with an object of the instance  just to have a consistent data structure   To be able to distinguish between XML node content and XML attributes each objects attributes are stored in the     and the content in the     child   Edit  I forgot to show the output for your example input data         states                    state                                                            id     AL                                              name                                          Alabama                                                                                                                            id     AK                                              name                                          Alaska

User · Answer

if you XML is a soap file  you can use  this   xmlStr   preg replace  quot    lt       w       gt    gt    quot    quot  1 2 3 quot    xmlStr    xml   new SimpleXMLElement  xmlStr   return json encode  xml

User · Answer

Json  amp  Array from XML in 3 lines    xml   simplexml load string  xml string    json   json encode  xml    array   json decode  json TRUE

User · Answer

This is an improvement of the most upvoted solution by Antonio Max  which also works with XML that has namespaces  by replacing the colon with an underscore   It also has some extra options  and does parse  lt person my-attribute  name  gt John lt  person gt  correctly    function parse xml into array  xml string   options   array                 DESCRIPTION      - parse an XML string into an array     INPUT      -  xml string     -  options   associative array with any of these keys          -  flatten cdata    set to true to flatten CDATA elements         -  use objects    set to true to parse into objects instead of associative arrays         -  convert booleans    set to true to cast string values  true  and  false  into booleans     OUTPUT      - associative array                Remove namespaces by replacing     with         if  preg match all    lt      w  -        w  -    gt      xml string   matches  PREG SET ORDER             foreach   matches as  match                 xml string   str replace   lt     match 1         match 2     lt     match 1         match 2    xml string                xml string   str replace   lt      match 1         match 2     lt      match 1         match 2    xml string                         output   json decode json encode  simplexml load string  xml string   SimpleXMLElement     options  flatten cdata     LIBXML NOCDATA   0       options  use objects     false   true            Cast string values  true  and  false  to booleans     if   options  convert booleans               bool   function  amp  item   key                if  in array  item  array  true    TRUE    True    true                      item   true                elseif  in array  item  array  false    FALSE    False    true                      item   false                                   array walk recursive  output   bool              return  output

User · Answer

A common pitfall is to forget that json encode   does not respect elements with a textvalue and attribute s   It will choose one of those  meaning dataloss  The function below solves that problem  If one decides to go for the json encode decode way  the following function is advised   function json prepare xml  domNode      foreach  domNode- gt childNodes as  node        if  node- gt hasChildNodes            json prepare xml  node         else         if  domNode- gt hasAttributes    amp  amp  strlen  domNode- gt nodeValue              domNode- gt setAttribute  nodeValue    node- gt textContent             node- gt nodeValue                             dom   new DOMDocument     dom- gt loadXML  file get contents  xmlfile     json prepare xml  dom    sxml   simplexml load string   dom- gt saveXML       json   json decode  json encode   sxml        by doing so   lt foo bar  3  gt Lorem lt  foo gt  will not end up as   foo   Lorem   in your JSON

User · Answer

Try to use this   xml          Xml file data     first approach  Json   json encode simplexml load string  xml     ---------------- OR -----------------------     second approach  Json   json encode simplexml load string  xml   SimpleXMLElement   LIBXML NOCDATA     echo  Json    Or   You can use this library   https   github com rentpost xml2array

User · Answer

Looks like the  state- gt name variable is holding an array   You can use  var dump  state    inside the foreach to test that   If that s the case  you can change the line inside the foreach to    states    array  state    gt  array shift  state- gt name       to correct it

User · Answer

If you would like to only convert a specific part of the XML to JSON  you can use XPath to retrieve this and convert that to JSON    lt  php  file    file get contents  xml File  FILE TEXT    xml   new SimpleXMLElement  file    xml Excerpt     xml- gt xpath   states state  id  AL     0       0  gets the node echo json encode  xml Excerpt     gt    Please note that if you Xpath is incorrect  this will die with an error  So if you re debugging this through AJAX calls I recommend you log the response bodies as well

User · Answer

Optimizing Antonio Max answer    xmlfile    yourfile xml    xmlparser   xml parser create        open a file and read data  fp   fopen  xmlfile   r      9999999 is the length which fread stops to read   xmldata   fread  fp  9999999       converting to XML  xml   simplexml load string  xmldata   SimpleXMLElement   LIBXML NOCDATA       converting to JSON  json   json encode  xml    array   json decode  json TRUE

User · Answer

I ve used Miles Johnson s TypeConverter for this purpose  It s installable using Composer   You could write something like this using it    lt  php require  vendor autoload php   use mjohnson utility TypeConverter    xml   file get contents  file xml     arr   TypeConverter  xmlToArray  xml  TypeConverter  XML GROUP   echo json encode  arr

User · Answer

templateData      POST  data        initializing or creating array  template info     templateData      creating object of SimpleXMLElement  xml template info   new SimpleXMLElement   lt  xml version   1 0    gt  lt template gt  lt  template gt         function call to convert array to xml array to xml  template info  xml template info      saving generated xml file   xml template info- gt asXML dirname   FILE      manifest xml         function defination to convert array to xml function array to xml  template info   amp  xml template info        foreach  template info as  key   gt   value            if is array  value                 if  is numeric  key                     subnode    xml template info- gt addChild  key                   if is array  value                         cont   0                      foreach array keys  value  as  k                           if is numeric  k    cont                                                             if  cont gt 0                       for  i 0   i  lt   cont   i                              subnode    xml body info- gt addChild  key                           array to xml  value  i    subnode                                          else                       subnode    xml body info- gt addChild  key                       array to xml  value   subnode                                               else                  array to xml  value   xml template info                                   else                xml template info- gt addChild  key  value

User · Answer

After researching a little bit all of the answers  I came up with a solution that worked just fine with my JavaScript functions across browsers  Including consoles   Dev Tools      lt  php      PHP Version 7 2 1  Windows 10 x86    function json2xml   domNode       foreach   domNode - gt  childNodes as  node       if    node - gt  hasChildNodes       json2xml   node         else       if    domNode - gt  hasAttributes    amp  amp  strlen   domNode - gt  nodeValue             domNode - gt  setAttribute   nodeValue    node - gt  textContent          node - gt  nodeValue                           function jsonOut   file        dom   new DOMDocument       dom - gt  loadXML  file get contents   file        json2xml   dom      header   Content-Type  application json       return str replace           json encode  simplexml load string   dom - gt  saveXML      JSON PRETTY PRINT            output   jsonOut   https   boxelizer com assets a1e10642e9294f39 b6f30987f0b66103 xml       echo   output           Or simply    echo  jsonOut   https   boxelizer com assets a1e10642e9294f39 b6f30987f0b66103 xml              gt    It basically creates a new DOMDocument  loads and XML file into it and traverses through each one of the nodes and children getting the data   parameters and exporting it into JSON without the annoying     signs   Link to the XML file

User · Answer

If you are ubuntu user install xml reader  i have php 5 6  if you have other please find package and install   sudo apt-get install php5 6-xml service apache2 restart   fileContents   file get contents  myDirPath filename xml     fileContents   str replace array   n     r     t         fileContents    fileContents   trim str replace            fileContents     oldXml    fileContents   simpleXml   simplexml load string  fileContents    json   json encode  simpleXml

User · Answer

All solutions here have problems       When the representation need perfect XML interpretation  without problems with attributes  and to reproduce all text-tag-text-tag-text-    and order of tags  Also good remember here that JSON object  is an unordered set   not repeat keys and the keys can t have predefined order      Even ZF s xml2json is wrong     because not preserve exactly the XML structure   All solutions here have problems with this simple XML        lt states x-x  1  gt           lt state y  123  gt Alabama lt  state gt          My name is  lt b gt John lt  b gt  Doe          lt state gt Alaska lt  state gt       lt  states gt         FTav solution seems better than 3-line solution  but also have little bug when tested with this XML   Old solution is the best  for loss-less representation   The solution  today well-known as jsonML  is used by Zorba project and others  and was first presented in  2006 or  2007  by  separately  Stephen McKamey and John Snelson       the core algorithm is the XSLT of the  jsonML conventions     see  https   github com mckamey jsonml  xslt    https   raw githubusercontent com mckamey jsonml master jsonml xslt    dom   new DOMDocument   dom- gt loadXML        lt states x-x   1   gt           lt state y  123  gt Alabama lt  state gt          My name is  lt b gt John lt  b gt  Doe          lt state gt Alaska lt  state gt       lt  states gt      if    dom  die   nERROR      xslDoc   new DOMDocument     xslDoc- gt load  xslt    proc   new XSLTProcessor     proc- gt importStylesheet  xslDoc   echo  proc- gt transformToXML  dom     Produce     states    x-x   1          n t             state    y   123    Alabama          n t tMy name is          b   John          Doe n t             state   Alaska          n t      See http   jsonML org or github com mckamey jsonml   The production rules of this JSON are based on the element JSON-analog       This syntax is a element definition and recurrence  with element-list     element     element-list   element

User · Answer

Found FTav s answer the most useful as it is very customizable  but his xml2js function has some flaws  For instance  if children elements has equal tagnames they all will be stored in a single object  this means that the order of elements will not be preserved  In some cases we really want to preserve order  so we better store every element s data in a separate object   function xml2js  xmlnode         jsnode   array         nodename    xmlnode- gt getName         current object   array         if  count  xmlnode- gt attributes     gt  0            foreach  xmlnode- gt attributes   as  key   gt   value                 current object  key     string  value                        textcontent   trim  string  xmlnode       if  strlen  textcontent   gt  0             current object  content      textcontent             if  count  xmlnode- gt children     gt  0             current object  children     array            foreach   xmlnode- gt children   as  childxmlnode                 childname    childxmlnode- gt getName                array push  current object  children    xml2js  childxmlnode  true                          jsnode   nodename      current object      return  jsnode      Here is how it works  Initial xml structure    lt some-tag some-attribute  value of some attribute  gt     lt another-tag gt With text lt  another-tag gt     lt surprise gt  lt  surprise gt     lt another-tag gt The last one lt  another-tag gt   lt  some-tag gt    Result JSON          some-tag              some-attribute    value of some attribute            children                                    another-tag                          content    With text                                                                  surprise                                                    another-tag                          content    The last one

User · Answer

With accepted  antonio s  answer  from such source   lt MyData gt     lt Level1 myRel  quot parent quot  myName  quot AAA quot  gt       lt Level2 myRel  quot child1 quot  myName  quot BBB quot  gt       lt Level2 myRel  quot child2 quot  myName  quot CCC quot  gt             you will get array like     Level1    gt            0   gt                      attributes    gt                              myRel    gt   parent                 myName     gt   AAA                          Level2    gt                             0   gt                                       attributes    gt                                              myRel     gt   child 1                         myName      gt   BBB                        So  if you want to have Key-Paired array  instead of 0 numbers   with your chosen key  i e  myName     Level1    gt             AAA    gt                      attributes    gt                              myRel    gt   parent                 myName     gt   AAA                          Level2    gt                              BBB    gt                                       attributes    gt                                              myRel     gt   child 1                         myName      gt   BBB                        then use xmlToArrayByKey  xmlContent   myName     Code Here  public function xmlToArrayByKey  content   keyName        try                xml   simplexml load string  content   quot SimpleXMLElement quot   LIBXML NOCDATA             array  json decode  json encode  xml   TRUE           return  this- gt xmlSetChild  array   keyName         catch  Exception  ex            return   xmlerror   gt  ex            public function xmlSetChild  array   keyName   step 0         new array          foreach   array as  key 1  gt  value 1                if  is array  value 1   amp  amp  isset  value 1 0                          foreach   value 1 as  idx  gt  value 2                                 keyValue    value 2   attributes    keyName                    new array  key 1   keyValue     this- gt xmlSetChild  value 2   keyName   step 1                                   else               new array  key 1   value 1                      return  new array

User · Answer

This solution handles namespaces  attributes  and produces consistent result with repeating elements  always in array  even if there is only one occurrence   Inspired by ratfactor s sxiToArray             lt root gt  lt a gt 5 lt  a gt  lt b gt 6 lt  b gt  lt b gt 8 lt  b gt  lt  root gt  - gt    root     a    5    b    6   8          lt root a  5  gt  lt b gt 6 lt  b gt  lt b gt 8 lt  b gt  lt  root gt  - gt    root     a   5   b    6   8          lt root xmlns wsp  http   schemas xmlsoap org ws 2004 09 policy  gt  lt a gt 123 lt  a gt  lt wsp b gt 456 lt  wsp b gt  lt  root gt        - gt    root     xmlns wsp   http   schemas xmlsoap org ws 2004 09 policy   a    123    wsp b    456          function domNodesToArray array  tags   DOMXPath  xpath         tagNameToArr           foreach   tags as  tag             tagData                attrs    tag- gt attributes   iterator to array  tag- gt attributes                 subTags    tag- gt childNodes   iterator to array  tag- gt childNodes                foreach   xpath- gt query  namespace       tag  as  nsNode                   the only way to get xmlns    see https   stackoverflow com a 2470433 2750743             if   tag- gt hasAttribute  nsNode- gt nodeName                      attrs      nsNode                                   foreach   attrs as  attr                 tagData  attr- gt nodeName     attr- gt nodeValue                    if  count  subTags      1  amp  amp   subTags 0  instanceof  DOMText                 text    subTags 0 - gt nodeValue            elseif  count  subTags      0                 text                 else                  ignore whitespace  and any other text if any  between nodes              isNotDomText   function  node  return    node instanceof  DOMText                  realNodes   array filter  subTags   isNotDomText                subTagNameToArr   domNodesToArray  realNodes   xpath                tagData   array merge  tagData   subTagNameToArr                text   null                    if   is null  text                 if   attrs                    if   text                         tagData         text                                  else                    tagData    text                                   keyName    tag- gt nodeName           tagNameToArr  keyName       tagData            return  tagNameToArr     function xmlToArr string  xml         doc   new  DOMDocument         doc- gt loadXML  xml        xpath   new  DOMXPath  doc        tags    doc- gt childNodes   iterator to array  doc- gt childNodes            return domNodesToArray  tags   xpath       Example   php  gt  print json encode xmlToArr   lt root a  5  gt  lt b gt 6 lt  b gt  lt  root gt         root     a   5   b    6

User · Answer

Sorry for answering an old post  but this article outlines an approach that is relatively short  concise and easy to maintain  I tested it myself and works pretty well   http   lostechies com seanbiefeld 2011 10 21 simple-xml-to-json-with-php    lt  php    class XmlToJson       public function Parse   url             fileContents  file get contents  url            fileContents   str replace array   n     r     t         fileContents            fileContents   trim str replace            fileContents             simpleXml   simplexml load string  fileContents            json   json encode  simpleXml            return  json            gt

User · Answer

content   str replace array  quot  n quot    quot  r quot    quot  t quot         response            content   trim str replace   quot     quot   quot    content             xml   simplexml load string  content            json   json encode  xml           return json decode  json TRUE    This worked for me

[php] PHP convert XML to JSON

Examples related to php

Examples related to xml

Examples related to json