net.php.pear/Tree/OptionsDB.php

<?php
# i think this class should go somewhere in a common PEAR-place,
# but since it is not very fancy to crowd the PEAR-namespace too much i dont know where to put it yet :-(

//
// +----------------------------------------------------------------------+
// | PHP Version 4                                                        |
// +----------------------------------------------------------------------+
// | Copyright (c) 1997-2003 The PHP Group                                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.02 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          |
// | license@php.net so we can mail you a copy immediately.               |
// +----------------------------------------------------------------------+
// | Authors: Wolfram Kriesing <wolfram@kriesing.de>                      |
// +----------------------------------------------------------------------+
//
//  $Id: OptionsDB.php,v 1.4 2003/01/04 11:56:27 mj Exp $

require_once('Tree/Options.php');

/**
*   this class additionally retreives a DB connection and saves it
*   in the property "dbh"
*
*   @package  Tree
*   @access   public
*   @author   Wolfram Kriesing <wolfram@kriesing.de>
*
*/
class Tree_OptionsDB extends Tree_Options
{
    /**
    *   @var    object
    */
    var $dbh;

    /**
    *   this constructor sets the options, since i normally need this and
    *   in case the constructor doesnt need to do anymore i already have it done :-)
    *
    *   @version    02/01/08
    *   @access     public
    *   @author     Wolfram Kriesing <wolfram@kriesing.de>
    *   @param      boolean true if loggedIn
    */
    function Tree_OptionsDB( $dsn , $options=array() )
    {
        $res = $this->_connectDB( $dsn );
        if( !PEAR::isError($res) )
        {
            $this->dbh->setFetchmode(DB_FETCHMODE_ASSOC);
        }
        else
        {
            return $res;
        }

        $this->Tree_Options( $options );          // do options afterwards since it overrules
    }

    /**
     * Connect to database by using the given DSN string
     *
     * @author  copied from PEAR::Auth, Martin Jansen, slightly modified
     * @access private
     * @param  string DSN string
     * @return mixed  Object on error, otherwise bool
     */
    function _connectDB( $dsn )
    {
        // only include the db if one really wants to connect
        require_once('DB.php');

        if (is_string($dsn) || is_array($dsn) )
        {
            // put the dsn parameters in an array
            // DB would be confused with an additional URL-queries, like ?table=...
            // so we do it before connecting to the DB
            if( is_string($dsn) )
                $dsn = DB::parseDSN( $dsn );

            $this->dbh = DB::Connect($dsn);
        }
        else
        {
            if(get_parent_class($dsn) == "db_common")
            {
                $this->dbh = $dsn;
            }
            else
            {
                if (is_object($dsn) && DB::isError($dsn))
                {
                    return new DB_Error($dsn->code, PEAR_ERROR_DIE);
                }
                else
                {
                    return new PEAR_Error("The given dsn was not valid in file " . __FILE__ . " at line " . __LINE__,
                                41,
                                PEAR_ERROR_RETURN,
                                null,
                                null
                                );

                }
            }
        }

        if (DB::isError($this->dbh))
            return new DB_Error($this->dbh->code, PEAR_ERROR_DIE);

        return true;
    }

} // end of class
?>
1	<?php
2	# i think this class should go somewhere in a common PEAR-place,
3	# but since it is not very fancy to crowd the PEAR-namespace too much i dont know where to put it yet :-(
4
5	//
6	// +----------------------------------------------------------------------+
7	// \| PHP Version 4 \|
8	// +----------------------------------------------------------------------+
9	// \| Copyright (c) 1997-2003 The PHP Group \|
10	// +----------------------------------------------------------------------+
11	// \| This source file is subject to version 2.02 of the PHP license, \|
12	// \| that is bundled with this package in the file LICENSE, and is \|
13	// \| available at through the world-wide-web at \|
14	// \| http://www.php.net/license/2_02.txt. \|
15	// \| If you did not receive a copy of the PHP license and are unable to \|
16	// \| obtain it through the world-wide-web, please send a note to \|
17	// \| license@php.net so we can mail you a copy immediately. \|
18	// +----------------------------------------------------------------------+
19	// \| Authors: Wolfram Kriesing <wolfram@kriesing.de> \|
20	// +----------------------------------------------------------------------+
21	//
22	// $Id: OptionsDB.php,v 1.4 2003/01/04 11:56:27 mj Exp $
23
24	require_once('Tree/Options.php');
25
26	/**
27	* this class additionally retreives a DB connection and saves it
28	* in the property "dbh"
29	*
30	* @package Tree
31	* @access public
32	* @author Wolfram Kriesing <wolfram@kriesing.de>
33	*
34	*/
35	class Tree_OptionsDB extends Tree_Options
36	{
37	/**
38	* @var object
39	*/
40	var $dbh;
41
42	/**
43	* this constructor sets the options, since i normally need this and
44	* in case the constructor doesnt need to do anymore i already have it done :-)
45	*
46	* @version 02/01/08
47	* @access public
48	* @author Wolfram Kriesing <wolfram@kriesing.de>
49	* @param boolean true if loggedIn
50	*/
51	function Tree_OptionsDB( $dsn , $options=array() )
52	{
53	$res = $this->_connectDB( $dsn );
54	if( !PEAR::isError($res) )
55	{
56	$this->dbh->setFetchmode(DB_FETCHMODE_ASSOC);
57	}
58	else
59	{
60	return $res;
61	}
62
63	$this->Tree_Options( $options ); // do options afterwards since it overrules
64	}
65
66	/**
67	* Connect to database by using the given DSN string
68	*
69	* @author copied from PEAR::Auth, Martin Jansen, slightly modified
70	* @access private
71	* @param string DSN string
72	* @return mixed Object on error, otherwise bool
73	*/
74	function _connectDB( $dsn )
75	{
76	// only include the db if one really wants to connect
77	require_once('DB.php');
78
79	if (is_string($dsn) \|\| is_array($dsn) )
80	{
81	// put the dsn parameters in an array
82	// DB would be confused with an additional URL-queries, like ?table=...
83	// so we do it before connecting to the DB
84	if( is_string($dsn) )
85	$dsn = DB::parseDSN( $dsn );
86
87	$this->dbh = DB::Connect($dsn);
88	}
89	else
90	{
91	if(get_parent_class($dsn) == "db_common")
92	{
93	$this->dbh = $dsn;
94	}
95	else
96	{
97	if (is_object($dsn) && DB::isError($dsn))
98	{
99	return new DB_Error($dsn->code, PEAR_ERROR_DIE);
100	}
101	else
102	{
103	return new PEAR_Error("The given dsn was not valid in file " . __FILE__ . " at line " . __LINE__,
104	41,
105	PEAR_ERROR_RETURN,
106	null,
107	null
108	);
109
110	}
111	}
112	}
113
114	if (DB::isError($this->dbh))
115	return new DB_Error($this->dbh->code, PEAR_ERROR_DIE);
116
117	return true;
118	}
119
120	} // end of class
121	?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26