Working with PHP, XML, MySQL

[Aggelos]

Hello,
I am having an XML file that contains booking details. These booking
details are supposed to get gennerated from a booking application.
I then need to build a system that will process those XML files and
store them inside a MySQL DB using PHP.
Is there any standard methodology to do such thing ?

IS there a class I should use to make my life easier?
The ideal situation would be to somehow achieve storing the XML
elements inside a multidimensional array and then insert them in the
DB...

Can you point me in the right direction please ? I 've never dealt
with XML parsing.

Thanks in advance.

[Andrew Taylor]

On 2007-03-02 10:43:55 +0000, "Aggelos" <dj*****@gmail.comsaid:

Hello,
I am having an XML file that contains booking details. These booking
details are supposed to get gennerated from a booking application.
I then need to build a system that will process those XML files and
store them inside a MySQL DB using PHP.
Is there any standard methodology to do such thing ?

IS there a class I should use to make my life easier?
The ideal situation would be to somehow achieve storing the XML
elements inside a multidimensional array and then insert them in the
DB...

Can you point me in the right direction please ? I 've never dealt
with XML parsing.

http://www.php.net/xml

http://www.php.net/SimpleXML

Hope this helps

Andrew

[Aggelos]

On Mar 2, 1:40 pm, Andrew Taylor wrote:

On 2007-03-02 10:43:55 +0000, "Aggelos" <[e-mail]:

Hello,
I am having an XML file that contains booking details. These booking
details are supposed to get gennerated from a booking application.
I then need to build a system that will process those XML files and
store them inside a MySQL DB using PHP.
Is there any standard methodology to do such thing ?

IS there a class I should use to make my life easier?
The ideal situation would be to somehow achieve storing the XML
elements inside a multidimensional array and then insert them in the
DB...

Can you point me in the right direction please ? I 've never dealt
with XML parsing.

http://www.php.net/xml

http://www.php.net/SimpleXML

Hope this helps

Andrew

That requires PHP5 :S is there something for PHP4 ?

[NC]

On Mar 2, 2:43 am, "Aggelos" <[e-mail]:

>
I am having an XML file that contains booking details. These booking
details are supposed to get gennerated from a booking application.
I then need to build a system that will process those XML files and
store them inside a MySQL DB using PHP.
Is there any standard methodology to do such thing ?

No. There are many PHP extensions that can be used to parse XML.
Since you mentioned later in the thread that you are using PHP 4,
here are two extensions that work with PHP 4:

http://www.php.net/XML
http://www.php.net/DOMXML

Cheers,
NC

[Aggelos]

On Mar 2, 3:22 pm, "NC" <[e-mail]:

On Mar 2, 2:43 am, "Aggelos" <[e-mail]:

I am having an XML file that contains booking details. These booking
details are supposed to get gennerated from a booking application.
I then need to build a system that will process those XML files and
store them inside a MySQL DB using PHP.
Is there any standard methodology to do such thing ?

No. There are many PHP extensions that can be used to parse XML.
Since you mentioned later in the thread that you are using PHP 4,
here are two extensions that work with PHP 4:

http://www.php.net/XMLhttp://www.php.net/DOMXML

Cheers,
NC

I've used miniXML which works quite well, but I am getting some weird
NOTICES
Notice: Only variable references should be returned by reference in /
PATH/TO/DIR/miniXml/classes/element.inc.php on line 610

:s
but i still have some problems as the XML structure has multiple
elements with the same name but different attributes

e.g.
+ <Supplier>
+ <Originator>
+ <PassengerDetail p="1">
+ <PassengerDetail p="2">
+ <PassengerDetail p="3">

and I don't know how to put these an array

array[PassengerDetail][1]
array[PassengerDetail][2]
array[PassengerDetail][3]

thank you.