Annotation of embedaddon/php/ext/mysqli/tests/mysqli_fetch_object.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli_fetch_object()
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: include_once("connect.inc");
12:
13: $tmp = NULL;
14: $link = NULL;
15:
16: if (!is_null($tmp = @mysqli_fetch_object()))
17: printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
18:
19: if (!is_null($tmp = @mysqli_fetch_object($link)))
20: printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
21:
22: require('table.inc');
23: if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) {
24: printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
25: }
26:
27: $obj = mysqli_fetch_object($res);
28: if (($obj->ID !== "1") || ($obj->label !== "a") || (get_class($obj) != 'stdClass')) {
29: printf("[004] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link));
30: var_dump($obj);
31: }
32:
33: class mysqli_fetch_object_test {
34:
35: public $a = null;
36: public $b = null;
37:
38: public function toString() {
39: var_dump($this);
40: }
41: }
42:
43: $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_test');
44: if (($obj->ID !== "2") || ($obj->label !== "b") || ($obj->a !== NULL) || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_test')) {
45: printf("[005] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link));
46: var_dump($obj);
47: }
48:
49:
50:
51: class mysqli_fetch_object_construct extends mysqli_fetch_object_test {
52:
53: public function __construct($a, $b) {
54: $this->a = $a;
55: $this->b = $b;
56: }
57:
58: }
59:
60: $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', null);
61:
62: if (($obj->ID !== "3") || ($obj->label !== "c") || ($obj->a !== NULL) || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_construct')) {
63: printf("[006] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link));
64: var_dump($obj);
65: }
66:
67: $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', array('a'));
68: if (($obj->ID !== "4") || ($obj->label !== "d") || ($obj->a !== 'a') || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_construct')) {
69: printf("[007] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link));
70: var_dump($obj);
71: }
72:
73: $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', array('a', 'b'));
74: if (($obj->ID !== "5") || ($obj->label !== "e") || ($obj->a !== 'a') || ($obj->b !== 'b') || (get_class($obj) != 'mysqli_fetch_object_construct')) {
75: printf("[008] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link));
76: var_dump($obj);
77: }
78:
79: var_dump(mysqli_fetch_object($res, 'mysqli_fetch_object_construct', array('a', 'b', 'c')));
80: var_dump(mysqli_fetch_object($res));
81:
82: mysqli_free_result($res);
83:
84: if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST")) {
85: printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
86: }
87:
88: mysqli_free_result($res);
89: var_dump(mysqli_fetch_object($res));
90:
91: if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5"))
92: printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
93:
94: /*
95: TODO
96: I'm using the procedural interface, this should not throw an exception.
97: Also, I did not ask to get exceptions using the mysqli_options()
98: */
99: try {
100: if (false !== ($obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', 'a')))
101: printf("[011] Should have failed\n");
102: } catch (Exception $e) {
103: printf("%s\n", $e->getMessage());
104: }
105:
106: mysqli_free_result($res);
107:
108: if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5"))
109: printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
110:
111: class mysqli_fetch_object_private_constructor extends mysqli_fetch_object_test {
112:
113: private function __construct($a, $b) {
114: $this->a = $a;
115: $this->b = $b;
116: }
117: }
118: /*
119: TODO
120: I think we should bail out here. The following line will give a Fatal error: Call to private ... from invalid context
121: var_dump($obj = new mysqli_fetch_object_private_constructor(1, 2));
122: This does not fail.
123: */
124: $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_private_constructor', array('a', 'b'));
125: mysqli_free_result($res);
126:
127: // Fatal error, script execution will end
128: var_dump(mysqli_fetch_object($res, 'this_class_does_not_exist'));
129:
130:
131: mysqli_close($link);
132: print "done!";
133: ?>
134: --CLEAN--
135: <?php
136: require_once("clean_table.inc");
137: ?>
138: --EXPECTF--
139: Warning: Missing argument 1 for mysqli_fetch_object_construct::__construct() in %s on line %d
140:
141: Warning: Missing argument 2 for mysqli_fetch_object_construct::__construct() in %s on line %d
142:
143: Notice: Undefined variable: a in %s on line %d
144:
145: Notice: Undefined variable: b in %s on line %d
146:
147: Warning: Missing argument 2 for mysqli_fetch_object_construct::__construct() in %s on line %d
148:
149: Notice: Undefined variable: b in %s on line %d
150: NULL
151: NULL
152:
153: Warning: mysqli_fetch_object(): Couldn't fetch mysqli_result in %s on line %d
154: NULL
155: Parameter ctor_params must be an array
156:
157: Fatal error: Class 'this_class_does_not_exist' not found in %s on line %d
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to mysqli_fetch_object.phpt CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests