public function FrxPostgres::format in Forena Reports 6

Same name and namespace in other branches

1. 6.2 plugins/FrxPostgres.inc \FrxPostgres::format()
2. 7 plugins/FrxPostgres.inc \FrxPostgres::format()
3. 7.2 plugins/FrxPostgres.inc \FrxPostgres::format()
4. 7.3 plugins/FrxPostgres.inc \FrxPostgres::format()
5. 7.4 plugins/FrxPostgres.inc \FrxPostgres::format()

Implement custom SQL formatter to make sure that strings are properly escaped. Ideally we'd replace this with something that handles prepared statements, but it wouldn't work for

Parameters

unknown_type $value:

unknown_type $key:

unknown_type $data:

File

plugins/FrxPostgres.inc, line 137

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

public function format($value, $key, $data) {
  if ($value == '') {
    $value = 'NULL';
  }
  else {
    if (is_array($value)) {

      // Build a array of values string
      $i = 0;
      $val = '';
      foreach ($value as $v) {
        $i++;
        if ($i != 1) {
          $val .= ',';
        }
        if ($value == '') {
          $val .= 'NULL';
        }
        else {
          $val .= $v;
        }
      }
      $value = $val;
    }
    $value = trim($value);
    $value = "'" . pg_escape_string($value) . "'";
  }
  return $value;
}