Anonymous

<?php 
/* 
* Filename.....: class_mdb.php 
* Class........: mdb 
* Aufgabe......: open *.mdb MSAccess files 
* Erstellt am..: Donnerstag, 17. Juni 2004, 23:32:07 
*       _  __      _ _ 
*  ||| | |/ /     (_) |        Wirtschaftsinformatiker IHK 
* \. ./| ' / _ __  _| |_ ___   www.ingoknito.de 
* - ^ -|  < | '_ \| | __/ _ \   
* / - \| . \| | | | | || (_) | Peter Klauer 
*  ||| |_|\_\_| |_|_|\__\___/   
* mailto.......: knito@knito.de 
* 
* Changes: 
* 2006-03-08: changed function execute() to allow INSERT, UPDATE and DELETE. 
*             Inserted $RecordsAffected which seems to take random values. At least 
*             not the count of the records affected. 
*             Thanks to Pete from DigiOz Multimedia for this hint. 
* 2005-09-27: added new field $rowcount which may be written by function execute() 
*             added new field $ok which is filled after mdb() or open() is called 
*             changed function execute( ) to have a second (optional) parameter $getrowcount (default false) 
*             changed function mdb() to call open() and return the success to $mdb->ok as boolean 
*             changed function open() to return the success as boolean 
*             Using this class gets even more simple: function mdb() now calls open() directly 
* 2004-07-21: added function fieldcount() 
*/ 

class mdb 
{ 
  var $RS = 0; 
  var $ADODB = 0; 
   
  var $RecordsAffected; 
   
  var $strProvider = 'Provider=Microsoft.Jet.OLEDB.4.0'; 
  var $strMode     = 'Mode=ReadWrite'; 
  var $strPSI      = 'Persist Security Info=False'; 
  var $strDataSource  = ''; 
  var $strConn     = ''; 
  var $strRealPath = ''; 
   
  var $recordcount = 0; 
  var $ok = false; 
   
   
  /** 
  * Constructor needs path to .mdb file 
  * 
  * @param string $dsn = path to *.mdb file 
  * @return boolean success 
  */ 
  function mdb( $dsn='Please enter DataSource!' ) 
  { 
    $this->strRealPath = realpath( $dsn ); 
    if( strlen( $this->strRealPath ) > 0 ) 
    { 
      $this->strDataSource = 'Data Source='.$this->strRealPath; 
      $result = true; 
    } 
    else 
    { 
      echo "<br>mdb::mdb() File not found $dsn<br>"; 
      $result = false; 
    } 
     
    $this->RecordsAffected = new VARIANT(); 
     
    $this->open(); 
     
  } // eof constructor mdb() 
   
   
  function open( ) 
  { 
    if( strlen( $this->strRealPath ) > 0 ) 
    { 
   
      $this->strConn = 
        $this->strProvider.';'. 
        $this->strDataSource.';'. 
        $this->strMode.';'. 
        $this->strPSI; 
         
      $this->ADODB = new COM( 'ADODB.Connection' ); 
       
      if( $this->ADODB ) 
      { 
        $this->ADODB->open( $this->strConn ); 
         
        $result = true; 
      } 
      else 
      { 
        echo '<br>mdb::open() ERROR with ADODB.Connection<br>'.$this->strConn; 
        $result = false; 
      } 
    } 
     
    $this->ok = $result; 
     
    return $result; 
  } // eof open() 
   
   
  /** 
  * Execute SQL-Statement 
  * @param string $strSQL = sql statement 
  * @param boolean $getrecordcount = true when a record count is wanted 
  */ 
  function execute( $strSQL, $getrecordcount = false ) 
  { 

    $this->RS = $this->ADODB->execute( $strSQL, &$this->RecordsAffected ); 
     
    if( $getrecordcount == true ) 
    { 

      $this->RS->MoveFirst(); 
      $this->recordcount = 0; 
       
      # brute force loop 
      while( $this->RS->EOF == false ) 
      { 
        $this->recordcount++; 
        $this->RS->MoveNext(); 
      } 
      $this->RS->MoveFirst(); 

    } 
     
         
  } // eof execute() 
   
  function eof() 
  { 
    return $this->RS->EOF; 
  } // eof eof() 
   
  function movenext( ) 
  { 
    $this->RS->MoveNext(); 
  } // eof movenext() 
   
  function movefirst() 
  { 
    $this->RS->MoveFirst(); 
  } // eof movefirst() 
   
  function close() 
  { 
    
    @$this->RS->Close(); // Generates a warning when without "@" 
    $this->RS=null; 
   
    @$this->ADODB->Close(); 
    $this->ADODB=null; 
  } // eof close() 
   
  function fieldvalue( $fieldname ) 
  { 
    return $this->RS->Fields[$fieldname]->value; 
  } // eof fieldvalue() 
   
  function fieldname( $fieldnumber ) 
  { 
    return $this->RS->Fields[$fieldnumber]->name; 
  } // eof fieldname() 
   
  function fieldcount( ) 
  { 
    return $this->RS->Fields->Count; 
  } // eof fieldcount()   
   
} // eoc mdb 
?>