Home | Classes | Modules | Annotated | Hierarchy | Functions | Files

StatementCommon.php

Go to the documentation of this file.

<?php
/*
 *  $Id: StatementCommon.php,v 1.3 2004/03/20 04:16:49 hlellelid 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>.
 */

abstract class StatementCommon {

    protected $conn;
    
    protected $resultSet;

    protected $updateCount;
    
    protected $warnings = array();
    
    protected $resultClass;
    
    protected $stmt;
    
    protected $limit = 0;
    
    protected $offset = 0;
    
    function __construct(Connection $conn) 
    {
        $this->conn = $conn;        
    }
    
    public function setLimit($v)
    {
        $this->limit = (int) $v;
    }
    
    public function getLimit()
    {
        return $this->limit;
    }
    
    public function setOffset($v)
    {
        $this->offset = (int) $v;
    }
    
    public function getOffset()
    {
        return $this->offset;
    }
    
    public function close()
    {
        // do nothing here (subclasses will implement)
    }
    
    public function execute($sql, $fetchmode = null)
    {
        
        if (!$this->isSelect($sql)) {                    
            $this->updateCount = $this->executeUpdate($sql);
            return false;
        } else {
            $this->resultSet = $this->executeQuery($sql, $fetchmode);
            if ($this->resultSet->getRecordCount() === 0) {
                return false;
            }
            return true;
        }
    }

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

    public function getUpdateCount()
    {
        return $this->updateCount;
    }
        
    protected 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($sql);
        return (stripos($sql, 'select') === 0 && stripos($sql, 'select into ') !== 0);
    }

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

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

---

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