[Summary view] [Print] [Text view]

   1  <?php
   2  /*
   3   * Limb PHP Framework
   4   *
   5   * @link http://limb-project.com 
   6   * @copyright  Copyright &copy; 2004-2007 BIT(http://bit-creative.com)
   7   * @license    LGPL http://www.gnu.org/copyleft/lesser.html 
   8   */
   9  
  10  lmb_require('limb/dbal/src/drivers/lmbDbQueryStatement.interface.php');
  11  lmb_require(dirname(__FILE__) . '/lmbSqliteStatement.class.php');
  12  lmb_require(dirname(__FILE__) . '/lmbSqliteRecord.class.php');
  13  lmb_require(dirname(__FILE__) . '/lmbSqliteRecordSet.class.php');
  14  
  15  /**
  16   * class lmbSqliteQueryStatement.
  17   *
  18   * @package dbal
  19   * @version $Id$
  20   */
  21  class lmbSqliteQueryStatement extends lmbSqliteStatement implements lmbDbQueryStatement
  22  {
  23    function getOneRecord()
  24    {
  25      $record = new lmbSqliteRecord();
  26      $queryId = $this->connection->execute($this->getSQL());
  27      $values = sqlite_fetch_array($queryId, SQLITE_ASSOC);       
  28      if(is_array($values))
  29      {
  30        $record->import($values);
  31        return $record;
  32      }
  33    }
  34  
  35    function getOneValue()
  36    {
  37      $queryId = $this->connection->execute($this->getSQL());
  38      return sqlite_fetch_single($queryId);    
  39    }
  40  
  41    function getOneColumnAsArray()
  42    {
  43      $column = array();
  44      $queryId = $this->connection->execute($this->getSQL());
  45      while($value = sqlite_fetch_single($queryId))
  46        $column[] = $value;
  47      return $column;
  48    }
  49  
  50    function getRecordSet()
  51    {
  52      return new lmbSqliteRecordSet($this->connection, $this->getSQL());
  53    }
  54  }
  55  
  56  ?>