Extract part of Xml document & convert it to Json in PHP -
i need save part of following xml document , convert json - that, nodes "row" data in it.
<?xml version="1.0" encoding="utf-8"?> <report> <table> <row device="mobile devices full browsers" cost="3940000" avgposition="2.0" avgcpc="3940000" ctr="100.00%" clicks="1" impressions="1" convertedclicks="0" searchterm="purple jeep near elgin sale" keyword="jeepdealership" campaignstate="enabled" adgroupid="7751248218" campaign="zeigler cdj_dealer campaign" campaignid="134270778"/> <row device="mobile devices full browsers" cost="3930000" avgposition="1.0" avgcpc="3930000" ctr="100.00%" clicks="1" impressions="1" convertedclicks="0" searchterm="jeep wrangler rubicon 2015" keyword="jeepdealership" campaignstate="enabled" adgroupid="7751248218" campaign="zeigler cdj_dealer campaign" campaignid="134270778"/> <row device="mobile devices full browsers" cost="2010000" avgposition="3.0" avgcpc="2010000" ctr="100.00%" clicks="1" impressions="1" convertedclicks="0" searchterm="altitute jeep cherokee" keyword="2015 jeep cherokee" campaignstate="enabled" adgroupid="18188246418" campaign="zeigler cdj_targeted campaign" campaignid="134270898"/> <row device="mobile devices full browsers" cost="3990000" avgposition="1.0" avgcpc="3990000" ctr="100.00%" clicks="1" impressions="1" convertedclicks="0" searchterm="2012 jeep cherokee" keyword="2015 +jeep +cherokee" campaignstate="enabled" adgroupid="18188246418" campaign="zeigler cdj_targeted campaign" campaignid="134270898"/> </table>
here code:
$doc = new domdocument; $doc->load('report.xml'); $node = $doc->documentelement; $subnodes = $node->getelementsbytagname('row'); $json = json_encode($node->savexml($subnodes));
here trying extract nodes of xml has "row", , convert json.
the error getting following:
fatal error: call undefined method domelement::savexml() in c:\php \optima\adwords-examples-and-lib-8.1.0\examples\adwords\v201601\reporting \downloadcriteriareportwithawql.php on line 130
any direction appreciated.
$xml = simplexml_load_file('report.xml'); $json = json_decode(json_encode($xml->table))->row;
this give array of rows each rows data stored in json object.
Comments
Post a Comment