XSL,XML and mySQL?

[allywilson]

Yo,
I'm quite new to XSL/XML and mySQL. I was wondering if it was possible to use all three in conjunction?

I like using XSL to call forth data from an XML document, so is it possible to get it to call the data forth from a mySQL DB? Or....is it possible to get the XSL to call forth data from the XML document - which in turn comes from a mySQL DB?

I've not even thought of a practical application yet for this, just an idea (so that maybe I can use it in later projects).

One reason I'm asking is that I heard I can't write to the XML documents just using XSL - one way around this I suppose is to be able to write it to the mySQL and therefore have the XML updated automatically....?

If anyone has some ideas, please let me know!

Cheers,


~A~

 

[CubeE101]

You can export data from SQL (or MySQL) in the format of XML...

Then transform the data with XSL into a different XML file or display it as an HTML (or XHTML) page...

Is that what you are asking?

What do you mean write to the XML with XSL...

XSL is like a filter for XML...

XML --> XSL --> Different XML

an HTML page just happens to be a form of XML...

You can use DOM to do stuff like...

Load an XML file into a DOM (Document Object Model)
Load an XSL file into a DOM
Then transform the XML file with the XSL file...
Then save the result as a second XML file... (or to the original)

Here is a good starting point:

http://www.w3schools.com/xsl/xsl_client.asp

I have not yet worked with MySQL yet...
I have worked with MQL which is simular but specific to Matrix PDM, which is another story...

There is a server side tutorial as well...

http://www.w3schools.com/xsl/xsl_server.asp

Hope This Helps...
-Josh

Visit My Site
PROGRAMMER: Red-eyed, mumbling mammal capable of conversing with inanimate objects.