Page 1 of 1

Automatic xml import to mysql database

Posted: Tue Mar 29, 2011 5:34 am
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>