1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
<?php
/**
* Establishes the include_path, DSN's and connection $options
*
* If this file is named "setup.inc.cvs," it is the original one from CVS.
* Please do the following:
* 1) Make a copy of this file named "setup.inc".
* 2) Then, in the copy, edit the $dsns array as appropriate for your
* environment.
* 3) At least one element of the $dsns array needs to be uncommented.
*
* 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 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 $Id$
* @link http://pear.php.net/package/DB
*/
if (!defined('PATH_SEPARATOR')) {
if (stristr(PHP_OS, 'WIN')) {
/**
* The string used to delimit elements of the path.
*/
define('PATH_SEPARATOR', ';');
} else {
/**
* The string used to delimit elements of the path.
*/
define('PATH_SEPARATOR', ':');
}
}
/*
* If the path to your PEAR installation is found in the left hand
* portion of the if() expression below, that means this file has
* come from the PEAR installer. Therefore, let's use the
* installed version of DB, which should be found via the
* computer's default include_path. Add '.' to the include_path
* to ensure '.' is in there.
*
* If the path has not been substituted in the if() expression,
* this file has likely come from a CVS checkout or a .tar file.
* Therefore, we'll assume the tests should use the version of
* DB that has come from there as well.
*/
if ('@include_path@' != '@'.'include_path'.'@') {
ini_set('include_path', ini_get('include_path')
. PATH_SEPARATOR . '.'
);
} else {
ini_set('include_path', realpath(dirname(__FILE__) . '/../..')
. PATH_SEPARATOR . '.' . PATH_SEPARATOR
. ini_get('include_path')
);
}
/**
* Grab the PEAR DB classes.
*/
require_once 'DB.php';
// Options used when connecting
$options = array(
//'optimize' => 'portability',
'portability' => DB_PORTABILITY_ALL,
'debug' => 2,
);
$dbasedsn = array(
'phptype' => 'dbase',
'database' => '/path/and/name/of/dbase/file',
'mode' => 2,
'fields' => array(
array('a', 'N', 5, 0),
array('b', 'C', 40),
array('c', 'C', 255),
array('d', 'C', 20),
),
);
/*
* Uncomment at least one of the following elements.
* When running the .phpt tests, the first uncommented element is used.
* When running the multiconnect.php test, all uncommented elements are used.
*/
$dsns = array(
// 'dbase' => $dbasedsn,
// 'fbsql' => 'fbsql://_system:@/db',
// 'firebird' => 'ibase(firebird)://SYSDBA:masterkey@//opt/interbase/examples/employee.gdb?dialect=3',
// 'ifx' => 'ifx://user:pw@localhost/db',
// 'msql' => 'msql:///db',
// It's advisable to use only one of the following at a time:
// 'mssql' => 'mssql://sa@somehost/pubs',
// 'sybase' => 'sybase://sa@somehost/pubs',
// 'mysql' => 'mysql://root@localhost/test',
// 'mysqli' => 'mysqli://root@localhost/test', // $_ENV overrides if set.
// 'oci8' => 'oci8://system:manager@',
// 'access' => 'odbc(access)://admin@/SystemDsnName',
// 'db2' => 'odbc(db2)://db2inst1:XXXX@/SAMPLE',
// 'pgsql' => 'pgsql://postgres@localhost/test',
// 'sqlite' => 'sqlite://dummy:@localhost/' . getcwd() . DIRECTORY_SEPARATOR . 'test.db?mode=0644',
// 'sqlite3' => 'sqlite3://dummy:@localhost/' . getcwd() . DIRECTORY_SEPARATOR . 'test.db?mode=0644',
);
if (getenv('MYSQL_TEST_USER')) {
$dsns['mysqli'] = array(
'phptype' => 'mysqli',
'username' => getenv('MYSQL_TEST_USER'),
'password' => getenv('MYSQL_TEST_PASSWD'),
'database' => getenv('MYSQL_TEST_DB'),
'hostspec' => getenv('MYSQL_TEST_HOST') == ''
? null : getenv('MYSQL_TEST_HOST'),
'port' => getenv('MYSQL_TEST_PORT') == ''
? null : getenv('MYSQL_TEST_PORT'),
'socket' => getenv('MYSQL_TEST_SOCKET') == ''
? null : getenv('MYSQL_TEST_SOCKET'),
);
}
|
