Is it possible to generate xml from a sql server database using php?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mike klausmeyer
    New Member
    • Jan 2011
    • 1

    Is it possible to generate xml from a sql server database using php?

    I have searched for help with code to generate xml from sql server database using php and can't find a solution.
    Has anyone done this that can help me?
    Thank you in advance.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    This is more of a PHP question, than a SQL Server question.

    Good Luck!!!

    ~~ CK

    Comment

    • Oralloy
      Recognized Expert Contributor
      • Jun 2010
      • 988

      #3
      mike,

      Of course you can.

      Outline what you need to generate.
      Build the appropriate queries.
      Run the queries.
      Error check.
      Build the XML.
      Transmit the XML.

      Fairly simple, over all.

      The devil will be in the details - for example, "SML escaping" the database values before putting them in the output stream.

      Perhaps the first thing you should do, though, is to create a trivial file that emits a canned XML document. Once you get that working, the rest is easy, peasy.

      Merry New Year,
      Oralloy

      Comment

      Working...