Home | Classes | Modules | Annotated | Functions | Files

StatementCommon.php

Go to the documentation of this file.

<?php
/*
 *  $Id: StatementCommon.php,v 1.3 2004/04/27 18:09:16 micha Exp $
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information please see
 * <http://creole.phpdb.org>.
 */

require_once 'creole/Statement.php';

class StatementCommon extends Statement
{
  var $conn;

  var $resultSet;

  var $updateCount;

  var $warnings = array();

  var $resultClass;

  var $stmt;

  var $limit = 0;

  var $offset = 0;

  function StatementCommon(/*Connection*/ &$conn)
  {
    if (! is_a($conn, 'Connection')) {
      trigger_error (
        "StatementCommon::StatementCommon(): parameter 1 not of type 'Connection' !",
        E_USER_ERROR
      );
    }

    $this->conn =& $conn;
  }

  function setLimit($v)
  {
    $this->limit = (int) $v;
  }

  function getLimit()
  {
    return $this->limit;
  }

  function setOffset($v)
  {
    $this->offset = (int) $v;
  }

  function getOffset()
  {
    return $this->offset;
  }

  function close()
  {
    // do nothing here (subclasses will implement)
  }

  function & execute($sql, $fetchmode = null)
  {
    if (! $this->isSelect($sql)) {
      return $this->executeUpdate($sql);
    } else {
      return $this->executeQuery($sql, $fetchmode);
    }
  }

  function & getResultSet()
  {
    return $this->resultSet;
  }

  function getUpdateCount()
  {
    return $this->updateCount;
  }

  function isSelect($sql)
  {
    // is first word is SELECT, then return true, unless it's SELECT INTO ...
    // this doesn't, however, take comments into account ...
    $sql = trim(strtolower($sql));
    return (strpos($sql, 'select') === 0 && strpos($sql, 'select into ') !== 0);
  }

  function & executeQuery($sql, $fetchmode = null)
  {
    $this->updateCount = null;
    if ($this->limit > 0) {
        $this->conn->applyLimit($sql, $this->offset, $this->limit);
    } elseif ($this->offset > 0) {
      return new SQLException(CREOLE_ERROR, 'Cannot specify an offset without limit.');
    }
    $this->resultSet =& $this->conn->executeQuery($sql, $fetchmode);
    return $this->resultSet;
  }

  function executeUpdate($sql)
  {
    if ($this->resultSet) $this->resultSet->close();
    $this->resultSet = null;
    $this->updateCount = $this->conn->executeUpdate($sql);
    return $this->updateCount;
  }

  function getMoreResults()
  {
    if ($this->resultSet) $this->resultSet->close();
    $this->resultSet = null;
    return false;
  }

  function & getConnection()
  {
    return $this->conn;
  }
}

---

This file is part of the Creole[php4] library.