how to transfer data from XML file to MySql database

[kiranrredy]

Hi,

I need to get the data from XML file , to store it in MySql database.
How can i do it.



Regards,
KiranRredy

[b1randon]

Hi,

I need to get the data from XML file , to store it in MySql database.
How can i do it.



Regards,
KiranRredy

You need to parse the XML structure and run inserts on all of the elements, I think. But you haven't really provided nearly enough information for anyone to help you. What is your XML like? How will it be represented in your DB? What language are you using? If you want help you must provide enough info.

[dalhit]

You need to parse the XML structure and run inserts on all of the elements, I think. But you haven't really provided nearly enough information for anyone to help you. What is your XML like? How will it be represented in your DB? What language are you using? If you want help you must provide enough info.

Hi

Suppose i have standard table EMP in Oracle 9i DB.

So can you give me complete code listing which i just have to execute & get data into XML

or

link from where i can get it.

Also i installed in Oracle 9i Database But do i have to install anything for XML.

Folks can reply me at [e-mail]

Thanks for reply.

[dorinbogdan]

Hi,
Did you succeed to solve the problem ?
If yes, please let me know, in order to close the thread.
Thanks,
Dorin.

[IamMacro]

Im looking for a similar solution to this.

Im not entirely new to XML but im still a bit puzzled.
Im using a Vb.net program on a Pocket PC to create a xml file which should be uploaded to a PHP mysql server , how should i create my XML file that users can just click a button and the xml files get uploaded to the server (using HTTP)
The server's IP in the internal netwerk = 192.168.25.120

I'll Be sending my updated status of the Pocket pc's database to the mysql server , so the Php webserver should parse the xml data and insert or update what i have on my pocket Pc database.

Should i be using RPC-XML or SOAP with the Post method if so can someone give a small example on how to make the connection with that IP adress ?

Thx.

[gomzi]

suppose i have a couple of feeds and i want to store them in mysql at regular intervals, then how should i go about it?

i.e. every 30 minutes i want those two feeds to be read and stored in the database.

also please specify the best method for reading the feeds.

[dorinbogdan]

Depending on what language you are programming (ASP, PHP, .Net...) you can read the XML data (Rss is an xml file) using for instance an XMLDOM object.
For how to read an XML see:
PHP example, or
ASP/Javascript example.

About how to import XML in MySql, see this thread.

I hope these helps.
If need more PHP help, please post on PHP forum.

Thanks,
Dorin.

[ayselozden]

hi.I have a problem about xml data transfer.I read some solutions in this category.but I couldn't solved my problem .that is my problem:

<STKpp MalKodu="A4MSI_02" MalAdi="MSI (7104) PM8M-V 478p,8XDDR-400,VGA+SES+LAN" Stok="10+"
BIZIMFiyat="41.5" Marka="06"
BayiFiyat="41.5" DovizKod="USD" VergiKod="KDV18" Kategori="06c"
MarkaID="2"
/>
 
<STOKOZELLIKLER>
<OZELLIKLER>
<OZELLIK>garanti süresi</OZELLIK>
<DEGER>24</DEGER>
<OZELLIK>front side bus (MHz)</OZELLIK>
<DEGER>400</DEGER>
<OZELLIK>agp yuvasi</OZELLIK>
<DEGER>8x</DEGER>
</OZELLIKLER>
</STOKOZELLIKLER>

that you see above,datas which I want to transfer mysql database.

I waiting for your help.thanks