Automatic xml import to mysql database
Posted: Tue Mar 29, 2011 5:34 am
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>
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>