Location: PHPKode > scripts > mdb classes > mdb-classes/class_mdb.php
<?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.......: hide@address.com
 *
 * 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
?>
Return current item: mdb classes