1 |
joko |
1.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 |
|
|
// $Id: OptionsDB.php,v 1.4 2003/01/04 11:56:27 mj Exp $ |
24 |
|
|
|
25 |
|
|
require_once('Tree/Options.php'); |
26 |
|
|
|
27 |
|
|
/** |
28 |
|
|
* this class additionally retreives a DB connection and saves it |
29 |
|
|
* in the property "dbh" |
30 |
|
|
* |
31 |
|
|
* @package Tree |
32 |
|
|
* @access public |
33 |
|
|
* @author Wolfram Kriesing <wolfram@kriesing.de> |
34 |
|
|
* |
35 |
|
|
*/ |
36 |
|
|
class Tree_OptionsDB extends Tree_Options |
37 |
|
|
{ |
38 |
|
|
/** |
39 |
|
|
* @var object |
40 |
|
|
*/ |
41 |
|
|
var $dbh; |
42 |
|
|
|
43 |
|
|
/** |
44 |
|
|
* this constructor sets the options, since i normally need this and |
45 |
|
|
* in case the constructor doesnt need to do anymore i already have it done :-) |
46 |
|
|
* |
47 |
|
|
* @version 02/01/08 |
48 |
|
|
* @access public |
49 |
|
|
* @author Wolfram Kriesing <wolfram@kriesing.de> |
50 |
|
|
* @param boolean true if loggedIn |
51 |
|
|
*/ |
52 |
|
|
function Tree_OptionsDB( $dsn , $options=array() ) |
53 |
|
|
{ |
54 |
|
|
$res = $this->_connectDB( $dsn ); |
55 |
|
|
if( !PEAR::isError($res) ) |
56 |
|
|
{ |
57 |
|
|
$this->dbh->setFetchmode(DB_FETCHMODE_ASSOC); |
58 |
|
|
} |
59 |
|
|
else |
60 |
|
|
{ |
61 |
|
|
return $res; |
62 |
|
|
} |
63 |
|
|
|
64 |
|
|
$this->Tree_Options( $options ); // do options afterwards since it overrules |
65 |
|
|
} |
66 |
|
|
|
67 |
|
|
/** |
68 |
|
|
* Connect to database by using the given DSN string |
69 |
|
|
* |
70 |
|
|
* @author copied from PEAR::Auth, Martin Jansen, slightly modified |
71 |
|
|
* @access private |
72 |
|
|
* @param string DSN string |
73 |
|
|
* @return mixed Object on error, otherwise bool |
74 |
|
|
*/ |
75 |
|
|
function _connectDB( $dsn ) |
76 |
|
|
{ |
77 |
|
|
// only include the db if one really wants to connect |
78 |
|
|
require_once('DB.php'); |
79 |
|
|
|
80 |
|
|
if (is_string($dsn) || is_array($dsn) ) |
81 |
|
|
{ |
82 |
|
|
// put the dsn parameters in an array |
83 |
|
|
// DB would be confused with an additional URL-queries, like ?table=... |
84 |
|
|
// so we do it before connecting to the DB |
85 |
|
|
if( is_string($dsn) ) |
86 |
|
|
$dsn = DB::parseDSN( $dsn ); |
87 |
|
|
|
88 |
|
|
$this->dbh = DB::Connect($dsn); |
89 |
|
|
} |
90 |
|
|
else |
91 |
|
|
{ |
92 |
|
|
if(get_parent_class($dsn) == "db_common") |
93 |
|
|
{ |
94 |
|
|
$this->dbh = $dsn; |
95 |
|
|
} |
96 |
|
|
else |
97 |
|
|
{ |
98 |
|
|
if (is_object($dsn) && DB::isError($dsn)) |
99 |
|
|
{ |
100 |
|
|
return new DB_Error($dsn->code, PEAR_ERROR_DIE); |
101 |
|
|
} |
102 |
|
|
else |
103 |
|
|
{ |
104 |
|
|
return new PEAR_Error("The given dsn was not valid in file " . __FILE__ . " at line " . __LINE__, |
105 |
|
|
41, |
106 |
|
|
PEAR_ERROR_RETURN, |
107 |
|
|
null, |
108 |
|
|
null |
109 |
|
|
); |
110 |
|
|
|
111 |
|
|
} |
112 |
|
|
} |
113 |
|
|
} |
114 |
|
|
|
115 |
|
|
if (DB::isError($this->dbh)) |
116 |
|
|
return new DB_Error($this->dbh->code, PEAR_ERROR_DIE); |
117 |
|
|
|
118 |
|
|
return true; |
119 |
|
|
} |
120 |
|
|
|
121 |
|
|
} // end of class |
122 |
|
|
?> |