[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3   V4.90 8 June 2006  (c) 2000-2006 John Lim (jlim#natsoft.com.my). All rights reserved.
   4    Released under both BSD license and Lesser GPL library license. 
   5    Whenever there is any discrepancy between the two licenses, 
   6    the BSD license will take precedence.
   7    Set tabs to 4.
   8    
   9    Postgres7 support.
  10    28 Feb 2001: Currently indicate that we support LIMIT
  11    01 Dec 2001: dannym added support for default values
  12  */
  13  
  14  // security - hide paths
  15  if (!defined('ADODB_DIR')) die();
  16  
  17  include_once(ADODB_DIR."/drivers/adodb-postgres64.inc.php");
  18  
  19  class ADODB_postgres7 extends ADODB_postgres64 {
  20      var $databaseType = 'postgres7';    
  21      var $hasLimit = true;    // set to true for pgsql 6.5+ only. support pgsql/mysql SELECT * FROM TABLE LIMIT 10
  22      var $ansiOuter = true;
  23      var $charSet = true; //set to true for Postgres 7 and above - PG client supports encodings
  24      
  25  	function ADODB_postgres7() 
  26      {
  27          $this->ADODB_postgres64();
  28          if (ADODB_ASSOC_CASE !== 2) {
  29              $this->rsPrefix .= 'assoc_';
  30          }
  31          $this->_bindInputArray = PHP_VERSION >= 5.1;
  32      }
  33  
  34      
  35      // the following should be compat with postgresql 7.2, 
  36      // which makes obsolete the LIMIT limit,offset syntax
  37       function &SelectLimit($sql,$nrows=-1,$offset=-1,$inputarr=false,$secs2cache=0) 
  38       {
  39           $offsetStr = ($offset >= 0) ? " OFFSET ".((integer)$offset) : '';
  40           $limitStr  = ($nrows >= 0)  ? " LIMIT ".((integer)$nrows) : '';
  41           if ($secs2cache)
  42                $rs =& $this->CacheExecute($secs2cache,$sql."$limitStr$offsetStr",$inputarr);
  43           else
  44                $rs =& $this->Execute($sql."$limitStr$offsetStr",$inputarr);
  45          
  46          return $rs;
  47       }
  48       /*
  49       function Prepare($sql)
  50      {
  51          $info = $this->ServerInfo();
  52          if ($info['version']>=7.3) {
  53              return array($sql,false);
  54          }
  55          return $sql;
  56      }
  57       */
  58  
  59  
  60      // from  Edward Jaramilla, improved version - works on pg 7.4
  61  	function MetaForeignKeys($table, $owner=false, $upper=false)
  62      {
  63          $sql = 'SELECT t.tgargs as args
  64          FROM
  65          pg_trigger t,pg_class c,pg_proc p
  66          WHERE
  67          t.tgenabled AND
  68          t.tgrelid = c.oid AND
  69          t.tgfoid = p.oid AND
  70          p.proname = \'RI_FKey_check_ins\' AND
  71          c.relname = \''.strtolower($table).'\'
  72          ORDER BY
  73              t.tgrelid';
  74          
  75          $rs =& $this->Execute($sql);
  76          
  77          if ($rs && !$rs->EOF) {
  78              $arr =& $rs->GetArray();
  79              $a = array();
  80              foreach($arr as $v)
  81              {
  82                  $data = explode(chr(0), $v['args']);
  83                  if ($upper) {
  84                      $a[strtoupper($data[2])][] = strtoupper($data[4].'='.$data[5]);
  85                  } else {
  86                  $a[$data[2]][] = $data[4].'='.$data[5];
  87                  }
  88              }
  89              return $a;
  90          }
  91          return false;
  92      }
  93  
  94  	function _query($sql,$inputarr)
  95      {
  96          if (! $this->_bindInputArray) {
  97              // We don't have native support for parameterized queries, so let's emulate it at the parent
  98              return ADODB_postgres64::_query($sql, $inputarr);
  99          }
 100          $this->_errorMsg = false;
 101          // -- added Cristiano da Cunha Duarte
 102          if ($inputarr) {
 103              $sqlarr = explode('?',trim($sql));
 104              $sql = '';
 105              $i = 1;
 106              $last = sizeof($sqlarr)-1;
 107              foreach($sqlarr as $v) {
 108                  if ($last < $i) $sql .= $v;
 109                  else $sql .= $v.' $'.$i;
 110                  $i++;
 111              }
 112              
 113              $rez = pg_query_params($this->_connectionID,$sql, $inputarr);
 114          } else {
 115              $rez = pg_query($this->_connectionID,$sql);
 116          }
 117          // check if no data returned, then no need to create real recordset
 118          if ($rez && pg_numfields($rez) <= 0) {
 119              if (is_resource($this->_resultid) && get_resource_type($this->_resultid) === 'pgsql result') {
 120                  pg_freeresult($this->_resultid);
 121              }
 122              $this->_resultid = $rez;
 123              return true;
 124          }        
 125          return $rez;
 126      }
 127      
 128        // this is a set of functions for managing client encoding - very important if the encodings
 129      // of your database and your output target (i.e. HTML) don't match
 130      //for instance, you may have UNICODE database and server it on-site as WIN1251 etc.
 131      // GetCharSet - get the name of the character set the client is using now
 132      // the functions should work with Postgres 7.0 and above, the set of charsets supported
 133      // depends on compile flags of postgres distribution - if no charsets were compiled into the server
 134      // it will return 'SQL_ANSI' always
 135  	function GetCharSet()
 136      {
 137          //we will use ADO's builtin property charSet
 138          $this->charSet = @pg_client_encoding($this->_connectionID);
 139          if (!$this->charSet) {
 140              return false;
 141          } else {
 142              return $this->charSet;
 143          }
 144      }
 145      
 146      // SetCharSet - switch the client encoding
 147  	function SetCharSet($charset_name)
 148      {
 149          $this->GetCharSet();
 150          if ($this->charSet !== $charset_name) {
 151              $if = pg_set_client_encoding($this->_connectionID, $charset_name);
 152              if ($if == "0" & $this->GetCharSet() == $charset_name) {
 153                  return true;
 154              } else return false;
 155          } else return true;
 156      }
 157  
 158  }
 159      
 160  /*--------------------------------------------------------------------------------------
 161       Class Name: Recordset
 162  --------------------------------------------------------------------------------------*/
 163  
 164  class ADORecordSet_postgres7 extends ADORecordSet_postgres64{
 165  
 166      var $databaseType = "postgres7";
 167      
 168      
 169  	function ADORecordSet_postgres7($queryID,$mode=false) 
 170      {
 171          $this->ADORecordSet_postgres64($queryID,$mode);
 172      }
 173      
 174           // 10% speedup to move MoveNext to child class
 175  	function MoveNext() 
 176      {
 177          if (!$this->EOF) {
 178              $this->_currentRow++;
 179              if ($this->_numOfRows < 0 || $this->_numOfRows > $this->_currentRow) {
 180                  $this->fields = @pg_fetch_array($this->_queryID,$this->_currentRow,$this->fetchMode);
 181              
 182                  if (is_array($this->fields)) {
 183                      if ($this->fields && isset($this->_blobArr)) $this->_fixblobs();
 184                      return true;
 185                  }
 186              }
 187              $this->fields = false;
 188              $this->EOF = true;
 189          }
 190          return false;
 191      }        
 192  
 193  }
 194  
 195  class ADORecordSet_assoc_postgres7 extends ADORecordSet_postgres64{
 196  
 197      var $databaseType = "postgres7";
 198      
 199      
 200  	function ADORecordSet_assoc_postgres7($queryID,$mode=false) 
 201      {
 202          $this->ADORecordSet_postgres64($queryID,$mode);
 203      }
 204      
 205  	function _fetch()
 206      {
 207          if ($this->_currentRow >= $this->_numOfRows && $this->_numOfRows >= 0)
 208              return false;
 209  
 210          $this->fields = @pg_fetch_array($this->_queryID,$this->_currentRow,$this->fetchMode);
 211          
 212          if ($this->fields) {
 213              if (isset($this->_blobArr)) $this->_fixblobs();
 214              $this->_updatefields();
 215          }
 216              
 217          return (is_array($this->fields));
 218      }
 219      
 220          // Create associative array
 221  	function _updatefields()
 222      {
 223          if (ADODB_ASSOC_CASE == 2) return; // native
 224      
 225          $arr = array();
 226          $lowercase = (ADODB_ASSOC_CASE == 0);
 227          
 228          foreach($this->fields as $k => $v) {
 229              if (is_integer($k)) $arr[$k] = $v;
 230              else {
 231                  if ($lowercase)
 232                      $arr[strtolower($k)] = $v;
 233                  else
 234                      $arr[strtoupper($k)] = $v;
 235              }
 236          }
 237          $this->fields = $arr;
 238      }
 239      
 240  	function MoveNext() 
 241      {
 242          if (!$this->EOF) {
 243              $this->_currentRow++;
 244              if ($this->_numOfRows < 0 || $this->_numOfRows > $this->_currentRow) {
 245                  $this->fields = @pg_fetch_array($this->_queryID,$this->_currentRow,$this->fetchMode);
 246              
 247                  if (is_array($this->fields)) {
 248                      if ($this->fields) {
 249                          if (isset($this->_blobArr)) $this->_fixblobs();
 250                      
 251                          $this->_updatefields();
 252                      }
 253                      return true;
 254                  }
 255              }
 256              
 257              
 258              $this->fields = false;
 259              $this->EOF = true;
 260          }
 261          return false;
 262      }
 263  }
 264  ?>