You are here

private function FrxPostgres::php_xml in Forena Reports 7.3

Same name and namespace in other branches
  1. 6.2 plugins/FrxPostgres.inc \FrxPostgres::php_xml()
  2. 6 plugins/FrxPostgres.inc \FrxPostgres::php_xml()
  3. 7 plugins/FrxPostgres.inc \FrxPostgres::php_xml()
  4. 7.2 plugins/FrxPostgres.inc \FrxPostgres::php_xml()
  5. 7.4 plugins/FrxPostgres.inc \FrxPostgres::php_xml()
1 call to FrxPostgres::php_xml()
FrxPostgres::sqlData in plugins/FrxPostgres.inc
Get data based on file data block in the repository.

File

plugins/FrxPostgres.inc, line 112
Oracle specific driver that takes advantage of oracles native XML support

Class

FrxPostgres
@file Oracle specific driver that takes advantage of oracles native XML support

Code

private function php_xml($sql) {
  $db = $this->db;
  $xml = new SimpleXMLElement('<table/>');
  $rs = pg_query($sql);
  $rownum = 0;
  if ($rs) {
    while ($row = pg_fetch_assoc($rs)) {
      $rownum++;
      $row_node = $xml
        ->addChild('row');
      $row_node['num'] = $rownum;
      foreach ($row as $key => $value) {
        $row_node
          ->addChild(strtolower($key), htmlspecialchars($value));
      }
    }
  }
  if ($rs) {
    pg_free_result($rs);
  }
  return $xml;
}