|
|
Posted by Peter van Schie on 07/18/05 22:53
Bob Bedford wrote:
> Thanks for reply Peter,
>
> This is the problem, I've this structure (simplified)
>
> <data1>
> <group1>
> <field1>
> </field1>
> <field2>
> </field2>
> </group1>
> <group2>
> <field1>
> </field1>
> </group2>
> </data1>
>
> and of course, group number is undefined and field number in each group
> is also undefined.
> What's the best approach ? for now I use xml_parser_create and check
> manually everything.
>
> but if I find a better way to handle datas, probably It will be simpler
> to parse and save datas in the database,
Hi Bob,
Well, that's what I meant by nested data. That is a lot trickier.
There are database engines that support native xml data on which you can
use XQuery queries. An example is eXist (http://exist.sourceforge.net/).
But I think you mentioned you want to use MySQL to store the data right?
I did read something about MySQL 5 going to support XPath too, but
that's not 100% sure yet last time I checked.
So for now it's a tough problem to solve with MySQL I'm afraid.
--
http://www.phpforums.nl
Navigation:
[Reply to this message]
|