WebSVN - ant - Различия - Редакция 2 и 3


<?php

/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */

/**
 * The PEAR DB driver for PHP's mssql extension
 * for interacting with Microsoft SQL Server databases
 *
 * PHP versions 4 and 5
 *
 * LICENSE: This source file is subject to version 3.0 of the PHP license
 * that is available through the world-wide-web at the following URI:
 * http://www.php.net/license/3_0.txt.  If you did not receive a copy of
 * the PHP License and are unable to obtain it through the web, please
 * send a note to license@php.net so we can mail you a copy immediately.
 *
 * @category   Database
 * @package    DB
 * @author     Sterling Hughes <sterling@php.net>
 * @author     Daniel Convissor <danielc@php.net>
 * @copyright  1997-2007 The PHP Group
 * @license    http://www.php.net/license/3_0.txt  PHP License 3.0
 * @version    CVS: $Id: mssql.php,v 1.92 2007/09/21 13:40:41 aharvey Exp $
 * @link       http://pear.php.net/package/DB
 */

/**
 * Obtain the DB_common class so it can be extended from
 */
require_once 'DB/common.php';

/**
 * The methods PEAR DB uses to interact with PHP's mssql extension
 * for interacting with Microsoft SQL Server databases
 *
 * These methods overload the ones declared in DB_common.
 *
 * DB's mssql driver is only for Microsfoft SQL Server databases.
 *
 * If you're connecting to a Sybase database, you MUST specify "sybase"
 * as the "phptype" in the DSN.
 *
 * This class only works correctly if you have compiled PHP using
 * --with-mssql=[dir_to_FreeTDS].
 *
 * @category   Database
 * @package    DB
 * @author     Sterling Hughes <sterling@php.net>
 * @author     Daniel Convissor <danielc@php.net>
 * @copyright  1997-2007 The PHP Group
 * @license    http://www.php.net/license/3_0.txt  PHP License 3.0
 * @version    Release: 1.7.13
 * @link       http://pear.php.net/package/DB
 */
class DB_mssql extends DB_common
{
    // {{{ properties

    /**
     * The DB driver type (mysql, oci8, odbc, etc.)
     * @var string
     */
    var $phptype = 'mssql';

    /**
     * The database syntax variant to be used (db2, access, etc.), if any
     * @var string
     */
    var $dbsyntax = 'mssql';

    /**
     * The capabilities of this DB implementation
     *
     * The 'new_link' element contains the PHP version that first provided
     * new_link support for this DBMS.  Contains false if it's unsupported.
     *
     * Meaning of the 'limit' element:
     *   + 'emulate' = emulate with fetch row by number
     *   + 'alter'   = alter the query
     *   + false     = skip rows
     *
     * @var array
     */
    var $features = array(
        'limit'         => 'emulate',
        'new_link'      => false,
        'numrows'       => true,
        'pconnect'      => true,
        'prepare'       => false,
        'ssl'           => false,
        'transactions'  => true,
    );

    /**
     * A mapping of native error codes to DB error codes
     * @var array
     */
    // XXX Add here error codes ie: 'S100E' => DB_ERROR_SYNTAX
    var $errorcode_map = array(
        102   => DB_ERROR_SYNTAX,
        110   => DB_ERROR_VALUE_COUNT_ON_ROW,
        155   => DB_ERROR_NOSUCHFIELD,
        156   => DB_ERROR_SYNTAX,
        170   => DB_ERROR_SYNTAX,
        207   => DB_ERROR_NOSUCHFIELD,
        208   => DB_ERROR_NOSUCHTABLE,
        245   => DB_ERROR_INVALID_NUMBER,
        319   => DB_ERROR_SYNTAX,
        321   => DB_ERROR_NOSUCHFIELD,
        325   => DB_ERROR_SYNTAX,
        336   => DB_ERROR_SYNTAX,
        515   => DB_ERROR_CONSTRAINT_NOT_NULL,
        547   => DB_ERROR_CONSTRAINT,
        1018  => DB_ERROR_SYNTAX,
        1035  => DB_ERROR_SYNTAX,
        1913  => DB_ERROR_ALREADY_EXISTS,
        2209  => DB_ERROR_SYNTAX,
        2223  => DB_ERROR_SYNTAX,
        2248  => DB_ERROR_SYNTAX,
        2256  => DB_ERROR_SYNTAX,
        2257  => DB_ERROR_SYNTAX,
        2627  => DB_ERROR_CONSTRAINT,
        2714  => DB_ERROR_ALREADY_EXISTS,
        3607  => DB_ERROR_DIVZERO,
        3701  => DB_ERROR_NOSUCHTABLE,
        7630  => DB_ERROR_SYNTAX,
        8134  => DB_ERROR_DIVZERO,
        9303  => DB_ERROR_SYNTAX,
        9317  => DB_ERROR_SYNTAX,
        9318  => DB_ERROR_SYNTAX,
        9331  => DB_ERROR_SYNTAX,
        9332  => DB_ERROR_SYNTAX,
        15253 => DB_ERROR_SYNTAX,
    );

    /**
     * The raw database connection created by PHP
     * @var resource
     */
    var $connection;

    /**
     * The DSN information for connecting to a database
     * @var array
     */
    var $dsn = array();


    /**
     * Should data manipulation queries be committed automatically?
     * @var bool
     * @access private
     */
    var $autocommit = true;

    /**
     * The quantity of transactions begun
     *
     * {@internal  While this is private, it can't actually be designated
     * private in PHP 5 because it is directly accessed in the test suite.}}
     *
     * @var integer
     * @access private
     */
    var $transaction_opcount = 0;

    /**
     * The database specified in the DSN
     *
     * It's a fix to allow calls to different databases in the same script.
     *
     * @var string
     * @access private
     */
    var $_db = null;


    // }}}
    // {{{ constructor

    /**
     * This constructor calls <kbd>$this->DB_common()</kbd>
     *
     * @return void
     */
    function DB_mssql()
    {
        $this->DB_common();
    }

    // }}}
    // {{{ connect()

    /**
     * Connect to the database server, log in and open the database
     *
     * Don't call this method directly.  Use DB::connect() instead.
     *
     * @param array $dsn         the data source name
     * @param bool  $persistent  should the connection be persistent?
     *
     * @return int  DB_OK on success. A DB_Error object on failure.
     */
    function connect($dsn, $persistent = false)
    {
        if (!PEAR::loadExtension('mssql') && !PEAR::loadExtension('sybase')
            && !PEAR::loadExtension('sybase_ct'))
        {
            return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND);
        }

        $this->dsn = $dsn;
        if ($dsn['dbsyntax']) {
            $this->dbsyntax = $dsn['dbsyntax'];
        }

        $params = array(
            $dsn['hostspec'] ? $dsn['hostspec'] : 'localhost',
            $dsn['username'] ? $dsn['username'] : null,
            $dsn['password'] ? $dsn['password'] : null,
        );
        if ($dsn['port']) {
            $params[0] .= ((substr(PHP_OS, 0, 3) == 'WIN') ? ',' : ':')
                        . $dsn['port'];
        }

        $connect_function = $persistent ? 'mssql_pconnect' : 'mssql_connect';

        $this->connection = @call_user_func_array($connect_function, $params);

        if (!$this->connection) {
            return $this->raiseError(DB_ERROR_CONNECT_FAILED,
                                     null, null, null,
                                     @mssql_get_last_message());
        }
        if ($dsn['database']) {
            if (!@mssql_select_db($dsn['database'], $this->connection)) {
                return $this->raiseError(DB_ERROR_NODBSELECTED,
                                         null, null, null,
                                         @mssql_get_last_message());
            }
            $this->_db = $dsn['database'];
        }
        return DB_OK;
    }

    // }}}
    // {{{ disconnect()

    /**
     * Disconnects from the database server
     *
     * @return bool  TRUE on success, FALSE on failure
     */
    function disconnect()
    {
        $ret = @mssql_close($this->connection);
        $this->connection = null;
        return $ret;
    }

    // }}}
    // {{{ simpleQuery()

    /**
     * Sends a query to the database server
     *
     * @param string  the SQL query string
     *
     * @return mixed  + a PHP result resrouce for successful SELECT queries
     *                + the DB_OK constant for other successful queries
     *                + a DB_Error object on failure
     */
    function simpleQuery($query)
    {
        $ismanip = $this->_checkManip($query);
        $this->last_query = $query;
        if (!@mssql_select_db($this->_db, $this->connection)) {
            return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
        }
        $query = $this->modifyQuery($query);
        if (!$this->autocommit && $ismanip) {
            if ($this->transaction_opcount == 0) {
                $result = @mssql_query('BEGIN TRAN', $this->connection);
                if (!$result) {
                    return $this->mssqlRaiseError();
                }
            }
            $this->transaction_opcount++;
        }
        $result = @mssql_query($query, $this->connection);
        if (!$result) {
            return $this->mssqlRaiseError();
        }
        // Determine which queries that should return data, and which
        // should return an error code only.
        return $ismanip ? DB_OK : $result;
    }

    // }}}
    // {{{ nextResult()

    /**
     * Move the internal mssql result pointer to the next available result
     *
     * @param a valid fbsql result resource
     *
     * @access public
     *
     * @return true if a result is available otherwise return false
     */
    function nextResult($result)
    {
        return @mssql_next_result($result);
    }

    // }}}
    // {{{ fetchInto()

    /**
     * Places a row from the result set into the given array
     *
     * Formating of the array and the data therein are configurable.
     * See DB_result::fetchInto() for more information.
     *
     * This method is not meant to be called directly.  Use
     * DB_result::fetchInto() instead.  It can't be declared "protected"
     * because DB_result is a separate object.
     *
     * @param resource $result    the query result resource
     * @param array    $arr       the referenced array to put the data in
     * @param int      $fetchmode how the resulting array should be indexed
     * @param int      $rownum    the row number to fetch (0 = first row)
     *
     * @return mixed  DB_OK on success, NULL when the end of a result set is
     *                 reached or on failure
     *
     * @see DB_result::fetchInto()
     */
    function fetchInto($result, &$arr, $fetchmode, $rownum = null)
    {
        if ($rownum !== null) {
            if (!@mssql_data_seek($result, $rownum)) {
                return null;
            }
        }
        if ($fetchmode & DB_FETCHMODE_ASSOC) {
            $arr = @mssql_fetch_assoc($result);
            if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE && $arr) {
                $arr = array_change_key_case($arr, CASE_LOWER);
            }
        } else {
            $arr = @mssql_fetch_row($result);
        }
        if (!$arr) {
            return null;
        }
        if ($this->options['portability'] & DB_PORTABILITY_RTRIM) {
            $this->_rtrimArrayValues($arr);
        }
        if ($this->options['portability'] & DB_PORTABILITY_NULL_TO_EMPTY) {
            $this->_convertNullArrayValuesToEmpty($arr);
        }
        return DB_OK;
    }

    // }}}
    // {{{ freeResult()

    /**
     * Deletes the result set and frees the memory occupied by the result set
     *
     * This method is not meant to be called directly.  Use
     * DB_result::free() instead.  It can't be declared "protected"
     * because DB_result is a separate object.
     *
     * @param resource $result  PHP's query result resource
     *
     * @return bool  TRUE on success, FALSE if $result is invalid
     *
     * @see DB_result::free()
     */
    function freeResult($result)
    {
        return is_resource($result) ? mssql_free_result($result) : false;
    }

    // }}}
    // {{{ numCols()

    /**
     * Gets the number of columns in a result set
     *
     * This method is not meant to be called directly.  Use
     * DB_result::numCols() instead.  It can't be declared "protected"
     * because DB_result is a separate object.
     *
     * @param resource $result  PHP's query result resource
     *
     * @return int  the number of columns.  A DB_Error object on failure.
     *
     * @see DB_result::numCols()
     */
    function numCols($result)
    {
        $cols = @mssql_num_fields($result);
        if (!$cols) {
            return $this->mssqlRaiseError();
        }
        return $cols;
    }

    // }}}
    // {{{ numRows()

    /**
     * Gets the number of rows in a result set
     *
     * This method is not meant to be called directly.  Use
     * DB_result::numRows() instead.  It can't be declared "protected"
     * because DB_result is a separate object.
     *
     * @param resource $result  PHP's query result resource
     *
     * @return int  the number of rows.  A DB_Error object on failure.
     *
     * @see DB_result::numRows()
     */
    function numRows($result)
    {
        $rows = @mssql_num_rows($result);
        if ($rows === false) {
            return $this->mssqlRaiseError();
        }
        return $rows;
    }

    // }}}
    // {{{ autoCommit()

    /**
     * Enables or disables automatic commits
     *
     * @param bool $onoff  true turns it on, false turns it off
     *
     * @return int  DB_OK on success.  A DB_Error object if the driver
     *               doesn't support auto-committing transactions.
     */
    function autoCommit($onoff = false)
    {
        // XXX if $this->transaction_opcount > 0, we should probably
        // issue a warning here.
        $this->autocommit = $onoff ? true : false;
        return DB_OK;
    }

    // }}}
    // {{{ commit()

    /**
     * Commits the current transaction
     *
     * @return int  DB_OK on success.  A DB_Error object on failure.
     */
    function commit()
    {
        if ($this->transaction_opcount > 0) {
            if (!@mssql_select_db($this->_db, $this->connection)) {
                return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
            }
            $result = @mssql_query('COMMIT TRAN', $this->connection);
            $this->transaction_opcount = 0;
            if (!$result) {
                return $this->mssqlRaiseError();
            }
        }
        return DB_OK;
    }

    // }}}
    // {{{ rollback()

    /**
     * Reverts the current transaction
     *
     * @return int  DB_OK on success.  A DB_Error object on failure.
     */
    function rollback()
    {
        if ($this->transaction_opcount > 0) {
            if (!@mssql_select_db($this->_db, $this->connection)) {
                return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
            }
            $result = @mssql_query('ROLLBACK TRAN', $this->connection);
            $this->transaction_opcount = 0;
            if (!$result) {
                return $this->mssqlRaiseError();
            }
        }
        return DB_OK;
    }

    // }}}
    // {{{ affectedRows()

    /**
     * Determines the number of rows affected by a data maniuplation query
     *
     * 0 is returned for queries that don't manipulate data.
     *
     * @return int  the number of rows.  A DB_Error object on failure.
     */
    function affectedRows()
    {
        if ($this->_last_query_manip) {
            $res = @mssql_query('select @@rowcount', $this->connection);
            if (!$res) {
                return $this->mssqlRaiseError();
            }
            $ar = @mssql_fetch_row($res);
            if (!$ar) {
                $result = 0;
            } else {
                @mssql_free_result($res);
                $result = $ar[0];
            }
        } else {
            $result = 0;
        }
        return $result;
    }

    // }}}
    // {{{ nextId()

    /**
     * Returns the next free id in a sequence
     *
     * @param string  $seq_name  name of the sequence
     * @param boolean $ondemand  when true, the seqence is automatically
     *                            created if it does not exist
     *
     * @return int  the next id number in the sequence.
     *               A DB_Error object on failure.
     *
     * @see DB_common::nextID(), DB_common::getSequenceName(),
     *      DB_mssql::createSequence(), DB_mssql::dropSequence()
     */
    function nextId($seq_name, $ondemand = true)
    {
        $seqname = $this->getSequenceName($seq_name);
        if (!@mssql_select_db($this->_db, $this->connection)) {
            return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
        }
        $repeat = 0;
        do {
            $this->pushErrorHandling(PEAR_ERROR_RETURN);
            $result = $this->query("INSERT INTO $seqname (vapor) VALUES (0)");
            $this->popErrorHandling();
            if ($ondemand && DB::isError($result) &&
                ($result->getCode() == DB_ERROR || $result->getCode() == DB_ERROR_NOSUCHTABLE))
            {
                $repeat = 1;
                $result = $this->createSequence($seq_name);
                if (DB::isError($result)) {
                    return $this->raiseError($result);
                }
            } elseif (!DB::isError($result)) {
                $result = $this->query("SELECT IDENT_CURRENT('$seqname')");
                if (DB::isError($result)) {
                    /* Fallback code for MS SQL Server 7.0, which doesn't have
                     * IDENT_CURRENT. This is *not* safe for concurrent
                     * requests, and really, if you're using it, you're in a
                     * world of hurt. Nevertheless, it's here to ensure BC. See
                     * bug #181 for the gory details.*/
                    $result = $this->query("SELECT @@IDENTITY FROM $seqname");
                }
                $repeat = 0;
            } else {
                $repeat = false;
            }
        } while ($repeat);
        if (DB::isError($result)) {
            return $this->raiseError($result);
        }
        $result = $result->fetchRow(DB_FETCHMODE_ORDERED);
        return $result[0];
    }

    /**
     * Creates a new sequence
     *
     * @param string $seq_name  name of the new sequence
     *
     * @return int  DB_OK on success.  A DB_Error object on failure.
     *
     * @see DB_common::createSequence(), DB_common::getSequenceName(),
     *      DB_mssql::nextID(), DB_mssql::dropSequence()
     */
    function createSequence($seq_name)
    {
        return $this->query('CREATE TABLE '
                            . $this->getSequenceName($seq_name)
                            . ' ([id] [int] IDENTITY (1, 1) NOT NULL,'
                            . ' [vapor] [int] NULL)');
    }

    // }}}
    // {{{ dropSequence()

    /**
     * Deletes a sequence
     *
     * @param string $seq_name  name of the sequence to be deleted
     *
     * @return int  DB_OK on success.  A DB_Error object on failure.
     *
     * @see DB_common::dropSequence(), DB_common::getSequenceName(),
     *      DB_mssql::nextID(), DB_mssql::createSequence()
     */
    function dropSequence($seq_name)
    {
        return $this->query('DROP TABLE ' . $this->getSequenceName($seq_name));
    }

    // }}}
    // {{{ quoteIdentifier()

    /**
     * Quotes a string so it can be safely used as a table or column name
     *
     * @param string $str  identifier name to be quoted
     *
     * @return string  quoted identifier string
     *
     * @see DB_common::quoteIdentifier()
     * @since Method available since Release 1.6.0
     */
    function quoteIdentifier($str)
    {
        return '[' . str_replace(']', ']]', $str) . ']';
    }

    // }}}
    // {{{ mssqlRaiseError()

    /**
     * Produces a DB_Error object regarding the current problem
     *
     * @param int $errno  if the error is being manually raised pass a
     *                     DB_ERROR* constant here.  If this isn't passed
     *                     the error information gathered from the DBMS.
     *
     * @return object  the DB_Error object
     *
     * @see DB_common::raiseError(),
     *      DB_mssql::errorNative(), DB_mssql::errorCode()
     */
    function mssqlRaiseError($code = null)
    {
        $message = @mssql_get_last_message();
        if (!$code) {
            $code = $this->errorNative();
        }
        return $this->raiseError($this->errorCode($code, $message),
                                 null, null, null, "$code - $message");
    }

    // }}}
    // {{{ errorNative()

    /**
     * Gets the DBMS' native error code produced by the last query
     *
     * @return int  the DBMS' error code
     */
    function errorNative()
    {
        $res = @mssql_query('select @@ERROR as ErrorCode', $this->connection);
        if (!$res) {
            return DB_ERROR;
        }
        $row = @mssql_fetch_row($res);
        return $row[0];
    }

    // }}}
    // {{{ errorCode()

    /**
     * Determines PEAR::DB error code from mssql's native codes.
     *
     * If <var>$nativecode</var> isn't known yet, it will be looked up.
     *
     * @param  mixed  $nativecode  mssql error code, if known
     * @return integer  an error number from a DB error constant
     * @see errorNative()
     */
    function errorCode($nativecode = null, $msg = '')
    {
        if (!$nativecode) {
            $nativecode = $this->errorNative();
        }
        if (isset($this->errorcode_map[$nativecode])) {
            if ($nativecode == 3701
                && preg_match('/Cannot drop the index/i', $msg))
            {
                return DB_ERROR_NOT_FOUND;
            }
            return $this->errorcode_map[$nativecode];
        } else {
            return DB_ERROR;
        }
    }

    // }}}
    // {{{ tableInfo()

    /**
     * Returns information about a table or a result set
     *
     * NOTE: only supports 'table' and 'flags' if <var>$result</var>
     * is a table name.
     *
     * @param object|string  $result  DB_result object from a query or a
     *                                 string containing the name of a table.
     *                                 While this also accepts a query result
     *                                 resource identifier, this behavior is
     *                                 deprecated.
     * @param int            $mode    a valid tableInfo mode
     *
     * @return array  an associative array with the information requested.
     *                 A DB_Error object on failure.
     *
     * @see DB_common::tableInfo()
     */
    function tableInfo($result, $mode = null)
    {
        if (is_string($result)) {
            /*
             * Probably received a table name.
             * Create a result resource identifier.
             */
            if (!@mssql_select_db($this->_db, $this->connection)) {
                return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
            }
            $id = @mssql_query("SELECT * FROM $result WHERE 1=0",
                               $this->connection);
            $got_string = true;
        } elseif (isset($result->result)) {
            /*
             * Probably received a result object.
             * Extract the result resource identifier.
             */
            $id = $result->result;
            $got_string = false;
        } else {
            /*
             * Probably received a result resource identifier.
             * Copy it.
             * Deprecated.  Here for compatibility only.
             */
            $id = $result;
            $got_string = false;
        }

        if (!is_resource($id)) {
            return $this->mssqlRaiseError(DB_ERROR_NEED_MORE_DATA);
        }

        if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE) {
            $case_func = 'strtolower';
        } else {
            $case_func = 'strval';
        }

        $count = @mssql_num_fields($id);
        $res   = array();

        if ($mode) {
            $res['num_fields'] = $count;
        }

        for ($i = 0; $i < $count; $i++) {
            if ($got_string) {
                $flags = $this->_mssql_field_flags($result,
                        @mssql_field_name($id, $i));
                if (DB::isError($flags)) {
                    return $flags;
                }
            } else {
                $flags = '';
            }

            $res[$i] = array(
                'table' => $got_string ? $case_func($result) : '',
                'name'  => $case_func(@mssql_field_name($id, $i)),
                'type'  => @mssql_field_type($id, $i),
                'len'   => @mssql_field_length($id, $i),
                'flags' => $flags,
            );
            if ($mode & DB_TABLEINFO_ORDER) {
                $res['order'][$res[$i]['name']] = $i;
            }
            if ($mode & DB_TABLEINFO_ORDERTABLE) {
                $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i;
            }
        }

        // free the result only if we were called on a table
        if ($got_string) {
            @mssql_free_result($id);
        }
        return $res;
    }

    // }}}
    // {{{ _mssql_field_flags()

    /**
     * Get a column's flags
     *
     * Supports "not_null", "primary_key",
     * "auto_increment" (mssql identity), "timestamp" (mssql timestamp),
     * "unique_key" (mssql unique index, unique check or primary_key) and
     * "multiple_key" (multikey index)
     *
     * mssql timestamp is NOT similar to the mysql timestamp so this is maybe
     * not useful at all - is the behaviour of mysql_field_flags that primary
     * keys are alway unique? is the interpretation of multiple_key correct?
     *
     * @param string $table   the table name
     * @param string $column  the field name
     *
     * @return string  the flags
     *
     * @access private
     * @author Joern Barthel <j_barthel@web.de>
     */
    function _mssql_field_flags($table, $column)
    {
        static $tableName = null;
        static $flags = array();

        if ($table != $tableName) {

            $flags = array();
            $tableName = $table;

            // get unique and primary keys
            $res = $this->getAll("EXEC SP_HELPINDEX $table", DB_FETCHMODE_ASSOC);
            if (DB::isError($res)) {
                return $res;
            }

            foreach ($res as $val) {
                $keys = explode(', ', $val['index_keys']);

                if (sizeof($keys) > 1) {
                    foreach ($keys as $key) {
                        $this->_add_flag($flags[$key], 'multiple_key');
                    }
                }

                if (strpos($val['index_description'], 'primary key')) {
                    foreach ($keys as $key) {
                        $this->_add_flag($flags[$key], 'primary_key');
                    }
                } elseif (strpos($val['index_description'], 'unique')) {
                    foreach ($keys as $key) {
                        $this->_add_flag($flags[$key], 'unique_key');
                    }
                }
            }

            // get auto_increment, not_null and timestamp
            $res = $this->getAll("EXEC SP_COLUMNS $table", DB_FETCHMODE_ASSOC);
            if (DB::isError($res)) {
                return $res;
            }

            foreach ($res as $val) {
                $val = array_change_key_case($val, CASE_LOWER);
                if ($val['nullable'] == '0') {
                    $this->_add_flag($flags[$val['column_name']], 'not_null');
                }
                if (strpos($val['type_name'], 'identity')) {
                    $this->_add_flag($flags[$val['column_name']], 'auto_increment');
                }
                if (strpos($val['type_name'], 'timestamp')) {
                    $this->_add_flag($flags[$val['column_name']], 'timestamp');
                }
            }
        }

        if (array_key_exists($column, $flags)) {
            return(implode(' ', $flags[$column]));
        }
        return '';
    }

    // }}}
    // {{{ _add_flag()

    /**
     * Adds a string to the flags array if the flag is not yet in there
     * - if there is no flag present the array is created
     *
     * @param array  &$array  the reference to the flag-array
     * @param string $value   the flag value
     *
     * @return void
     *
     * @access private
     * @author Joern Barthel <j_barthel@web.de>
     */
    function _add_flag(&$array, $value)
    {
        if (!is_array($array)) {
            $array = array($value);
        } elseif (!in_array($value, $array)) {
            array_push($array, $value);
        }
    }

    // }}}
    // {{{ getSpecialQuery()

    /**
     * Obtains the query string needed for listing a given type of objects
     *
     * @param string $type  the kind of objects you want to retrieve
     *
     * @return string  the SQL query string or null if the driver doesn't
     *                  support the object type requested
     *
     * @access protected
     * @see DB_common::getListOf()
     */
    function getSpecialQuery($type)
    {
        switch ($type) {
            case 'tables':
                return "SELECT name FROM sysobjects WHERE type = 'U'"
                       . ' ORDER BY name';
            case 'views':
                return "SELECT name FROM sysobjects WHERE type = 'V'";
            default:
                return null;
        }
    }

    // }}}
}

/*
 * Local variables:
 * tab-width: 4
 * c-basic-offset: 4
 * End:
 */

?>
 

Редакция 2	Редакция 3
1	<?php	1	<?php
2		2
3	/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */	3	/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
4		4
5	/**	5	/**
6	* The PEAR DB driver for PHP's mssql extension	6	* The PEAR DB driver for PHP's mssql extension
7	* for interacting with Microsoft SQL Server databases	7	* for interacting with Microsoft SQL Server databases
8	*	8	*
9	* PHP versions 4 and 5	9	* PHP versions 4 and 5
10	*	10	*
11	* LICENSE: This source file is subject to version 3.0 of the PHP license	11	* LICENSE: This source file is subject to version 3.0 of the PHP license
12	* that is available through the world-wide-web at the following URI:	12	* that is available through the world-wide-web at the following URI:
13	* http://www.php.net/license/3_0.txt. If you did not receive a copy of	13	* http://www.php.net/license/3_0.txt. If you did not receive a copy of
14	* the PHP License and are unable to obtain it through the web, please	14	* the PHP License and are unable to obtain it through the web, please
15	* send a note to license@php.net so we can mail you a copy immediately.	15	* send a note to license@php.net so we can mail you a copy immediately.
16	*	16	*
17	* @category Database	17	* @category Database
18	* @package DB	18	* @package DB
19	* @author Sterling Hughes <sterling@php.net>	19	* @author Sterling Hughes <sterling@php.net>
20	* @author Daniel Convissor <danielc@php.net>	20	* @author Daniel Convissor <danielc@php.net>
21	* @copyright 1997-2007 The PHP Group	21	* @copyright 1997-2007 The PHP Group
22	* @license http://www.php.net/license/3_0.txt PHP License 3.0	22	* @license http://www.php.net/license/3_0.txt PHP License 3.0
23	* @version CVS: $Id: mssql.php,v 1.92 2007/09/21 13:40:41 aharvey Exp $	23	* @version CVS: $Id: mssql.php,v 1.92 2007/09/21 13:40:41 aharvey Exp $
24	* @link http://pear.php.net/package/DB	24	* @link http://pear.php.net/package/DB
25	*/	25	*/
26		26
27	/**	27	/**
28	* Obtain the DB_common class so it can be extended from	28	* Obtain the DB_common class so it can be extended from
29	*/	29	*/
30	require_once 'DB/common.php';	30	require_once 'DB/common.php';
31		31
32	/**	32	/**
33	* The methods PEAR DB uses to interact with PHP's mssql extension	33	* The methods PEAR DB uses to interact with PHP's mssql extension
34	* for interacting with Microsoft SQL Server databases	34	* for interacting with Microsoft SQL Server databases
35	*	35	*
36	* These methods overload the ones declared in DB_common.	36	* These methods overload the ones declared in DB_common.
37	*	37	*
38	* DB's mssql driver is only for Microsfoft SQL Server databases.	38	* DB's mssql driver is only for Microsfoft SQL Server databases.
39	*	39	*
40	* If you're connecting to a Sybase database, you MUST specify "sybase"	40	* If you're connecting to a Sybase database, you MUST specify "sybase"
41	* as the "phptype" in the DSN.	41	* as the "phptype" in the DSN.
42	*	42	*
43	* This class only works correctly if you have compiled PHP using	43	* This class only works correctly if you have compiled PHP using
44	* --with-mssql=[dir_to_FreeTDS].	44	* --with-mssql=[dir_to_FreeTDS].
45	*	45	*
46	* @category Database	46	* @category Database
47	* @package DB	47	* @package DB
48	* @author Sterling Hughes <sterling@php.net>	48	* @author Sterling Hughes <sterling@php.net>
49	* @author Daniel Convissor <danielc@php.net>	49	* @author Daniel Convissor <danielc@php.net>
50	* @copyright 1997-2007 The PHP Group	50	* @copyright 1997-2007 The PHP Group
51	* @license http://www.php.net/license/3_0.txt PHP License 3.0	51	* @license http://www.php.net/license/3_0.txt PHP License 3.0
52	* @version Release: 1.7.13	52	* @version Release: 1.7.13
53	* @link http://pear.php.net/package/DB	53	* @link http://pear.php.net/package/DB
54	*/	54	*/
55	class DB_mssql extends DB_common	55	class DB_mssql extends DB_common
56	{	56	{
57	// {{{ properties	57	// {{{ properties
58		58
59	/**	59	/**
60	* The DB driver type (mysql, oci8, odbc, etc.)	60	* The DB driver type (mysql, oci8, odbc, etc.)
61	* @var string	61	* @var string
62	*/	62	*/
63	var $phptype = 'mssql';	63	var $phptype = 'mssql';
64		64
65	/**	65	/**
66	* The database syntax variant to be used (db2, access, etc.), if any	66	* The database syntax variant to be used (db2, access, etc.), if any
67	* @var string	67	* @var string
68	*/	68	*/
69	var $dbsyntax = 'mssql';	69	var $dbsyntax = 'mssql';
70		70
71	/**	71	/**
72	* The capabilities of this DB implementation	72	* The capabilities of this DB implementation
73	*	73	*
74	* The 'new_link' element contains the PHP version that first provided	74	* The 'new_link' element contains the PHP version that first provided
75	* new_link support for this DBMS. Contains false if it's unsupported.	75	* new_link support for this DBMS. Contains false if it's unsupported.
76	*	76	*
77	* Meaning of the 'limit' element:	77	* Meaning of the 'limit' element:
78	* + 'emulate' = emulate with fetch row by number	78	* + 'emulate' = emulate with fetch row by number
79	* + 'alter' = alter the query	79	* + 'alter' = alter the query
80	* + false = skip rows	80	* + false = skip rows
81	*	81	*
82	* @var array	82	* @var array
83	*/	83	*/
84	var $features = array(	84	var $features = array(
85	'limit' => 'emulate',	85	'limit' => 'emulate',
86	'new_link' => false,	86	'new_link' => false,
87	'numrows' => true,	87	'numrows' => true,
88	'pconnect' => true,	88	'pconnect' => true,
89	'prepare' => false,	89	'prepare' => false,
90	'ssl' => false,	90	'ssl' => false,
91	'transactions' => true,	91	'transactions' => true,
92	);	92	);
93		93
94	/**	94	/**
95	* A mapping of native error codes to DB error codes	95	* A mapping of native error codes to DB error codes
96	* @var array	96	* @var array
97	*/	97	*/
98	// XXX Add here error codes ie: 'S100E' => DB_ERROR_SYNTAX	98	// XXX Add here error codes ie: 'S100E' => DB_ERROR_SYNTAX
99	var $errorcode_map = array(	99	var $errorcode_map = array(
100	102 => DB_ERROR_SYNTAX,	100	102 => DB_ERROR_SYNTAX,
101	110 => DB_ERROR_VALUE_COUNT_ON_ROW,	101	110 => DB_ERROR_VALUE_COUNT_ON_ROW,
102	155 => DB_ERROR_NOSUCHFIELD,	102	155 => DB_ERROR_NOSUCHFIELD,
103	156 => DB_ERROR_SYNTAX,	103	156 => DB_ERROR_SYNTAX,
104	170 => DB_ERROR_SYNTAX,	104	170 => DB_ERROR_SYNTAX,
105	207 => DB_ERROR_NOSUCHFIELD,	105	207 => DB_ERROR_NOSUCHFIELD,
106	208 => DB_ERROR_NOSUCHTABLE,	106	208 => DB_ERROR_NOSUCHTABLE,
107	245 => DB_ERROR_INVALID_NUMBER,	107	245 => DB_ERROR_INVALID_NUMBER,
108	319 => DB_ERROR_SYNTAX,	108	319 => DB_ERROR_SYNTAX,
109	321 => DB_ERROR_NOSUCHFIELD,	109	321 => DB_ERROR_NOSUCHFIELD,
110	325 => DB_ERROR_SYNTAX,	110	325 => DB_ERROR_SYNTAX,
111	336 => DB_ERROR_SYNTAX,	111	336 => DB_ERROR_SYNTAX,
112	515 => DB_ERROR_CONSTRAINT_NOT_NULL,	112	515 => DB_ERROR_CONSTRAINT_NOT_NULL,
113	547 => DB_ERROR_CONSTRAINT,	113	547 => DB_ERROR_CONSTRAINT,
114	1018 => DB_ERROR_SYNTAX,	114	1018 => DB_ERROR_SYNTAX,
115	1035 => DB_ERROR_SYNTAX,	115	1035 => DB_ERROR_SYNTAX,
116	1913 => DB_ERROR_ALREADY_EXISTS,	116	1913 => DB_ERROR_ALREADY_EXISTS,
117	2209 => DB_ERROR_SYNTAX,	117	2209 => DB_ERROR_SYNTAX,
118	2223 => DB_ERROR_SYNTAX,	118	2223 => DB_ERROR_SYNTAX,
119	2248 => DB_ERROR_SYNTAX,	119	2248 => DB_ERROR_SYNTAX,
120	2256 => DB_ERROR_SYNTAX,	120	2256 => DB_ERROR_SYNTAX,
121	2257 => DB_ERROR_SYNTAX,	121	2257 => DB_ERROR_SYNTAX,
122	2627 => DB_ERROR_CONSTRAINT,	122	2627 => DB_ERROR_CONSTRAINT,
123	2714 => DB_ERROR_ALREADY_EXISTS,	123	2714 => DB_ERROR_ALREADY_EXISTS,
124	3607 => DB_ERROR_DIVZERO,	124	3607 => DB_ERROR_DIVZERO,
125	3701 => DB_ERROR_NOSUCHTABLE,	125	3701 => DB_ERROR_NOSUCHTABLE,
126	7630 => DB_ERROR_SYNTAX,	126	7630 => DB_ERROR_SYNTAX,
127	8134 => DB_ERROR_DIVZERO,	127	8134 => DB_ERROR_DIVZERO,
128	9303 => DB_ERROR_SYNTAX,	128	9303 => DB_ERROR_SYNTAX,
129	9317 => DB_ERROR_SYNTAX,	129	9317 => DB_ERROR_SYNTAX,
130	9318 => DB_ERROR_SYNTAX,	130	9318 => DB_ERROR_SYNTAX,
131	9331 => DB_ERROR_SYNTAX,	131	9331 => DB_ERROR_SYNTAX,
132	9332 => DB_ERROR_SYNTAX,	132	9332 => DB_ERROR_SYNTAX,
133	15253 => DB_ERROR_SYNTAX,	133	15253 => DB_ERROR_SYNTAX,
134	);	134	);
135		135
136	/**	136	/**
137	* The raw database connection created by PHP	137	* The raw database connection created by PHP
138	* @var resource	138	* @var resource
139	*/	139	*/
140	var $connection;	140	var $connection;
141		141
142	/**	142	/**
143	* The DSN information for connecting to a database	143	* The DSN information for connecting to a database
144	* @var array	144	* @var array
145	*/	145	*/
146	var $dsn = array();	146	var $dsn = array();
147		147
148		148
149	/**	149	/**
150	* Should data manipulation queries be committed automatically?	150	* Should data manipulation queries be committed automatically?
151	* @var bool	151	* @var bool
152	* @access private	152	* @access private
153	*/	153	*/
154	var $autocommit = true;	154	var $autocommit = true;
155		155
156	/**	156	/**
157	* The quantity of transactions begun	157	* The quantity of transactions begun
158	*	158	*
159	* {@internal While this is private, it can't actually be designated	159	* {@internal While this is private, it can't actually be designated
160	* private in PHP 5 because it is directly accessed in the test suite.}}	160	* private in PHP 5 because it is directly accessed in the test suite.}}
161	*	161	*
162	* @var integer	162	* @var integer
163	* @access private	163	* @access private
164	*/	164	*/
165	var $transaction_opcount = 0;	165	var $transaction_opcount = 0;
166		166
167	/**	167	/**
168	* The database specified in the DSN	168	* The database specified in the DSN
169	*	169	*
170	* It's a fix to allow calls to different databases in the same script.	170	* It's a fix to allow calls to different databases in the same script.
171	*	171	*
172	* @var string	172	* @var string
173	* @access private	173	* @access private
174	*/	174	*/
175	var $_db = null;	175	var $_db = null;
176		176
177		177
178	// }}}	178	// }}}
179	// {{{ constructor	179	// {{{ constructor
180		180
181	/**	181	/**
182	* This constructor calls <kbd>$this->DB_common()</kbd>	182	* This constructor calls <kbd>$this->DB_common()</kbd>
183	*	183	*
184	* @return void	184	* @return void
185	*/	185	*/
186	function DB_mssql()	186	function DB_mssql()
187	{	187	{
188	$this->DB_common();	188	$this->DB_common();
189	}	189	}
190		190
191	// }}}	191	// }}}
192	// {{{ connect()	192	// {{{ connect()
193		193
194	/**	194	/**
195	* Connect to the database server, log in and open the database	195	* Connect to the database server, log in and open the database
196	*	196	*
197	* Don't call this method directly. Use DB::connect() instead.	197	* Don't call this method directly. Use DB::connect() instead.
198	*	198	*
199	* @param array $dsn the data source name	199	* @param array $dsn the data source name
200	* @param bool $persistent should the connection be persistent?	200	* @param bool $persistent should the connection be persistent?
201	*	201	*
202	* @return int DB_OK on success. A DB_Error object on failure.	202	* @return int DB_OK on success. A DB_Error object on failure.
203	*/	203	*/
204	function connect($dsn, $persistent = false)	204	function connect($dsn, $persistent = false)
205	{	205	{
206	if (!PEAR::loadExtension('mssql') && !PEAR::loadExtension('sybase')	206	if (!PEAR::loadExtension('mssql') && !PEAR::loadExtension('sybase')
207	&& !PEAR::loadExtension('sybase_ct'))	207	&& !PEAR::loadExtension('sybase_ct'))
208	{	208	{
209	return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND);	209	return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND);
210	}	210	}
211		211
212	$this->dsn = $dsn;	212	$this->dsn = $dsn;
213	if ($dsn['dbsyntax']) {	213	if ($dsn['dbsyntax']) {
214	$this->dbsyntax = $dsn['dbsyntax'];	214	$this->dbsyntax = $dsn['dbsyntax'];
215	}	215	}
216		216
217	$params = array(	217	$params = array(
218	$dsn['hostspec'] ? $dsn['hostspec'] : 'localhost',	218	$dsn['hostspec'] ? $dsn['hostspec'] : 'localhost',
219	$dsn['username'] ? $dsn['username'] : null,	219	$dsn['username'] ? $dsn['username'] : null,
220	$dsn['password'] ? $dsn['password'] : null,	220	$dsn['password'] ? $dsn['password'] : null,
221	);	221	);
222	if ($dsn['port']) {	222	if ($dsn['port']) {
223	$params[0] .= ((substr(PHP_OS, 0, 3) == 'WIN') ? ',' : ':')	223	$params[0] .= ((substr(PHP_OS, 0, 3) == 'WIN') ? ',' : ':')
224	. $dsn['port'];	224	. $dsn['port'];
225	}	225	}
226		226
227	$connect_function = $persistent ? 'mssql_pconnect' : 'mssql_connect';	227	$connect_function = $persistent ? 'mssql_pconnect' : 'mssql_connect';
228		228
229	$this->connection = @call_user_func_array($connect_function, $params);	229	$this->connection = @call_user_func_array($connect_function, $params);
230		230
231	if (!$this->connection) {	231	if (!$this->connection) {
232	return $this->raiseError(DB_ERROR_CONNECT_FAILED,	232	return $this->raiseError(DB_ERROR_CONNECT_FAILED,
233	null, null, null,	233	null, null, null,
234	@mssql_get_last_message());	234	@mssql_get_last_message());
235	}	235	}
236	if ($dsn['database']) {	236	if ($dsn['database']) {
237	if (!@mssql_select_db($dsn['database'], $this->connection)) {	237	if (!@mssql_select_db($dsn['database'], $this->connection)) {
238	return $this->raiseError(DB_ERROR_NODBSELECTED,	238	return $this->raiseError(DB_ERROR_NODBSELECTED,
239	null, null, null,	239	null, null, null,
240	@mssql_get_last_message());	240	@mssql_get_last_message());
241	}	241	}
242	$this->_db = $dsn['database'];	242	$this->_db = $dsn['database'];
243	}	243	}
244	return DB_OK;	244	return DB_OK;
245	}	245	}
246		246
247	// }}}	247	// }}}
248	// {{{ disconnect()	248	// {{{ disconnect()
249		249
250	/**	250	/**
251	* Disconnects from the database server	251	* Disconnects from the database server
252	*	252	*
253	* @return bool TRUE on success, FALSE on failure	253	* @return bool TRUE on success, FALSE on failure
254	*/	254	*/
255	function disconnect()	255	function disconnect()
256	{	256	{
257	$ret = @mssql_close($this->connection);	257	$ret = @mssql_close($this->connection);
258	$this->connection = null;	258	$this->connection = null;
259	return $ret;	259	return $ret;
260	}	260	}
261		261
262	// }}}	262	// }}}
263	// {{{ simpleQuery()	263	// {{{ simpleQuery()
264		264
265	/**	265	/**
266	* Sends a query to the database server	266	* Sends a query to the database server
267	*	267	*
268	* @param string the SQL query string	268	* @param string the SQL query string
269	*	269	*
270	* @return mixed + a PHP result resrouce for successful SELECT queries	270	* @return mixed + a PHP result resrouce for successful SELECT queries
271	* + the DB_OK constant for other successful queries	271	* + the DB_OK constant for other successful queries
272	* + a DB_Error object on failure	272	* + a DB_Error object on failure
273	*/	273	*/
274	function simpleQuery($query)	274	function simpleQuery($query)
275	{	275	{
276	$ismanip = $this->_checkManip($query);	276	$ismanip = $this->_checkManip($query);
277	$this->last_query = $query;	277	$this->last_query = $query;
278	if (!@mssql_select_db($this->_db, $this->connection)) {	278	if (!@mssql_select_db($this->_db, $this->connection)) {
279	return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);	279	return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
280	}	280	}
281	$query = $this->modifyQuery($query);	281	$query = $this->modifyQuery($query);
282	if (!$this->autocommit && $ismanip) {	282	if (!$this->autocommit && $ismanip) {
283	if ($this->transaction_opcount == 0) {	283	if ($this->transaction_opcount == 0) {
284	$result = @mssql_query('BEGIN TRAN', $this->connection);	284	$result = @mssql_query('BEGIN TRAN', $this->connection);
285	if (!$result) {	285	if (!$result) {
286	return $this->mssqlRaiseError();	286	return $this->mssqlRaiseError();
287	}	287	}
288	}	288	}
289	$this->transaction_opcount++;	289	$this->transaction_opcount++;
290	}	290	}
291	$result = @mssql_query($query, $this->connection);	291	$result = @mssql_query($query, $this->connection);
292	if (!$result) {	292	if (!$result) {
293	return $this->mssqlRaiseError();	293	return $this->mssqlRaiseError();
294	}	294	}
295	// Determine which queries that should return data, and which	295	// Determine which queries that should return data, and which
296	// should return an error code only.	296	// should return an error code only.
297	return $ismanip ? DB_OK : $result;	297	return $ismanip ? DB_OK : $result;
298	}	298	}
299		299
300	// }}}	300	// }}}
301	// {{{ nextResult()	301	// {{{ nextResult()
302		302
303	/**	303	/**
304	* Move the internal mssql result pointer to the next available result	304	* Move the internal mssql result pointer to the next available result
305	*	305	*
306	* @param a valid fbsql result resource	306	* @param a valid fbsql result resource
307	*	307	*
308	* @access public	308	* @access public
309	*	309	*
310	* @return true if a result is available otherwise return false	310	* @return true if a result is available otherwise return false
311	*/	311	*/
312	function nextResult($result)	312	function nextResult($result)
313	{	313	{
314	return @mssql_next_result($result);	314	return @mssql_next_result($result);
315	}	315	}
316		316
317	// }}}	317	// }}}
318	// {{{ fetchInto()	318	// {{{ fetchInto()
319		319
320	/**	320	/**
321	* Places a row from the result set into the given array	321	* Places a row from the result set into the given array
322	*	322	*
323	* Formating of the array and the data therein are configurable.	323	* Formating of the array and the data therein are configurable.
324	* See DB_result::fetchInto() for more information.	324	* See DB_result::fetchInto() for more information.
325	*	325	*
326	* This method is not meant to be called directly. Use	326	* This method is not meant to be called directly. Use
327	* DB_result::fetchInto() instead. It can't be declared "protected"	327	* DB_result::fetchInto() instead. It can't be declared "protected"
328	* because DB_result is a separate object.	328	* because DB_result is a separate object.
329	*	329	*
330	* @param resource $result the query result resource	330	* @param resource $result the query result resource
331	* @param array $arr the referenced array to put the data in	331	* @param array $arr the referenced array to put the data in
332	* @param int $fetchmode how the resulting array should be indexed	332	* @param int $fetchmode how the resulting array should be indexed
333	* @param int $rownum the row number to fetch (0 = first row)	333	* @param int $rownum the row number to fetch (0 = first row)
334	*	334	*
335	* @return mixed DB_OK on success, NULL when the end of a result set is	335	* @return mixed DB_OK on success, NULL when the end of a result set is
336	* reached or on failure	336	* reached or on failure
337	*	337	*
338	* @see DB_result::fetchInto()	338	* @see DB_result::fetchInto()
339	*/	339	*/
340	function fetchInto($result, &$arr, $fetchmode, $rownum = null)	340	function fetchInto($result, &$arr, $fetchmode, $rownum = null)
341	{	341	{
342	if ($rownum !== null) {	342	if ($rownum !== null) {
343	if (!@mssql_data_seek($result, $rownum)) {	343	if (!@mssql_data_seek($result, $rownum)) {
344	return null;	344	return null;
345	}	345	}
346	}	346	}
347	if ($fetchmode & DB_FETCHMODE_ASSOC) {	347	if ($fetchmode & DB_FETCHMODE_ASSOC) {
348	$arr = @mssql_fetch_assoc($result);	348	$arr = @mssql_fetch_assoc($result);
349	if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE && $arr) {	349	if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE && $arr) {
350	$arr = array_change_key_case($arr, CASE_LOWER);	350	$arr = array_change_key_case($arr, CASE_LOWER);
351	}	351	}
352	} else {	352	} else {
353	$arr = @mssql_fetch_row($result);	353	$arr = @mssql_fetch_row($result);
354	}	354	}
355	if (!$arr) {	355	if (!$arr) {
356	return null;	356	return null;
357	}	357	}
358	if ($this->options['portability'] & DB_PORTABILITY_RTRIM) {	358	if ($this->options['portability'] & DB_PORTABILITY_RTRIM) {
359	$this->_rtrimArrayValues($arr);	359	$this->_rtrimArrayValues($arr);
360	}	360	}
361	if ($this->options['portability'] & DB_PORTABILITY_NULL_TO_EMPTY) {	361	if ($this->options['portability'] & DB_PORTABILITY_NULL_TO_EMPTY) {
362	$this->_convertNullArrayValuesToEmpty($arr);	362	$this->_convertNullArrayValuesToEmpty($arr);
363	}	363	}
364	return DB_OK;	364	return DB_OK;
365	}	365	}
366		366
367	// }}}	367	// }}}
368	// {{{ freeResult()	368	// {{{ freeResult()
369		369
370	/**	370	/**
371	* Deletes the result set and frees the memory occupied by the result set	371	* Deletes the result set and frees the memory occupied by the result set
372	*	372	*
373	* This method is not meant to be called directly. Use	373	* This method is not meant to be called directly. Use
374	* DB_result::free() instead. It can't be declared "protected"	374	* DB_result::free() instead. It can't be declared "protected"
375	* because DB_result is a separate object.	375	* because DB_result is a separate object.
376	*	376	*
377	* @param resource $result PHP's query result resource	377	* @param resource $result PHP's query result resource
378	*	378	*
379	* @return bool TRUE on success, FALSE if $result is invalid	379	* @return bool TRUE on success, FALSE if $result is invalid
380	*	380	*
381	* @see DB_result::free()	381	* @see DB_result::free()
382	*/	382	*/
383	function freeResult($result)	383	function freeResult($result)
384	{	384	{
385	return is_resource($result) ? mssql_free_result($result) : false;	385	return is_resource($result) ? mssql_free_result($result) : false;
386	}	386	}
387		387
388	// }}}	388	// }}}
389	// {{{ numCols()	389	// {{{ numCols()
390		390
391	/**	391	/**
392	* Gets the number of columns in a result set	392	* Gets the number of columns in a result set
393	*	393	*
394	* This method is not meant to be called directly. Use	394	* This method is not meant to be called directly. Use
395	* DB_result::numCols() instead. It can't be declared "protected"	395	* DB_result::numCols() instead. It can't be declared "protected"
396	* because DB_result is a separate object.	396	* because DB_result is a separate object.
397	*	397	*
398	* @param resource $result PHP's query result resource	398	* @param resource $result PHP's query result resource
399	*	399	*
400	* @return int the number of columns. A DB_Error object on failure.	400	* @return int the number of columns. A DB_Error object on failure.
401	*	401	*
402	* @see DB_result::numCols()	402	* @see DB_result::numCols()
403	*/	403	*/
404	function numCols($result)	404	function numCols($result)
405	{	405	{
406	$cols = @mssql_num_fields($result);	406	$cols = @mssql_num_fields($result);
407	if (!$cols) {	407	if (!$cols) {
408	return $this->mssqlRaiseError();	408	return $this->mssqlRaiseError();
409	}	409	}
410	return $cols;	410	return $cols;
411	}	411	}
412		412
413	// }}}	413	// }}}
414	// {{{ numRows()	414	// {{{ numRows()
415		415
416	/**	416	/**
417	* Gets the number of rows in a result set	417	* Gets the number of rows in a result set
418	*	418	*
419	* This method is not meant to be called directly. Use	419	* This method is not meant to be called directly. Use
420	* DB_result::numRows() instead. It can't be declared "protected"	420	* DB_result::numRows() instead. It can't be declared "protected"
421	* because DB_result is a separate object.	421	* because DB_result is a separate object.
422	*	422	*
423	* @param resource $result PHP's query result resource	423	* @param resource $result PHP's query result resource
424	*	424	*
425	* @return int the number of rows. A DB_Error object on failure.	425	* @return int the number of rows. A DB_Error object on failure.
426	*	426	*
427	* @see DB_result::numRows()	427	* @see DB_result::numRows()
428	*/	428	*/
429	function numRows($result)	429	function numRows($result)
430	{	430	{
431	$rows = @mssql_num_rows($result);	431	$rows = @mssql_num_rows($result);
432	if ($rows === false) {	432	if ($rows === false) {
433	return $this->mssqlRaiseError();	433	return $this->mssqlRaiseError();
434	}	434	}
435	return $rows;	435	return $rows;
436	}	436	}
437		437
438	// }}}	438	// }}}
439	// {{{ autoCommit()	439	// {{{ autoCommit()
440		440
441	/**	441	/**
442	* Enables or disables automatic commits	442	* Enables or disables automatic commits
443	*	443	*
444	* @param bool $onoff true turns it on, false turns it off	444	* @param bool $onoff true turns it on, false turns it off
445	*	445	*
446	* @return int DB_OK on success. A DB_Error object if the driver	446	* @return int DB_OK on success. A DB_Error object if the driver
447	* doesn't support auto-committing transactions.	447	* doesn't support auto-committing transactions.
448	*/	448	*/
449	function autoCommit($onoff = false)	449	function autoCommit($onoff = false)
450	{	450	{
451	// XXX if $this->transaction_opcount > 0, we should probably	451	// XXX if $this->transaction_opcount > 0, we should probably
452	// issue a warning here.	452	// issue a warning here.
453	$this->autocommit = $onoff ? true : false;	453	$this->autocommit = $onoff ? true : false;
454	return DB_OK;	454	return DB_OK;
455	}	455	}
456		456
457	// }}}	457	// }}}
458	// {{{ commit()	458	// {{{ commit()
459		459
460	/**	460	/**
461	* Commits the current transaction	461	* Commits the current transaction
462	*	462	*
463	* @return int DB_OK on success. A DB_Error object on failure.	463	* @return int DB_OK on success. A DB_Error object on failure.
464	*/	464	*/
465	function commit()	465	function commit()
466	{	466	{
467	if ($this->transaction_opcount > 0) {	467	if ($this->transaction_opcount > 0) {
468	if (!@mssql_select_db($this->_db, $this->connection)) {	468	if (!@mssql_select_db($this->_db, $this->connection)) {
469	return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);	469	return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
470	}	470	}
471	$result = @mssql_query('COMMIT TRAN', $this->connection);	471	$result = @mssql_query('COMMIT TRAN', $this->connection);
472	$this->transaction_opcount = 0;	472	$this->transaction_opcount = 0;
473	if (!$result) {	473	if (!$result) {
474	return $this->mssqlRaiseError();	474	return $this->mssqlRaiseError();
475	}	475	}
476	}	476	}
477	return DB_OK;	477	return DB_OK;
478	}	478	}
479		479
480	// }}}	480	// }}}
481	// {{{ rollback()	481	// {{{ rollback()
482		482
483	/**	483	/**
484	* Reverts the current transaction	484	* Reverts the current transaction
485	*	485	*
486	* @return int DB_OK on success. A DB_Error object on failure.	486	* @return int DB_OK on success. A DB_Error object on failure.
487	*/	487	*/
488	function rollback()	488	function rollback()
489	{	489	{
490	if ($this->transaction_opcount > 0) {	490	if ($this->transaction_opcount > 0) {
491	if (!@mssql_select_db($this->_db, $this->connection)) {	491	if (!@mssql_select_db($this->_db, $this->connection)) {
492	return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);	492	return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED);
493	}	493	}
494	$result = @mssql_query('ROLLBACK TRAN', $this->connection);	494	$result = @mssql_query('ROLLBACK TRAN', $this->connection);
495	$this->transaction_opcount = 0;	495	$this->transaction_opcount = 0;
496	if (!$result) {	496	if (!$result) {
497	return $this->mssqlRaiseError();	497	return $this->mssqlRaiseError();
498	}	498	}
499	}	499	}
500	return DB_OK;	500	return DB_OK;

Хранилища Subversion ant

(root)/tags/0.1alpha2/mssql.php - Редакция 2 → 3