Create XML child and subchild from MySQL

Posted under » PHP » MySQL on 09 Feb 2021

It's easy to a create JSON but XML take more steps.

We have to take note of XML's idiosyncrasy. Eg. It cannot handle "&" and "<" . Use XML validator to make sure your XML is valid.

XML documents must contain one root element that is the parent of all other elements.

  
      .....
  

XML must have attributes (in this eg. date) in name/value pairs just like in HTML.

  Tove
  Jani