{"id":133,"date":"2010-10-06T01:03:35","date_gmt":"2010-10-05T23:03:35","guid":{"rendered":"http:\/\/unckel.com\/blog\/?p=133"},"modified":"2019-12-07T22:03:15","modified_gmt":"2019-12-07T21:03:15","slug":"xml-zu-json-umwandeln-mit-php","status":"publish","type":"post","link":"https:\/\/unckel.de\/blog\/xml-zu-json-umwandeln-mit-php\/","title":{"rendered":"XML zu JSON umwandeln mit PHP"},"content":{"rendered":"

Hier ein einfaches Beispiel, wie aus folgender XML-Datei \u00fcber das Attribut ‚id‘ ein Datensatz gelesen, und als Antwort ein JSON-Objekt zur\u00fcck geliefert wird.<\/p>\n

<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<articles>\n<article id=\"1\">\n  <artid>A1001<\/artid>\n  <descr>Description here<\/descr>\n  <price>12.89<\/price>\n<\/article>\n<article id=\"2\">\n  <artid>B2002<\/artid>\n  <descr>Description here<\/descr>\n  <price>8.49<\/price>\n<\/article>\n<\/articles><\/pre>\n
Per XPATH werden alle Knoten ‚article‘ mit dem Attribut id = 2 selektiert. (Sollte in diesem Beispiel eindeutig sein, d.h. der Prim\u00e4rschl\u00fcssel.)<\/p>\n
<?php\nheader(\"Content-type: application\/json\");\necho \"{\";\n\nif (isset($_GET[\"id\"])) {\n  \n  $xml = simplexml_load_file(\"data.xml\"); \n\t\n  foreach($xml->xpath(\"\/\/article[\" . $_GET[\"id\"] . \"]\") as $item) {\n    echo \"\\\"artid\\\":\\\"\" . $item->artid . \"\\\",\";\n    echo \"\\\"descr\\\":\\\"\" . htmlspecialchars($item->descr) . \"\\\",\";\n    echo \"\\\"price\\\":\"   . $item->price . \"\";\t\t\n  } \n}\nelse {\n  echo \"\\\"error\\\":\\\"no data\\\"\";\n}\n\necho \"}\";\n?><\/pre>\n
Die Antwort zur ID 2 ist ein JSON-Objekt:<\/p>\n
{\n  \"artid\": \"B2002\",\n  \"descr\": \"Description here\",\n  \"price\":  8.49\t\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"
Hier ein einfaches Beispiel, wie aus folgender XML-Datei \u00fcber das Attribut ‚id‘ ein Datensatz gelesen, und als Antwort ein JSON-Objekt zur\u00fcck geliefert wird. <?xml version=“1.0″ encoding=“utf-8″?> <articles> <article id=“1″> <artid>A1001<\/artid> <descr>Description here<\/descr> <price>12.89<\/price> <\/article> <article id=“2″> <artid>B2002<\/artid> <descr>Description here<\/descr> <price>8.49<\/price> <\/article> <\/articles> Per XPATH werden alle Knoten ‚article‘ mit dem Attribut id = 2 selektiert. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[],"class_list":["post-133","post","type-post","status-publish","format-standard","hentry","category-webdesign"],"_links":{"self":[{"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":1,"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"predecessor-version":[{"id":783,"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/posts\/133\/revisions\/783"}],"wp:attachment":[{"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unckel.de\/blog\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}