使用了php的PEAR和DB <?php // +----------------------------------------------------------------------+ // | PHP version 4.0                                                       |// +----------------------------------------------------------------------+ // | Copyright (c) 1997, 1998, 1999, 2000, 2001 The PHP Group              |// +----------------------------------------------------------------------+ // | This source file is subject to version 2.0 of the PHP license,        |// | that is bundled with this package in the file LICENSE, and is         |// | available at through the world-wide-web at                            |// | http://www.php.net/license/2_02.txt.                                  |// | If you did not receive a copy of the PHP license and are unable to    |// | obtain it through the world-wide-web, please send a note to           |// | license@php.net so we can mail you a copy immediately.                |// +----------------------------------------------------------------------+ // | Authors: Christian Stocker <chregu@phant.ch>                          |// +----------------------------------------------------------------------+ // // $Id: sql2xml.php,v 1.59 2001/11/13 10:54:02 chregu Exp $ /** * This class takes a PEAR::DB-Result Object, a sql-query-string or an array *  and returns a xml-representation of it. * * TODO *   -encoding etc, options for header *   -ERROR CHECKING * * Usage example * * include_once ("DB.php"); * include_once("XML/sql2xml.php"); * $db = DB::connect("mysql://root@localhost/xmltest"); * $sql2xml = new xml_sql2xml(); * //the next one is only needed, if you need others than the default * $sql2xml->setEncoding("ISO-8859-1","UTF-8"); * $result = $db->query("select * from bands"); * $xmlstring = $sql2xml->getXML($result); * * or * * include_once ("DB.php"); * include_once("XML/sql2xml.php"); * $sql2xml = new xml_sql2xml("mysql://root@localhost/xmltest"); * $sql2xml->Add("select * from bands"); * $xmlstring = $sql2xml->getXML(); * * More documentation and a tutorial/how-to can be found at *   http://php.chregu.tv/sql2xml * * @author   Christian Stocker <chregu@bitflux.ch> * @version  $Id: sql2xml.php,v 1.59 2001/11/13 10:54:02 chregu Exp $ * @package  XML */ class XML_sql2xml {     /**     * If joined-tables should be output nested.     *  Means, if you have joined two or more queries, the later     *   specified tables will be nested within the result of the former     *   table.     *   Works at the moment only with mysql automagically. For other RDBMS     *   you have to provide your table-relations by hand (see user_tableinfo)     *     * @var  boolean     * @see  $user_tableinfo, doSql2Xml(), doArray2Xml();     */     var $nested = True;     /**     * Name of the tag element for resultsets     *     * @var  string     * @see  insertNewResult()     */     var $tagNameResult = "result";     /**     * Name of the tag element for rows     *     * @var  string     * @see  insertNewRow()     */     var $tagNameRow = "row";     /**     *     * @var   object PEAR::DB     * @access private     */     var $db = Null;     /**     * Options to be used in extended Classes (for example in sql2xml_ext).     * They are passed with SetOptions as an array (arrary("user_options" = array());     *  and can then be accessed with $this->user_options["bla"] from your     *  extended classes for additional features.     *  This array is not use in this base class, it's only for passing easy parameters     *  to extended classes.     *     * @var      array     */     var $user_options = array();     /**     * The DomDocument Object to be used in the whole class     *     * @var      object  DomDocument     * @access    private     */     var $xmldoc;     /**     * The Root of the domxml object     * I'm not sure, if we need this as a class variable....     * could be replaced by domxml_root($this->xmldoc);     *     * @var      object DomNode     * @access    private     */     var $xmlroot;     /**     * This array is used to give the structure of your database to the class.     *  It's especially useful, if you don't use mysql, since other RDBMS than     *  mysql are not able at the moment to provide the right information about     *  your database structure within the query. And if you have more than 2     *  tables joined in the sql it's also not possible for mysql to find out     *  your real relations.     *  The parameters are the same as in fieldInfo from the PEAR::DB and some     *   additional ones. Here they come:     *  From PEAR::DB->fieldinfo:     *     *    $tableInfo[$i]["table"]    : the table, which field #$i belongs to.     *           for some rdbms/comples queries and with arrays, it's impossible     *           to find out to which table the field actually belongs. You can     *           specify it here more accurate. Or if you want, that one fields     *           belongs to another table, than it actually says (yes, there's     *           use for that, see the upcoming tutorial ...)     *     *    $tableInfo[$i]["name"]     : the name of field #$i. if you want another     *           name for the tag, than the query or your array provides, assign     *           it here.     *     *   Additional info     *     $tableInfo["parent_key"][$table]  : index of the parent key for $table.     *           this is the field, where the programm looks for changes, if this     *           field changes, it assumes, that we need a new "rowset" in the     *           parent table.     *     *     $tableInfo["parent_table"][$table]: name of the parent table for $table.     *     * @var      array     * @access    private     */     var $user_tableInfo = array();     /**     * the encoding type, the input from the db has     */     var $encoding_from  = "ISO-8859-1";     /**     * the encoding type, the output in the xml should have     * (note that domxml at the moment only support UTF-8, or at least it looks like)     */     var $encoding_to = "gb2312";     var $tagname = "tagname";     /**     * Constructor     * The Constructor can take a Pear::DB "data source name" (eg.     *  "mysql://user:passwd@localhost/dbname") and will then connect     *  to the DB, or a PEAR::DB object link, if you already connected     *  the db before.     "  If you provide nothing as $dsn, you only can later add stuff with     *   a pear::db-resultset or as an array. providing sql-strings will     *   not work.     * the $root param is used, if you want to provide another name for your     *  root-tag than "root". if you give an empty string (""), there will be no     *  root element created here, but only when you add a resultset/array/sql-string.     *  And the first tag of this result is used as the root tag.     *     * @param  mixed $dsn    PEAR::DB "data source name" or object DB object     * @param  string $root  the name of the xml-doc root element.     * @access   public     */     function XML_sql2xml ($dsn = Null, $root = "root") {         // if it's a string, then it must be a dsn-identifier;         if (is_string($dsn))         {             include_once ("DB.php");             $this->db = DB::Connect($dsn);             if (DB::isError($this->db))             {                 print "The given dsn for XML_sql2xml was not valid in file ".__FILE__." at line ".__LINE__."<br>\n";                 return new DB_Error($this->db->code,PEAR_ERROR_DIE);             }         }         elseif (is_object($dsn) && DB::isError($dsn))         {             print "The given param for XML_sql2xml was not valid in file ".__FILE__." at line ".__LINE__."<br>\n";             return new DB_Error($dsn->code,PEAR_ERROR_DIE);         }         // if parent class is db_common, then it's already a connected identifier         elseif (get_parent_class($dsn) == "db_common")         {             $this->db = $dsn;         }         $this->xmldoc = domxml_new_xmldoc('1.0');         //oehm, seems not to work, unfortunately.... does anybody know a solution?         $this->xmldoc->encoding = $this->encoding_to;                 if ($root) {             $this->xmlroot = $this->xmldoc->add_root($root);             //PHP 4.0.6 had $root->name as tagname, check for that here...             if (!isset($this->xmlroot->{$this->tagname}))             {                 $this->tagname = "name";             }         }     }     /**     * General method for adding new resultsets to the xml-object     *  Give a sql-query-string, a pear::db_result object or an array as     *  input parameter, and the method calls the appropriate method for this     *  input and adds this to $this->xmldoc     *     * @param    string sql-string, or object db_result, or array     * @param    mixed additional parameters for the following functions     * @access   public     * @see      addResult(), addSql(), addArray(), addXmlFile()     */     function add ($resultset, $params = Null)     {         // if string, then it's a query, a xml-file or a xml-string...         if (is_string($resultset)) {             if (preg_match("/\.xml$/",$resultset)) {                 $this->AddXmlFile($resultset,$params);             }             elseif (preg_match("/.*select.*from.*/i" ,  $resultset)) {                 $this->AddSql($resultset);             }             else {                 $this->AddXmlString($resultset);             }         }         // if array, then it's an array...         elseif (is_array($resultset)) {             $this->AddArray($resultset);         }         if (get_class($resultset) == "db_result") {             $this->AddResult($resultset);         }     }     /**     * Adds the content of a xml-file to $this->xmldoc, on the same level     * as a normal resultset (mostly just below <root>)     *     * @param    string filename     * @param    mixed xpath  either a string with the xpath expression or an array with "xpath"=>xpath expression  and "root"=tag/subtag/etc, which are the tags to be inserted before the result     * @access   public     * @see      doXmlString2Xml()     */     function addXmlFile($file,$xpath = Null)     {         $fd = fopen( $file, "r" );         $content = fread( $fd, filesize( $file ) );         fclose( $fd );         $this->doXmlString2Xml($content,$xpath);     }     /**     * Adds the content of a xml-string to $this->xmldoc, on the same level     * as a normal resultset (mostly just below <root>)     *     * @param    string xml     * @param    mixed xpath  either a string with the xpath expression or an array with "xpath"=>xpath expression  and "root"=tag/subtag/etc, which are the tags to be inserted before the result     * @access   public     * @see      doXmlString2Xml()     */