TalkPHP - View Single Post - Generating XML from a Mysql DB with PHP's DOM functions (part Two)

frosty · 08-19-2008, 07:45 PM

Found this to be quite informative...
One question though what if I, oh lets say, have lots and lots of tags to be delt with…

Like

Code:

<RetRequest>
	<Login>
		<uName></uName>
		<uId></uId>
	</Login>
	<InfoBlock>
		<Bits>
			<bitOne></bitOne>
			<bitTwo></bitTwo>
		</Bits>
		<Bits>
			<bitOne></bitOne>
			<bitTwo></bitTwo>
		</Bits>
		<Bits>
			<bitOne></bitOne>
			<bitTwo></bitTwo>
		</Bits>
		<Bits>
			<bitOne></bitOne>
			<bitTwo></bitTwo>
		</Bits>
		<Bits>
			<bitOne></bitOne>
			<bitTwo></bitTwo>
		</Bits>
	</InfoBlock>
	<LastBlock>
		<MoreBits>
			<mBits>
				<mBitOne></mBitOne>
				<mBitTwo></mBitTwo>
			</mBits>
			<mBits>
				<mBitOne></mBitOne>
				<mBitTwo></mBitTwo>
			</mBits>
			<mBits>
				<mBitOne></mBitOne>
				<mBitTwo></mBitTwo>
			</mBits>
		</MoreBits>
	</LastBlock>
</RetRequest>

But on the order of 50 or so parent tags 100's of child tags, pulling information form 20 tables in 2 db's...

(Its the current problem that I am having...getting all the stored variables, and generating the xml string. Can do it just fine storing in session but can not get it to work out of the bd...)