Annotation of embedaddon/php/ext/mysqli/tests/mysqli_connect_oo_defaults.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: new mysqli()
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifemb.inc');
7: require_once('skipifconnectfailure.inc');
8: ?>
9: --FILE--
10: <?php
11: require_once("connect.inc");
12:
13: $tmp = NULL;
14: $link = NULL;
15:
16: if ($socket != "")
17: /* mysqli.default_socket requires non-empty string */
18: ini_set('mysqli.default_socket', 'socket');
19:
20: ini_set('mysqli.default_port', 9999);
21: ini_set('mysqli.default_pw', 'password');
22: ini_set('mysqli.default_user', 'user');
23: ini_set('mysqli.default_host', 'host');
24:
25: mysqli_report(MYSQLI_REPORT_OFF);
26: mysqli_report(MYSQLI_REPORT_STRICT);
27:
28: if ($socket != "") {
29: ini_set('mysqli.default_socket', $socket);
30: try {
31: $mysqli = mysqli_init();
32: $mysqli->real_connect($host, $user, $passwd, $db, $port);
33:
34: if (!$res = $mysqli->query("SELECT 'mysqli.default_socket' AS testing"))
35: printf("[001] [%d] %s\n", $mysqli->errno, $mysqli->error);
36: $tmp = $res->fetch_assoc();
37: $res->free_result();
38:
39: if (!isset($tmp['testing']) || $tmp['testing'] != 'mysqli.default_socket') {
40: printf("[002] mysqli.default_socket not properly set?\n");
41: var_dump($tmp);
42: }
43:
44: $mysqli->close();
45:
46: } catch (mysqli_sql_exception $e) {
47: printf("%s\n", $e->getMessage());
48: printf("[002] Usage of mysqli.default_socket failed\n");
49: }
50: }
51:
52: ini_set('mysqli.default_port', $port);
53: try {
54: $mysqli = mysqli_init();
55: $mysqli->real_connect($host, $user, $passwd, $db);
56:
57: if (!$res = $mysqli->query("SELECT 'mysqli.default_port' AS testing"))
58: printf("[003] [%d] %s\n", $mysqli->errno, $mysqli->error);
59: var_dump($res->fetch_assoc());
60: $res->free_result();
61:
62: $mysqli->close();
63:
64: } catch (mysqli_sql_exception $e) {
65: printf("%s\n", $e->getMessage());
66: printf("[004] Usage of mysqli.default_port failed\n");
67: }
68:
69: ini_set('mysqli.default_pw', $passwd);
70: try {
71: $mysqli = mysqli_init();
72: $mysqli->real_connect($host, $user);
73: $mysqli->select_db($db);
74:
75: if (!$res = $mysqli->query("SELECT 'mysqli.default_pw' AS testing"))
76: printf("[005] [%d] %s\n", $mysqli->errno, $mysqli->error);
77: var_dump($res->fetch_assoc());
78: $res->free_result();
79:
80: $mysqli->close();
81:
82: } catch (mysqli_sql_exception $e) {
83: printf("%s\n", $e->getMessage());
84: printf("[006] Usage of mysqli.default_pw failed\n");
85: }
86:
87: ini_set('mysqli.default_user', $user);
88: try {
89: $mysqli = mysqli_init();
90: $mysqli->real_connect($host);
91: $mysqli->select_db($db);
92:
93: if (!$res = $mysqli->query("SELECT 'mysqli.default_user' AS testing"))
94: printf("[007] [%d] %s\n", $mysqli->errno, $mysqli->error);
95: var_dump($res->fetch_assoc());
96: $res->free_result();
97:
98: $mysqli->close();
99:
100: } catch (mysqli_sql_exception $e) {
101: printf("%s\n", $e->getMessage());
102: printf("[008] Usage of mysqli.default_user failed\n");
103: }
104:
105: ini_set('mysqli.default_host', $host);
106: try {
107: $mysqli = mysqli_init();
108: $mysqli->real_connect();
109: $mysqli->select_db($db);
110:
111: if (!$res = $mysqli->query("SELECT 1"))
112: printf("[009] [%d] %s\n", $mysqli->errno, $mysqli->error);
113: $res->free_result();
114:
115: if (!$res = $mysqli->query("SELECT SUBSTRING_INDEX(USER(),'@',1) AS username"))
116: printf("[010] [%d] %s\n", $mysqli->errno, $mysqli->error);
117:
118: $tmp = $res->fetch_assoc();
119: $res->free_result();
120: if ($tmp['username'] !== $user)
121: printf("[011] Expecting string/%s, got %s/%s\n", $user, gettype($tmp['username']), $tmp['username']);
122:
123: $mysqli->close();
124:
125: } catch (mysqli_sql_exception $e) {
126: printf("%s\n", $e->getMessage());
127: printf("[012] Usage of mysqli.default_host failed\n");
128: }
129:
130: try {
131: $link = mysqli_connect($host, $user, $passwd, null, ini_get('mysqli.default_port'));
132: mysqli_select_db($link, $db);
133: if (!$res = mysqli_query($link, "SELECT 'have been set' AS all_defaults"))
134: printf("[013] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
135: var_dump(mysqli_fetch_assoc($res));
136: mysqli_free_result($res);
137: mysqli_close($link);
138: } catch (mysqli_sql_exception $e) {
139: printf("%s\n", $e->getMessage());
140: printf("[014] Usage of mysqli_connect() has failed\n");
141: }
142:
143: try {
144: $link = mysqli_connect($host, $user, $passwd, null);
145: mysqli_select_db($link, $db);
146: if (!$res = mysqli_query($link, "SELECT 'have been set' AS all_defaults"))
147: printf("[015] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
148: var_dump(mysqli_fetch_assoc($res));
149: mysqli_free_result($res);
150: mysqli_close($link);
151: } catch (mysqli_sql_exception $e) {
152: printf("%s\n", $e->getMessage());
153: printf("[016] Usage of mysqli_connect() has failed\n");
154: }
155:
156:
157: print "done!";
158: ?>
159: --EXPECTF--
160: array(1) {
161: [%u|b%"testing"]=>
162: %unicode|string%(19) "mysqli.default_port"
163: }
164: array(1) {
165: [%u|b%"testing"]=>
166: %unicode|string%(17) "mysqli.default_pw"
167: }
168: array(1) {
169: [%u|b%"testing"]=>
170: %unicode|string%(19) "mysqli.default_user"
171: }
172: array(1) {
173: [%u|b%"all_defaults"]=>
174: %unicode|string%(13) "have been set"
175: }
176: array(1) {
177: [%u|b%"all_defaults"]=>
178: %unicode|string%(13) "have been set"
179: }
180: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>