Kevin, would you mind sending the particular url w/ the content you are referring to? also, data doesnt necessarily need to go through xml on its way back to the database. consider a web form for instance which might submit data to your application via HTTP POST. in that case you could simply process the data in a familiar way and insert / update or whatever, the database as appropriate. aside from that if you wanted to send XML elements to the database you could do so in one of several ways. the XML could be stored natively of course, but i think what youre asking about is getting the contents of a particular tag, say, and insert that into a particular field in a table. to accomplish this use SimpleXML or DOM to parse the XML and traverse to the node whose data you mean to insert (or update or whatever) into the database; store it in a variable and use it in a query at a later point in the code. -nathan On 7/9/07, Kelvin Park <kelvinpark86@xxxxxxxxx> wrote:
One of his tutorials explained how to transfer MySQL data to XML, however obviously the data is not always static, it needs to be changed sending the data back to MySQL through XML. Do you know how to send XML elements back in to MySQL database? Thanks! On 7/9/07, Nathan Nobbe <quickshiftin@xxxxxxxxx> wrote: > > i havent had time to fully explore the material from Tony yet, but so > far ive been building XML entirely in memory rather than reading in a > complete file, parsing it and placing data at certain points. one thing i > would like to explore is either DTDs or XMLSchema to validate the XML > against. in that case even w/ the approach i currently take there would > still be files on disk. as long as said XML files have practical permissions > i dont think having them on disc is a great security risk. > > -nathan > > On 7/9/07, Kelvin Park < kelvinpark86@xxxxxxxxx> wrote: > > > > Since XML is just a text document, wouldn't it raise security issues > > if all data was transferred to XML files? > > > > On 7/9/07, Kelvin Park < kelvinpark86@xxxxxxxxx> wrote: > > > > > > absolutely!, thanks > > > > > > On 7/9/07, Nathan Nobbe <quickshiftin@xxxxxxxxx > wrote: > > > > > > > > Tony, > > > > > > > > this material looks quite excellent; thanks for sharing. > > > > > > > > -nathan > > > > > > > > On 7/9/07, Tony Marston < tony@xxxxxxxxxxxxxxxxxxxxxxxx> wrote: > > > > > > > > > > Try these for size: > > > > > http://www.tonymarston.net/php-mysql/domxml.html and > > > > > http://www.tonymarston.net/php-mysql/sablotron.html > > > > > http://www.tonymarston.net/php-mysql/dom.html and > > > > > http://www.tonymarston.net/php-mysql/xsl.html > > > > > > > > > > There is also a sample application available at > > > > > http://www.tonymarston.net/php-mysql/sample-application.html which > > > > you can > > > > > download with all the necessary code. > > > > > > > > > > -- > > > > > Tony Marston > > > > > http://www.tonymarston.net > > > > > http://www.radicore.org > > > > > > > > > > ""Kelvin Park"" <kelvinpark86@xxxxxxxxx> wrote in message > > > > > news:d1ace2e20707090141p63050dbfy3be12208f89af53@xxxxxxxxxxxxxxxxx > > > > > > > > > > I'm using XSLT to make a website template and XML to describe > > > > the data > > > > > on > > > > > > my > > > > > > website. Do I parse the data from MySQL to XML in order to > > > > apply styles > > > > > > and > > > > > > display them as XHTML with XSLT? > > > > > > > > > > > > I would have to use PHP to parse XML, however I was unclear on > > > > how to > > > > > pass > > > > > > MySQL data to XML in order for it do be displayed through XSLT > > > > template. > > > > > > Do you know a good reference (website, book, article) for the > > > > most > > > > > correct > > > > > > way to display MySQL data with XML/XSLT/PHP? > > > > > > > > > > > > > > > > -- > > > > > PHP General Mailing List ( http://www.php.net/) > > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > > > > > > > > > >
