{"id":552,"date":"2008-11-17T19:55:38","date_gmt":"2008-11-17T19:55:38","guid":{"rendered":"http:\/\/west-penwith.org.uk\/blog\/?p=552"},"modified":"2014-04-11T18:27:57","modified_gmt":"2014-04-11T17:27:57","slug":"parsing-xml-with-php","status":"publish","type":"post","link":"https:\/\/west-penwith.org.uk\/blog\/archives\/552","title":{"rendered":"Parsing XML with PHP"},"content":{"rendered":"

Following on from the last.fm saga described earlier<\/a>, I went on to look at the method user.GetWeeklyAlbumChart<\/code> which requires accessing user.GetWeeklyChartList<\/code> first.<\/p>\n

I am using the plugin iLast.Fm<\/a> from Leandro Alonso and the code he is using looks right but doesn’t seem to work. He uses curl<\/code> to get the XML from the last.fm<\/code> site. The XML you get is of the form<\/p>\n

\n

\n<lfm status=\"ok\">
\n <weeklychartlist user=\"[username]\">
\n <chart from=\"1225022400\" to=\"1225627200\"\/>
\n <chart from=\"1225627200\" to=\"1226232000\"\/>
\n <chart from=\"1226232000\" to=\"1226836800\"\/>
\n <\/weeklychartlist>
\n<\/lfm><\/code>\n<\/p>\n<\/blockquote>\n

He then parses it with simplexml_load_file()<\/a><\/code> and puts it into an object called $chart<\/code>. Then the code processes this as follows<\/p>\n

\n

\n$chartopt = sizeof($chart->weeklychartlist->chart) - 1;
\n$chart = $chart->weeklychartlist->chart[$chartopt];<\/code>\n<\/p>\n<\/blockquote>\n

and uses $chart['from']<\/code> and $chart['to']<\/code> in the call to user.GetWeeklyAlbumChart<\/code>.<\/p>\n

The problem is that $chartopt<\/code> always has the value 0 which means that the sizeof()<\/code> function is not working properly. There is a comment on the PHP documenattion page<\/a> which says that foreach<\/code> doesn’t work but reccomends count\/sizeof()<\/code> instead. What can be wrong?<\/p>\n

Update: The answer seems to be here<\/a>: SimpleXML is not so simple and it doesn’t behave correctly. It needs<\/p>\n

\n

\n$chartopt = -1;
\nforeach($chart->weeklychartlist->chart as $i) $chartopt++;
\n<\/code>\n<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Following on from the last.fm saga described earlier, I went on to look at the method user.GetWeeklyAlbumChart which requires accessing user.GetWeeklyChartList first. I am using the plugin iLast.Fm from Leandro Alonso and the code he is using looks right but doesn’t seem to work. He uses curl to get the XML from the last.fm site. […]<\/p>\n","protected":false},"author":239,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,5,10],"tags":[],"class_list":["post-552","post","type-post","status-publish","format-standard","hentry","category-hi-fi","category-technical","category-wordpress"],"_links":{"self":[{"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/posts\/552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/users\/239"}],"replies":[{"embeddable":true,"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/comments?post=552"}],"version-history":[{"count":3,"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/posts\/552\/revisions"}],"predecessor-version":[{"id":1755,"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/posts\/552\/revisions\/1755"}],"wp:attachment":[{"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/media?parent=552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/categories?post=552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/west-penwith.org.uk\/blog\/wp-json\/wp\/v2\/tags?post=552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}