#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    UK
    Posts
    76
    Rep Power
    12

    how do i store/retrieve xml data in a relational db ?


    im working on an application that needs to work with xslt stylesheets. i thought the best way to do this would be to store the XML data in a relational database, eg MySQL. and work with it using PHP.

    The intention is to query the MySQL database for data, and have XML generated which can then be XSLT processed.

    Now how do i actually go about doing this please ? i have NO clue whatsoever.


    if someone can provide sample code that would be most excellent (sorry to sound like a ninja turtle, i know theyre old)
  2. #2
  3. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    28
    Rep Power
    0
    well, if you have the information in there, you would need to query the database and get the results, and then have it print out the results in a xml document. I'm not sure about doing that in php. But that is what you'll have to do.

    I'm assuming you want to make like a feed script? And then another script will read the xml data?
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    UK
    Posts
    76
    Rep Power
    12
    erm, whats a feed script ?
  6. #4
  7. No Profile Picture
    Moderator =(8^(|)
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2002
    Location
    Sacramento, CA
    Posts
    1,710
    Rep Power
    14
    Feed script:
    Queries the database and builds a response in xml (versus html, or text, or jpg).

    Then you have another script which calls your feed script and does an xsl transform on the results.

IMN logo majestic logo threadwatch logo seochat tools logo