Results 1 to 4 of 4

Thread: MySQL and XML

  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: MySQL and XML

    I've recently completed two projects -- the first was a phpBB extension utilizing new querys with MySQL and the second was an ASP utilizing SQLServer 2000 with XML and XSL transforms.
    I am onto a new project and would love to utilize PHP and MySQL where the result set from MySQL is in XML format so that I can process it with XSL transforms. SQLServer 2000 can return an XML formatted result set and I found this ideal for my last project -- can MySQL do the same or is there a PHP class out there that will take a MySQL result set and convert it to XML?

    TIA,

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    When starting the mysql client program, add the option -X and
    your output will be formatted as XML.

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Thanx very much

    I am not using the mysql client utility but instead connecting to the server and running queries from a PHP application.

    Can I get XML like the mysql client program is?

  4. #4
    Join Date
    Nov 2003
    Posts
    91
    As far as I'm aware, XML output is only provided by the mysql
    client program and the mysqldump program, not the server itself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •