This post show how to convert XML to JSON using PHP code.<\/p>\n\n\n\n
json_encode() function converts valid XML to JSON<\/strong><\/p>\n\n\n\n Following is example:<\/p>\n\n\n\n In this example, we have an empty data.json file and a data.xml with the following content<\/p>\n\n\n\n data.xml<\/strong><\/p>\n\n\n\n The following code will read this XML file, generate JSON and output it to data.json file.<\/p>\n\n\n\n Line 1: opens data.json file with \u201cw\u201d option meaning you can write content to it<\/p>\n\n\n\n Line 2: opens data.xml file and loads its data. Note the use of simple_load_file()<\/strong> function.<\/p>\n\n\n\n Line 3: converts XML to JSON and writes the JSON into data.json file. Note the use of json_encode()<\/strong> function to convert data.<\/p>\n\n\n\n Line 4: closes data.json file for writing<\/p>\n\n\n\n data.json<\/strong><\/p>\n\n\n\n This post show how to convert XML to JSON using PHP code. json_encode() function converts valid XML to JSON Following is example: In this example, we have an empty data.json file and a data.xml with the following content data.xml <staff> <employee> <name id=”1″>Alice<\/name> <dob>January 1, 2000<\/dob> <\/employee> <employee> <name id=”2″>Bob<\/name> <dob>December 31, 2000<\/dob> <\/employee> <\/staff> […]<\/p>\n","protected":false},"author":1,"featured_media":1207,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[423,424,422],"class_list":["post-1164","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-data-format-conversion-in-php","tag-php-programming-tips","tag-php-xml-to-json-conversion"],"_links":{"self":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/comments?post=1164"}],"version-history":[{"count":1,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1164\/revisions"}],"predecessor-version":[{"id":1165,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1164\/revisions\/1165"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media\/1207"}],"wp:attachment":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media?parent=1164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/categories?post=1164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/tags?post=1164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<staff>\r\n <employee>\r\n <name id=\"1\">Alice<\/name>\r\n <dob>January 1, 2000<\/dob>\r\n <\/employee>\r\n <employee>\r\n <name id=\"2\">Bob<\/name>\r\n <dob>December 31, 2000<\/dob>\r\n <\/employee>\r\n<\/staff><\/pre>\n\n\n\n
<?php\r\n $myJSON = fopen(\"data.json\", \"w\");\r\n $myXML = simplexml_load_file(\"data.xml\");\r\n fwrite($myJSON, json_encode($myXML));\r\n fclose($myJSON);\r\n?><\/pre>\n\n\n\n
{\r\n \"staff\": {\r\n \"employee\": [\r\n {\r\n \"name\": {\r\n \"-id\": \"1\",\r\n \"#text\": \"Alice\"\r\n },\r\n \"dob\": \"January 1, 2000\"\r\n },\r\n {\r\n \"name\": {\r\n \"-id\": \"2\",\r\n \"#text\": \"Bob\"\r\n },\r\n \"dob\": \"December 31, 2000\"\r\n }\r\n ]\r\n }\r\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"