Extract from DB to XML

Question

I have made a website where users can choose some regions on Google Maps, and save them into a database with a name an a description. What I need now is to be able to take the saved entries from my DB and show them also to an android app I have made with google maps. I am new to all these and from my research I understand that I should extract my data from the DB to an XML file and then parse them on the phone. For doing the first part I should use the following code, if I am not mistaken:

SELECT column1, column2,..
FROM tablename
FOR XML PATH;

What I still dont get is where should I put that piece of code? In a new file? All by itself? And with that code the XML file will be created, or should I do something else too? Thank you

Community · Accepted Answer · 2017-05-23 12:16:48Z

0

Well since noone answered my question and I did find the solution I'll post it here. The answer is via PHP, XMLWriter. There is a question here that helped but I wasnt able to find from the beginning since I didnt know what to search for.

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Jan 30, 2017 at 12:09

lena

671 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract from DB to XML

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related