xref: /PHP-5.3/ext/mysqli/tests/047.phpt (revision ad8892f9)
1--TEST--
2mysqli_stmt_result_metadata
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifconnectfailure.inc');
7?>
8--FILE--
9<?php
10	require_once("connect.inc");
11
12	/*** test mysqli_connect 127.0.0.1 ***/
13	$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
14
15	mysqli_select_db($link, $db);
16
17	mysqli_query($link, "DROP TABLE IF EXISTS test_affected");
18	mysqli_query($link, "CREATE TABLE test_affected (foo int, bar varchar(10) character set latin1) ENGINE=" . $engine);
19
20	mysqli_query($link, "INSERT INTO test_affected VALUES (1, 'Zak'),(2, 'Greant')");
21
22	$stmt = mysqli_prepare($link, "SELECT * FROM test_affected");
23	mysqli_stmt_execute($stmt);
24	$result = mysqli_stmt_result_metadata($stmt);
25
26	echo "\n=== fetch_fields ===\n";
27	var_dump(mysqli_fetch_fields($result));
28
29	echo "\n=== fetch_field_direct ===\n";
30	var_dump(mysqli_fetch_field_direct($result, 0));
31	var_dump(mysqli_fetch_field_direct($result, 1));
32
33	echo "\n=== fetch_field ===\n";
34	while ($field = mysqli_fetch_field($result)) {
35		var_dump($field);
36	}
37
38	print_r(mysqli_fetch_lengths($result));
39
40	mysqli_free_result($result);
41
42
43	mysqli_stmt_close($stmt);
44	mysqli_query($link, "DROP TABLE IF EXISTS test_affected");
45	mysqli_close($link);
46	print "done!";
47?>
48--CLEAN--
49<?php
50require_once("connect.inc");
51if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
52   printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
53
54if (!mysqli_query($link, "DROP TABLE IF EXISTS test_affected"))
55	printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
56
57mysqli_close($link);
58?>
59--EXPECTF--
60=== fetch_fields ===
61array(2) {
62  [0]=>
63  object(stdClass)#5 (13) {
64    [%u|b%"name"]=>
65    %unicode|string%(3) "foo"
66    [%u|b%"orgname"]=>
67    %unicode|string%(3) "foo"
68    [%u|b%"table"]=>
69    %unicode|string%(13) "test_affected"
70    [%u|b%"orgtable"]=>
71    %unicode|string%(13) "test_affected"
72    [%u|b%"def"]=>
73    %unicode|string%(0) ""
74    [%u|b%"db"]=>
75    %unicode|string%(%d) "%s"
76    [%u|b%"catalog"]=>
77    %unicode|string%(%d) "%s"
78    [%u|b%"max_length"]=>
79    int(0)
80    [%u|b%"length"]=>
81    int(%d)
82    [%u|b%"charsetnr"]=>
83    int(%d)
84    [%u|b%"flags"]=>
85    int(32768)
86    [%u|b%"type"]=>
87    int(3)
88    [%u|b%"decimals"]=>
89    int(0)
90  }
91  [1]=>
92  object(stdClass)#6 (13) {
93    [%u|b%"name"]=>
94    %unicode|string%(3) "bar"
95    [%u|b%"orgname"]=>
96    %unicode|string%(3) "bar"
97    [%u|b%"table"]=>
98    %unicode|string%(13) "test_affected"
99    [%u|b%"orgtable"]=>
100    %unicode|string%(13) "test_affected"
101    [%u|b%"def"]=>
102    %unicode|string%(0) ""
103    [%u|b%"db"]=>
104    %unicode|string%(%d) "%s"
105    [%u|b%"catalog"]=>
106    %unicode|string%(%d) "%s"
107    [%u|b%"max_length"]=>
108    int(0)
109    [%u|b%"length"]=>
110    int(%d)
111    [%u|b%"charsetnr"]=>
112    int(%d)
113    [%u|b%"flags"]=>
114    int(0)
115    [%u|b%"type"]=>
116    int(253)
117    [%u|b%"decimals"]=>
118    int(0)
119  }
120}
121
122=== fetch_field_direct ===
123object(stdClass)#6 (13) {
124  [%u|b%"name"]=>
125  %unicode|string%(3) "foo"
126  [%u|b%"orgname"]=>
127  %unicode|string%(3) "foo"
128  [%u|b%"table"]=>
129  %unicode|string%(13) "test_affected"
130  [%u|b%"orgtable"]=>
131  %unicode|string%(13) "test_affected"
132  [%u|b%"def"]=>
133  %unicode|string%(0) ""
134  [%u|b%"db"]=>
135  %unicode|string%(%d) "%s"
136  [%u|b%"catalog"]=>
137  %unicode|string%(%d) "%s"
138  [%u|b%"max_length"]=>
139  int(0)
140  [%u|b%"length"]=>
141  int(%d)
142  [%u|b%"charsetnr"]=>
143  int(%d)
144  [%u|b%"flags"]=>
145  int(32768)
146  [%u|b%"type"]=>
147  int(3)
148  [%u|b%"decimals"]=>
149  int(0)
150}
151object(stdClass)#6 (13) {
152  [%u|b%"name"]=>
153  %unicode|string%(3) "bar"
154  [%u|b%"orgname"]=>
155  %unicode|string%(3) "bar"
156  [%u|b%"table"]=>
157  %unicode|string%(13) "test_affected"
158  [%u|b%"orgtable"]=>
159  %unicode|string%(13) "test_affected"
160  [%u|b%"def"]=>
161  %unicode|string%(0) ""
162  [%u|b%"db"]=>
163  %unicode|string%(%d) "%s"
164  [%u|b%"catalog"]=>
165  %unicode|string%(%d) "%s"
166  [%u|b%"max_length"]=>
167  int(0)
168  [%u|b%"length"]=>
169  int(%d)
170  [%u|b%"charsetnr"]=>
171  int(%d)
172  [%u|b%"flags"]=>
173  int(0)
174  [%u|b%"type"]=>
175  int(253)
176  [%u|b%"decimals"]=>
177  int(0)
178}
179
180=== fetch_field ===
181object(stdClass)#6 (13) {
182  [%u|b%"name"]=>
183  %unicode|string%(3) "foo"
184  [%u|b%"orgname"]=>
185  %unicode|string%(3) "foo"
186  [%u|b%"table"]=>
187  %unicode|string%(13) "test_affected"
188  [%u|b%"orgtable"]=>
189  %unicode|string%(13) "test_affected"
190  [%u|b%"def"]=>
191  %unicode|string%(0) ""
192  [%u|b%"db"]=>
193  %unicode|string%(%d) "%s"
194  [%u|b%"catalog"]=>
195  %unicode|string%(%d) "%s"
196  [%u|b%"max_length"]=>
197  int(0)
198  [%u|b%"length"]=>
199  int(%d)
200  [%u|b%"charsetnr"]=>
201  int(%d)
202  [%u|b%"flags"]=>
203  int(32768)
204  [%u|b%"type"]=>
205  int(3)
206  [%u|b%"decimals"]=>
207  int(0)
208}
209object(stdClass)#5 (13) {
210  [%u|b%"name"]=>
211  %unicode|string%(3) "bar"
212  [%u|b%"orgname"]=>
213  %unicode|string%(3) "bar"
214  [%u|b%"table"]=>
215  %unicode|string%(13) "test_affected"
216  [%u|b%"orgtable"]=>
217  %unicode|string%(13) "test_affected"
218  [%u|b%"def"]=>
219  %unicode|string%(0) ""
220  [%u|b%"db"]=>
221  %unicode|string%(%d) "%s"
222  [%u|b%"catalog"]=>
223  %unicode|string%(%d) "%s"
224  [%u|b%"max_length"]=>
225  int(0)
226  [%u|b%"length"]=>
227  int(%d)
228  [%u|b%"charsetnr"]=>
229  int(%d)
230  [%u|b%"flags"]=>
231  int(0)
232  [%u|b%"type"]=>
233  int(253)
234  [%u|b%"decimals"]=>
235  int(0)
236}
237done!