Query on XML document

amber.long83 · 06-23-2009, 04:55 AM

Hi friends

I am working with PHP5 and have a requirement to select xml node on the base of parameter. My xml contains the list of country and it has child node of state list. Like this

HTML Code:

<?xml version="1.0" encoding="utf-8"?>
<country_list>
	<country id="US">
		<state>NY</state>
		<state>CA</state>
		<state>NJ</state>		
	</country>
	<country id="AU">
		<state>New South Wales</state>		
		<state>Victoria</state>				
		<state>Queensland</state>						
	</country>	
</country_list>

I want to get the xml like
????: NamePros.com http://www.namepros.com/programming/591829-query-on-xml-document.html

HTML Code:

<country id="AU">
		<state>New South Wales</state>		
		<state>Victoria</state>				
		<state>Queensland</state>						
	</country>

Can anyone help me how can I achieve this?

thanks in advance.

Bruce_KD · 06-23-2009, 08:13 AM

PHP Code:

  <?php

 
header('Content-type: text/xml');

 
$xml = new SimpleXMLElement('<?xml version="1.0"?><country_list> </country_list>');

$country = $xml->addChild('country');

$country->addAttribute('id', 'US');

????: NamePros.com http://www.namepros.com/showthread.php?t=591829
 
$country->addChild('state', 'NY');

$country->addChild('state', 'CA');

$country->addChild('state', 'NJ');

 
echo $xml->asXML();

 
?>

Untested but modified from previous code.

Bruce

06-23-2009, 04:55 AM	THREAD STARTER #1 (permalink)
amber.long83 First Time Poster! Join Date: Jun 2009 Posts: 1	Query on XML document Hi friends I am working with PHP5 and have a requirement to select xml node on the base of parameter. My xml contains the list of country and it has child node of state list. Like this HTML Code: <?xml version="1.0" encoding="utf-8"?> <country_list> <country id="US"> <state>NY</state> <state>CA</state> <state>NJ</state> </country> <country id="AU"> <state>New South Wales</state> <state>Victoria</state> <state>Queensland</state> </country> </country_list> I want to get the xml like ????: NamePros.com http://www.namepros.com/programming/591829-query-on-xml-document.html HTML Code: <country id="AU"> <state>New South Wales</state> <state>Victoria</state> <state>Queensland</state> </country> Can anyone help me how can I achieve this? thanks in advance. __________________ Magento Developer

06-23-2009, 08:13 AM	#2 (permalink)
Bruce_KD NamePros Member Join Date: Sep 2006 Posts: 99	PHP Code: `<?php header('Content-type: text/xml'); $xml = new SimpleXMLElement('<?xml version="1.0"?><country_list> </country_list>'); $country = $xml->addChild('country'); $country->addAttribute('id', 'US'); ????: NamePros.com http://www.namepros.com/showthread.php?t=591829 $country->addChild('state', 'NY'); $country->addChild('state', 'CA'); $country->addChild('state', 'NJ'); echo $xml->asXML(); ?>` Untested but modified from previous code. Bruce __________________ Need a CAPTCHA? www.KingdomsDivided.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complete XML parser	Barrucadu	CODE	0	01-04-2009 07:35 AM
Help setting up HTTP XML Feed	James B	Programming	4	02-18-2008 01:53 AM
encrypt and decrypt query string	sales@vannova.com	Programming	5	06-07-2007 12:45 AM
XML API SOAP Installation	Billy!	Web Development Wanted	0	05-08-2007 07:56 AM
Site conversion from mysql to XML	Chuppa	Programming	5	10-14-2006 05:50 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)