アールメカブ

• 追加された行はこの色です。
• 削除された行はこの色です。
• PHP_XML へ行く。
• PHP_XML の差分を削除

 sudo pear install XML_Query2XML ## --alldeps を忘れた
 [sudo] password for ishida: 
 Did not download optional dependencies: pear/Net_LDAP2, 
   pear/MDB2, pear/I18N_UnicodeString, use --alldeps to download 
    automatically
 pear/XML_Query2XML can optionally use package "pear/Net_LDAP2"
 pear/XML_Query2XML can optionally use package "pear/MDB2"
 pear/XML_Query2XML can optionally use package  
   "pear/I18N_UnicodeString"
 downloading XML_Query2XML-1.7.1.tgz ...
 Starting to download XML_Query2XML-1.7.1.tgz (169,218 bytes)
 .....................................done: 169,218 bytes
 install ok: channel://pear.php.net/XML_Query2XML-1.7.1

 ishida@app:~/public_html$ sudo pear install --alldeps MDB2
 downloading MDB2-2.4.1.tgz ...
 Starting to download MDB2-2.4.1.tgz (119,790 bytes)
 ..........................done: 119,790 bytes
 install ok: channel://pear.php.net/MDB2-2.4.1
 MDB2: Optional feature fbsql available (Frontbase SQL driver for MDB2)
 MDB2: Optional feature ibase available (Interbase/Firebird driver for MDB2)
 MDB2: Optional feature mysql available (MySQL driver for MDB2)
 MDB2: Optional feature mysqli available (MySQLi driver for MDB2)
 MDB2: Optional feature mssql available (MS SQL Server driver for MDB2)
 MDB2: Optional feature oci8 available (Oracle driver for MDB2)
 MDB2: Optional feature pgsql available (PostgreSQL driver for MDB2)
 MDB2: Optional feature querysim available (Querysim driver for MDB2)
 MDB2: Optional feature sqlite available (SQLite2 driver for MDB2)
 MDB2: To install optional features use "pear install  
      pear/MDB2#featurename"
 ishida@app:~/public_html$ sudo pear install --alldeps MDB2#mysql
 Skipping package "pear/MDB2", already installed as version 2.4.1
 downloading MDB2_Driver_mysql-1.4.1.tgz ...
 Starting to download MDB2_Driver_mysql-1.4.1.tgz (36,481 bytes)
 ..........done: 36,481 bytes
 install ok: channel://pear.php.net/MDB2_Driver_mysql-1.4.1
 ishida@app:~/public_html$ sudo pear install --alldeps MDB2#mysqli
 Skipping package "pear/MDB2", already installed as version 2.4.1
 downloading MDB2_Driver_mysqli-1.4.1.tgz ...
 Starting to download MDB2_Driver_mysqli-1.4.1.tgz (38,064 bytes)
 ..........done: 38,064 bytes
 install ok: channel://pear.php.net/MDB2_Driver_mysqli-1.4.1


 <?php
 // include required files
 include 'XML/Query2XML.php';
 include 'MDB2.php';
 
 try {
    // initialize Query2XML object
    $q2x =  
         XML_Query2XML::factory(MDB2::factory(
             'mysql://USER_NAME:PASSWORD@localhost/DB_NAME'));
 
    // generate SQL query
    // get results as XML
    $sql = "SELECT * FROM users";
 
 $dom = $q2x->getXML( $sql,
    array(
      'rootTag' => 'myroot',
      'rowTag' => 'myrow',
      'idColumn' => 'id',
      'elements' => array('id','password',  'name', 'email'),
      'encoder' => false
    )
  );
  
  header('Content-Type: application/xml');
 $xml->formatOutput = true;
 print $dom->saveXML();
 } catch (Exception $e) {
    echo $e->getMessage();
 }
 ?>

 <?php
 
 include 'XML/Query2XML.php';
 include 'MDB2.php';
 
 try {
    $q2x =
    XML_Query2XML::factory(MDB2::factory(
     'mysql://ishida:app1234@localhost/test'));
    $sql = "SELECT * FROM users";
    $options =
      array(
       'rootTag' => 'myroot',
       'rowTag' => 'myrow',
       'idColumn' => 'id',
       'attributes' => array('name', 'email'), 
       'elements' => array('名前' => 'name' , 'メール' =>
'email'),
       'elements' => array('名前'=>'name', 'メール'=>'email'),
      'encoder' => false # 文字化け対策
     );
 
   $dom = $q2x->getXML( $sql,$options);
 
  header('Content-Type: application/xml');
 
  $xml->formatOutput = true;
 
  print $dom->saveXML();
 } catch (Exception $e) {
    echo $e->getMessage();
 }
 ?>


[[ここ:http://www.ibm.com/developerworks/jp/xml/library/x-query2xml/index.html]] や [[ここ:http://bluenotes.justblog.jp/technote/2009/03/xml_query2xml-4.html]]などを参考にする