XML to ARRAY

[marcobr]

Searching in php books I found a simple solution to transform XML to ARRAY

<!-- articles.xml -->
<?xml version="1.0" ?>
<dev_articles>
	<article id="310">
		<title>Building a Multi-Page Article System With ASP/PHP</title>
		<url>[url]http://www.devarticles.com/art/1/310[/url]</url>
		<doc_type>Tutorial</doc_type>
		<author>
			<name>Mitchell Harper</name>
			<email>[e-mail]</email>
		</author>
		<summary>Interested in building your own CMS? In this article Mitchell shows us how to build...</summary>
		<image>article_310.jpg</image>
		<date_added>20030105011450</date_added>
	</article>
	<article id="309">
		<title>Getting Intimate With PHP&#39;s Mail() Function</title>
		<url>[url]http://www.devarticles.com/art/1/309[/url]</url>
		<doc_type>Tutorial</doc_type>
		<author>
			<name>Steve Knoblock</name>
			<email>[e-mail]</email>
		</author>
		<summary>Interested in sending advanced email using PHP&#39;s mail() function... </summary> 
		<image>article_309.jpg</image>
		<date_added>20030102184303</date_added>
	</article>
</dev_articles>

function fetch_xml($xml){

if(is_file($xml)){
	$xml_data = file_get_contents($xml);
}
else{
	$xml_data = $xml;	
}
$parser = xml_parser_create();
xml_parse_into_struct($parser, $xml_data, &$assoc_arr, &$idx_arr);
xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
$root_tag = $assoc_arr[0]['tag'];
$base_tag = strtolower($assoc_arr[1]['tag']);
$i = 0;
foreach($assoc_arr as $key => $element){
	if($element['tag'] != $root_tag){
		if(!preg_match('/^\s+$/', $element['value'])){
			$tag = strtolower($element['tag']);
			$items[$i][$tag] = $element['value'];
			if($tag == $base_tag){
				$i++;
			}
		}
		elseif(isset($element['attributes'])){
			$items[$i]['id'] = $element['attributes']['ID'];
		}
	}
}

return $items;
}

$items = fetch_xml('articles.xml');

echo '<pre>';
print_r($items);
echo '</pre>';

//Results
Array
(
    [0] => Array
        (
            [id] => 310
            [title] => Building a Multi-Page Article System With ASP/PHP
            [url] => http://www.devarticles.com/art/1/310
            [doc_type] => Tutorial
            [name] => Mitchell Harper
            [email] => [e-mail]
            [author] => 
            [summary] => Interested in building your own CMS? In this article Mitchell shows us how to build...            

            [image] => article_310.jpg
            [date_added] => 20030105011450
            [article] => 
        )

[1] => Array
    (
        [id] => 309
        [title] => Getting Intimate With PHP's Mail() Function
        [url] => http://www.devarticles.com/art/1/309
        [doc_type] => Tutorial
        [name] => Steve Knoblock
        [email] => [e-mail]
        [author] => 
        [summary] => Interested in sending advanced email using PHP's mail() function...
        [image] => article_309.jpg
        [date_added] => 20030102184303
        [article] => 
    )

)

But I still needing your help to improve this code ... :rolleyes:

1) I would like to set keys based in the element level on the tree, for example in articles.xml author element has the child nodes name and email, thus the array keys should be [author_name] and [author_email] instead [name] and[email]. How to improve this in a undefined deep level???

2) How to improve parse to undefined number of attributes for undefined elements???

Regards!!!

[pHaT-aNt_]

hey..

Liked the look of this code, so gave it a go... been looking at the best way to convert xml to php for one of our projects, my indent is to make the array seem as if we've done a query or something..

i've modded the code for use with my own needs, but its still generic, it'll now do name_email like you wanted... and will also add a number to the field if it already exists (the annoying source i had did <address> <line>street</line> <line>county</line> </address>)

anyways, here's the stuff:

<!-- articles2.xml -->
<?xml version="1.0" ?>
<dev_articles>
	<article id="310" status="active">
		<title>Building a Multi-Page Article System With ASP/PHP</title>
		<url>http://www.devarticles.com/art/1/310</url>
		<doc_type>Tutorial</doc_type>
		<author>
			<name>
				<first>Mitchell</first>
				<last>Harper</last>
			</name>
			<email>[e-mail]</email>
		</author>
		<summary>Interested in building your own CMS? In this article Mitchell shows us how to build...</summary>
		<images>
			<image>arcticle_310.jpg</image>
		</images>
		<date_added>20030105011450</date_added>
	</article>
	<article id="309" status="inactive">
		<title>Getting Intimate With PHP's Mail() Function</title>
		<url>http://www.devarticles.com/art/1/309</url>
		<doc_type>Tutorial</doc_type>
		<author>
			<name>
				<first>Steve</first>
				<last>Knoblock</last>
			</name>
			<email>[e-mail]</email>
		</author>
		<summary>Interested in sending advanced email using PHP's mail() function... </summary> 
		<images>
			<image>arcticle_309a.jpg</image>
			<image>arcticle_309b.jpg</image>
			<image>arcticle_309c.jpg</image>
		</images>
		<date_added>20030102184303</date_added>
	</article>
</dev_articles>

here's the function:

function fetch_xml($xml,$root_level){

// Read XML File
if(!($fp = fopen($xml, "r"))){
	die("IO Error $xml_file");
}
while($chunk = fread($fp,4096)){
	$xml_data .= $chunk;
}

// Do the PHP Crap
$parser = xml_parser_create();
xml_parse_into_struct($parser, $xml_data, &$assoc_arr, &$idx_arr);
xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);

// Setup Some VARs
$root_tag = $assoc_arr[$root_level]['tag'];				// Used to define starting node
$base_level = $root_level+1;
$base_tag = strtolower($assoc_arr[$base_level]['tag']); // Used to define base tag
$i = 0;
$prefix = "";

foreach($assoc_arr as $element){
    if($element['tag'] != $root_tag){
		if(!preg_match('/^s+$/', $element['value'])){
            $tag = strtolower($element['tag']);
			if($element['type'] == 'open' && $element['level'] > ($base_level+1)){
				// Add Prefix's for new Tags Under Base
				$tag_prefix[$element['level']] = $tag;
			} elseif($element['type'] == 'close' && $element['level'] > ($base_level+1)){
				// Remove Prefix's when tags closed
				$tag_prefix[$element['level']] = "";
			} elseif($element['type'] == 'complete') {
				// Generate Prefix
				if(count($tag_prefix) > 0){
					$str_prefix = "";
					foreach($tag_prefix as $prefix){
						if(!empty($prefix))
						$str_prefix .= $prefix."_";
					}
				} // End Prefix
				// Add Our Data to the Items Array
				$extra = "";
				while(isset($items[$i][$str_prefix.$tag.$extra])){
					if(empty($extra))
						$extra = 1;
					$extra++;
				}
				$items[$i][$str_prefix.$tag.$extra] = $element['value'];
			}
		}
		if($tag == $base_tag){
        	// Add Our Atttributes
			if(isset($element['attributes']) && $element['type'] == 'open'){
           		$items[$i] = $element['attributes'];
      		}
			// Start New Record
			if($element['type'] == 'close'){
				$i++;
			}
		}
    }
}

return $items;
}

note the new parameter to start at different levels

and the output array:

Array
(
    [0] => Array
        (
            [ID] => 310
            [STATUS] => active
            [title] => Building a Multi-Page Article System With ASP/PHP
            [url] => http://www.devarticles.com/art/1/310
            [doc_type] => Tutorial
            [author_name_first] => Mitchell
            [author_name_last] => Harper
            [author_email] => [e-mail]
            [summary] => Interested in building your own CMS? In this article Mitchell shows us how to build...
            [images_image] => arcticle_310.jpg
            [date_added] => 20030105011450
        )

[1] => Array
    (
        [ID] => 309
        [STATUS] => inactive
        [title] => Getting Intimate With PHP's Mail() Function
        [url] => http://www.devarticles.com/art/1/309
        [doc_type] => Tutorial
        [author_name_first] => Steve
        [author_name_last] => Knoblock
        [author_email] => [e-mail]
        [summary] => Interested in sending advanced email using PHP's mail() function... 
        [images_image] => arcticle_309a.jpg
        [images_image2] => arcticle_309b.jpg
        [images_image3] => arcticle_309c.jpg
        [date_added] => 20030102184303
    )

)

hope this helps in some small way... got it working how i wanted =)

any more ideas?

[prock]

Guys that's amazing.

Now, here's my million dollar question(s), how would you:

1: Sort that, say by id or date added.
2: Edit/Add/Delete an element.

[pHaT-aNt_]

Originally posted by prock
Guys that's amazing.

Now, here's my million dollar question(s), how would you:

1: Sort that, say by id or date added.
2: Edit/Add/Delete an element.

Heh, well for 1: I'll be controlling that on the XML request for my useage, i'll supply the critera then just get feed the results in XML in the correct sorting order... cant help you there.

as for 2, edit/add/delete an element? how'd you mean? - these results will probally be coming from a database via xml, you'd need to add them like a normal DB Insert, is that what you mean?

[bigmad_drongo]

I am using pHat-aNt_s generic code for parsing XML that he posted above to parse the XML provided by SETI@Home so that I might do something more useful with it, but I'm having a couple of problems.

Hee is the XML provided by SETI:

<?xml version="1.0" encoding="iso-8859-1" ?>
<!DOCTYPE userstats SYSTEM "http://setiathome.ssl.berkeley.edu/xml/userstats.dtd">

<userstats>

<userinfo>
	<name><a href="http://www.openbrain.co.uk" target="new">drongo</a></name>
	<numresults>84</numresults>
	<cputime>4101 hr 14 min</cputime>
	<avecpu>48 hr 49 min 27.3 sec</avecpu>
	<resultsperday>0.09</resultsperday>
	<lastresulttime>Mon Mar 17 12:13:16 2003</lastresulttime>
	<regdate>Wed Oct  4 16:39:21 2000</regdate>
	<usertime>    2.452 years</usertime>
</userinfo>
<groupinfo>
	<group><a href="http://setiathome.ssl.berkeley.edu/stats/team/team_89482.html">Team BME</a></group>
</groupinfo>
<rankinfo>
	<rank>784810</rank>
	<ranktotalusers>4326769</ranktotalusers>
	<num_samerank>4309</num_samerank>
	<top_rankpct>18.138</top_rankpct>
</rankinfo>

</userstats>

and here is my output:

Array
(
    [0] => Array
        (
            [name_a] => drongo
            [numresults] => 84
            [cputime] => 4101 hr 14 min
            [avecpu] => 48 hr 49 min 27.3 sec
            [resultsperday] => 0.09
            [lastresulttime] => Mon Mar 17 12:13:16 2003
            [regdate] => Wed Oct  4 16:39:21 2000
            [usertime] =>     2.452 years
        )

[1] => Array
    (
        [group_a] => Team BME
        [rank] => 784810
        [ranktotalusers] => 4326856
        [num_samerank] => 4309
        [top_rankpct] => 18.138
    )

)

As you can see, the html in the 'name' and 'group' tags is being interpreted as XML also. And it seems to me that Array[1] should contain just the group name and there should be an extra key Array[2] which holds the ranking details.

Any advice?

[tomhath]

I'd use xml_parse instead of xml_parse_into_struct and build the desired output in the startElement and endElement functions instead of massaging it afterward. But either way works.

http://www.phpbuilder.com/board/showthread.php?threadid=10232270

[radley]

anyone know why the parser stops when i use <![ CDATA[blahblah<tag>blahbalh</tag>]]>

[cosmoweb]

Marco,

Sou pouco experiente em programação, principalmente php, assim, não consegui aplicar e excutar os códidos descritos por você aqui!

Teria jeito de me passar um modelo para pronta instalação destas aplicacões php que editam, visualizam xml com parse!

Pode ser num arquivo ZIP mesmo, pra mim descompactar e testar . . .

Tenho PHP 4 instalado num servidor Apache! para mim tá dificil até de executar estes arquivos php ele sempre me retorna erros, tem muitos detalhes.

Meu email é cosmoweb @ bol . com.br

Muitissímo Grata de de já! : )

Elen Massoti Schukty,

[klaaz]

I'm new to XML and have tested the above solutions. The're working flawlessly.

But wat I want to do now is put this data in my MySQL table. I tried to create a sql query by adding some lines in the code, but none of it works.

It must be simple but I cannot see the solution. 🙂

Somebody care to help this XML noob?

[brooky]

I get this error 🙁

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of xml_parse_into_struct(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /usr/local/www/vhosts/xx.xx.xx.xx/www.xxxxxxx.com/htdocs/xml/TMPv2nfwzeu9h.php on line 11

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of xml_parse_into_struct(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /usr/local/www/vhosts/xx.xx.xx.xx/www.xxxxxxx.com/htdocs/xml/TMPv2nfwzeu9h.php on line 11

[n_wattam]

Hi,

Very excided to see this code, as i'm in need for something which can output a XML feed to an array, however when copying the code in these posts and putting all in there own files and running i just get a blank screen 🙁

[madwormer2]

http://www.hansanderson.com/php/xml/

Very useful.
Keeps it all in nice order, including tag attributes. If you wish to sort any part of the array, set that individual part into a temporary array, and sort that, and then save it back again.

Any questions? 😛

[n_wattam]

I found that page before i stummbled alone here, but i'm not sure how to set that script up, its just a list of functions, and theres not much info inregards to an example of where to place the xml file etc.???

[madwormer2]

Just include the functions file, so the functions are available to the script, then...

Call up the data from a file using file_get_contents() and then set it to, say, $data, then:

$xml = xmlize($data);

And then $xml will have the array.

It's pretty self explanatory in my opinion.

[n_wattam]

isnt 'file_get_contents' a php5 command??? i'm not sure if this is where i;m going wrong?

Would you be kind enough to send us the files needed as a working example.. 😃 hotmail is darkromz AT hotmail.com or email the files