Basically PHP5 or above can run smoothly by me.
Prerequisites: PHP5.2 or above
Install: Replace the go-pear.phar content in php/pear directory with http://go-pear.org/
Double click the go-pear.bat to install PEAR module.
Install XML_Query2XML and MDB2_Driver_mysql packages by dos command: pear install packageName
Moreover,need use the XSL transform function, make sure that uncomment the php_xsl.dll in php.ini
So take a look at the php code.
PHP 代码
- // include required files
- include 'XML/Query2XML.php';
- include 'MDB2.php';
- try {
- // initalize Query2XML object
- $q2x = XML_Query2XML::factory(MDB2::factory('mysql://username:password@localhost/databasename'));
- // generate SQL query
- // get results as XML
- $sql = "SELECT * FROM Drive";
- $xml = $q2x->getFlatXML($sql);
- // read XSL stylesheet data
- $xsl = new DOMDocument;
- $xsl->load('Drive.xsl');
- // initialize XSLT engine
- $xslp = new XSLTProcessor;
- // attach XSL stylesheet object
- $xslp->importStyleSheet($xsl);
- // perform transformation
- header('Content-Type: text/html');
- echo $xslp->transformToXML($xml);
- } catch (Exception $e) {
- echo $e->getMessage();
- }
- ?>