Automatic xml import to mysql database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Locked
nackgr
Forum Newbie
Posts: 11
Joined: Mon Feb 21, 2011 3:22 am

Automatic xml import to mysql database

Post by nackgr »

I have a command like if run it to browser returns a report


https://xml2.domain.com/tsim_xml/servic ... num=number

I wanted to know if there is any way that a program will call this command save the report and import it to desired sql table



xml report like at browser


<records>

<record>
<added>2010-08-09 16:23:41</added>
<type>card</type>
<orderid>308</orderid>
<uname>name</uname>
<address>99.99.2.51</address>
<command>sbalance</command>
<inum>number</inum>
<onum>number</onum>
<balance>11.99 EUR</balance>
<amount>+99.64 EUR</amount>
</record>

<record>
<added>2010-08-09 16:23:41</added>
<type>client</type>
<orderid>308</orderid>
<uname>asd</uname>
<address>99.29.2.51</address>
Locked