使用了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 | // | [email protected] so we can mail you a copy immediately. | // +----------------------------------------------------------------------+ // | authors: christian stocker <[email protected]> | // +----------------------------------------------------------------------+ // // $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://[email protected]/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://[email protected]/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 <[email protected]> * @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";
/** * 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:[email protected]/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() */
/** * 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() */