mdb.php

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· PHP 代码 · 共 137 行

<?php
//
// +----------------------------------------------------------------------+
// | PEAR :: DB_NestedSet_MDB                                             |
// +----------------------------------------------------------------------+
// | Copyright (c) 1997-2003 The PHP Group                                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the PHP license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available at through the world-wide-web at                           |
// | http://www.php.net/license/2_02.txt.                                 |
// | If you did not receive a copy of the PHP license and are unable to   |
// | obtain it through the world-wide-web, please send a note to          |
// | [e-mail] so we can mail you a copy immediately.               |
// +----------------------------------------------------------------------+
// | Authors: Daniel Khan <[e-mail]>                              |
// +----------------------------------------------------------------------+
// Thanks to Hans Lellelid for suggesting support for PEAR::MDB
// and for his help in implementing this.
//
// $Id: MDB.php,v 1.7 2003/10/07 00:11:27 datenpunk Exp $
//

require_once 'MDB.php';

// {{{ DB_NestedSet_MDB:: class

/**
* Wrapper class for PEAR::MDB
*
* @author       Daniel Khan <[e-mail]>
* @package      DB_NestedSet
* @version      $Revision: 1.7 $
* @access       public
*/
// }}}
class DB_NestedSet_MDB extends DB_NestedSet {
    // {{{ properties

    /**
    * @var object The MDB object
    */
    var $db;

    // }}}
    // {{{ constructor

    /**
    * Constructor
    *
    * @param mixed $dsn DSN as PEAR dsn URI or dsn Array
    * @param array $params Database column fields which should be returned
    *
    */
    function DB_NestedSet_MDB($dsn, $params = array())
    {
        $this->_debugMessage('DB_NestedSet_MDB($dsn, $params = array())');
        $this->DB_NestedSet($params);
        $this->db =& $this->_db_Connect($dsn);
        $this->db->setFetchMode(MDB_FETCHMODE_ASSOC);
    }

    // }}}
    // {{{ destructor

    /**
    * Destructor
    */
    function _DB_NestedSet_MDB()
    {
        $this->_debugMessage('_DB_NestedSet_MDB()');
        $this->_DB_NestedSet();
        $this->_db_Disconnect();
    }

    // }}}
    // {{{ _db_Connect()

    /**
    * Connects to the db
    *
    * @return object DB The database object
    * @access private
    */
    function &_db_Connect($dsn)
    {
        $this->_debugMessage('_db_Connect($dsn)');
        if (is_object($this->db)) {
            return $this->db;
        }

        $db =& MDB::connect($dsn);
        $this->_testFatalAbort($db, __FILE__, __LINE__);

        return $db;
    }

    // }}}

    function _isDBError($err) {
        if(!MDB::isError($err)) {
            return false;
        }
        return true;
    }

    function _numRows($res) {
        return $this->db->numRows($res);
    }

    function _quote($str) {
        return $this->db->getTextValue($str);
    }

    // {{{ _db_Disconnect()

    /**
    * Disconnects from db
    *
    * @return void
    * @access private
    */
    function _db_Disconnect()
    {
        $this->_debugMessage('_db_Disconnect()');
        if (is_object($this->db)) {
            @$this->db->disconnect();
        }

        return true;
    }

    // }}}
}

?>