mysqli_class_mysqli_interface.phpt 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316
  1. --TEST--
  2. Interface of the class 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('connect.inc');
  12. $mysqli = new mysqli($host, $user, $passwd, $db, $port, $socket);
  13. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  14. printf("Parent class:\n");
  15. var_dump(get_parent_class($mysqli));
  16. printf("\nMethods:\n");
  17. $methods = get_class_methods($mysqli);
  18. $expected_methods = array(
  19. 'autocommit' => true,
  20. 'begin_transaction' => true,
  21. 'change_user' => true,
  22. 'character_set_name' => true,
  23. 'close' => true,
  24. 'commit' => true,
  25. 'connect' => true,
  26. 'dump_debug_info' => true,
  27. 'escape_string' => true,
  28. 'get_charset' => true,
  29. 'get_client_info' => true,
  30. 'get_server_info' => true,
  31. 'get_warnings' => true,
  32. 'init' => true,
  33. 'kill' => true,
  34. 'more_results' => true,
  35. 'multi_query' => true,
  36. 'mysqli' => true,
  37. 'next_result' => true,
  38. 'options' => true,
  39. 'ping' => true,
  40. 'prepare' => true,
  41. 'query' => true,
  42. 'real_connect' => true,
  43. 'real_escape_string' => true,
  44. 'real_query' => true,
  45. 'refresh' => true,
  46. 'rollback' => true,
  47. 'release_savepoint' => true,
  48. 'savepoint' => true,
  49. 'select_db' => true,
  50. 'set_charset' => true,
  51. 'set_opt' => true,
  52. 'ssl_set' => true,
  53. 'stat' => true,
  54. 'stmt_init' => true,
  55. 'store_result' => true,
  56. 'thread_safe' => true,
  57. 'use_result' => true,
  58. );
  59. if (version_compare(PHP_VERSION, '5.3.99', '<=')) {
  60. $expected_methods['client_encoding'] = true;
  61. }
  62. if ($IS_MYSQLND) {
  63. // mysqlnd only
  64. /* $expected_methods['get_client_stats'] = true; */
  65. $expected_methods['get_connection_stats'] = true;
  66. $expected_methods['reap_async_query'] = true;
  67. $expected_methods['poll'] = true;
  68. }
  69. /* we should add ruled when to expect them */
  70. if (function_exists('mysqli_debug'))
  71. $expected_methods['debug'] = true;
  72. if (function_exists('ssl_set'))
  73. $expected_methods['ssl_set'] = true;
  74. foreach ($methods as $k => $method) {
  75. if (isset($expected_methods[$method])) {
  76. unset($methods[$k]);
  77. unset($expected_methods[$method]);
  78. }
  79. }
  80. if (!empty($methods)) {
  81. printf("Dumping list of unexpected methods.\n");
  82. var_dump($methods);
  83. }
  84. if (!empty($expected_methods)) {
  85. printf("Dumping list of missing methods.\n");
  86. var_dump($expected_methods);
  87. }
  88. if (empty($methods) && empty($expected_methods))
  89. printf("ok\n");
  90. printf("\nClass variables:\n");
  91. $expected_class_variables = $expected_object_variables = array(
  92. "affected_rows" => true,
  93. "client_info" => true,
  94. "client_version" => true,
  95. "connect_errno" => true,
  96. "connect_error" => true,
  97. "errno" => true,
  98. "error" => true,
  99. "field_count" => true,
  100. "host_info" => true,
  101. "info" => true,
  102. "insert_id" => true,
  103. "protocol_version" => true,
  104. "server_info" => true,
  105. "server_version" => true,
  106. "sqlstate" => true,
  107. "stat" => true,
  108. "thread_id" => true,
  109. "warning_count" => true,
  110. );
  111. if (version_compare(PHP_VERSION, '5.3.99', '>')) {
  112. $expected_class_variables["error_list"] = true;
  113. $expected_object_variables["error_list"] = true;
  114. }
  115. $variables = get_class_vars(get_class($mysqli));
  116. foreach ($variables as $var => $v) {
  117. if (isset($expected_class_variables[$var])) {
  118. unset($expected_class_variables[$var]);
  119. unset($variables[$var]);
  120. }
  121. }
  122. if (!empty($expected_class_variables)) {
  123. printf("Dumping list of missing class variables\n");
  124. var_dump($expected_class_variables);
  125. }
  126. if (!empty($variables)) {
  127. printf("Dumping list of unexpected class variables\n");
  128. var_dump($variables);
  129. }
  130. echo "ok\n";
  131. printf("\nObject variables:\n");
  132. $variables = get_object_vars($mysqli);
  133. foreach ($variables as $var => $v) {
  134. if (isset($expected_object_variables[$var])) {
  135. unset($expected_object_variables[$var]);
  136. unset($variables[$var]);
  137. }
  138. }
  139. if (!empty($expected_object_variables)) {
  140. printf("Dumping list of missing object variables\n");
  141. var_dump($expected_object_variables);
  142. }
  143. if (!empty($variables)) {
  144. printf("Dumping list of unexpected object variables\n");
  145. var_dump($variables);
  146. }
  147. echo "ok\n";
  148. printf("\nMagic, magic properties:\n");
  149. assert(mysqli_affected_rows($link) === $mysqli->affected_rows);
  150. printf("mysqli->affected_rows = '%s'/%s ('%s'/%s)\n",
  151. $mysqli->affected_rows, gettype($mysqli->affected_rows),
  152. mysqli_affected_rows($link), gettype(mysqli_affected_rows($link)));
  153. assert(mysqli_get_client_info() === $mysqli->client_info);
  154. printf("mysqli->client_info = '%s'/%s ('%s'/%s)\n",
  155. $mysqli->client_info, gettype($mysqli->client_info),
  156. mysqli_get_client_info(), gettype(mysqli_get_client_info()));
  157. assert(mysqli_get_client_version() === $mysqli->client_version);
  158. printf("mysqli->client_version = '%s'/%s ('%s'/%s)\n",
  159. $mysqli->client_version, gettype($mysqli->client_version),
  160. mysqli_get_client_version(), gettype(mysqli_get_client_version()));
  161. assert(mysqli_errno($link) === $mysqli->errno);
  162. printf("mysqli->errno = '%s'/%s ('%s'/%s)\n",
  163. $mysqli->errno, gettype($mysqli->errno),
  164. mysqli_errno($link), gettype(mysqli_errno($link)));
  165. assert(mysqli_error($link) === $mysqli->error);
  166. printf("mysqli->error = '%s'/%s ('%s'/%s)\n",
  167. $mysqli->error, gettype($mysqli->error),
  168. mysqli_error($link), gettype(mysqli_error($link)));
  169. if (version_compare(PHP_VERSION, '5.3.99', '>')) {
  170. assert(mysqli_error_list($link) === $mysqli->error_list);
  171. assert(is_array($mysqli->error_list));
  172. }
  173. assert(mysqli_field_count($link) === $mysqli->field_count);
  174. printf("mysqli->field_count = '%s'/%s ('%s'/%s)\n",
  175. $mysqli->field_count, gettype($mysqli->field_count),
  176. mysqli_field_count($link), gettype(mysqli_field_count($link)));
  177. assert(mysqli_insert_id($link) === $mysqli->insert_id);
  178. printf("mysqli->insert_id = '%s'/%s ('%s'/%s)\n",
  179. $mysqli->insert_id, gettype($mysqli->insert_id),
  180. mysqli_insert_id($link), gettype(mysqli_insert_id($link)));
  181. assert(mysqli_sqlstate($link) === $mysqli->sqlstate);
  182. printf("mysqli->sqlstate = '%s'/%s ('%s'/%s)\n",
  183. $mysqli->sqlstate, gettype($mysqli->sqlstate),
  184. mysqli_sqlstate($link), gettype(mysqli_sqlstate($link)));
  185. assert(soundex(mysqli_stat($link)) == soundex($mysqli->stat));
  186. printf("mysqli->stat = '%s'/%s ('%s'/%s)\n",
  187. $mysqli->stat, gettype($mysqli->stat),
  188. mysqli_stat($link), gettype(mysqli_stat($link)));
  189. assert(mysqli_get_host_info($link) === $mysqli->host_info);
  190. printf("mysqli->host_info = '%s'/%s ('%s'/%s)\n",
  191. $mysqli->host_info, gettype($mysqli->host_info),
  192. mysqli_get_host_info($link), gettype(mysqli_get_host_info($link)));
  193. /* note that the data types are different */
  194. assert(mysqli_info($link) == $mysqli->info);
  195. printf("mysqli->info = '%s'/%s ('%s'/%s)\n",
  196. $mysqli->info, gettype($mysqli->info),
  197. mysqli_info($link), gettype(mysqli_info($link)));
  198. assert(mysqli_thread_id($link) > $mysqli->thread_id);
  199. assert(gettype($mysqli->thread_id) == gettype(mysqli_thread_id($link)));
  200. printf("mysqli->thread_id = '%s'/%s ('%s'/%s)\n",
  201. $mysqli->thread_id, gettype($mysqli->thread_id),
  202. mysqli_thread_id($link), gettype(mysqli_thread_id($link)));
  203. assert(mysqli_get_proto_info($link) === $mysqli->protocol_version);
  204. printf("mysqli->protocol_version = '%s'/%s ('%s'/%s)\n",
  205. $mysqli->protocol_version, gettype($mysqli->protocol_version),
  206. mysqli_get_proto_info($link), gettype(mysqli_get_proto_info($link)));
  207. assert(mysqli_get_server_info($link) === $mysqli->server_info);
  208. printf("mysqli->server_info = '%s'/%s ('%s'/%s)\n",
  209. $mysqli->server_info, gettype($mysqli->server_info),
  210. mysqli_get_server_info($link), gettype(mysqli_get_server_info($link)));
  211. assert(mysqli_get_server_version($link) === $mysqli->server_version);
  212. printf("mysqli->server_version = '%s'/%s ('%s'/%s)\n",
  213. $mysqli->server_version, gettype($mysqli->server_version),
  214. mysqli_get_server_version($link), gettype(mysqli_get_server_version($link)));
  215. assert(mysqli_warning_count($link) === $mysqli->warning_count);
  216. printf("mysqli->warning_count = '%s'/%s ('%s'/%s)\n",
  217. $mysqli->warning_count, gettype($mysqli->warning_count),
  218. mysqli_warning_count($link), gettype(mysqli_warning_count($link)));
  219. printf("\nAccess to undefined properties:\n");
  220. printf("mysqli->unknown = '%s'\n", @$mysqli->unknown);
  221. @$mysqli->unknown = 13;
  222. printf("setting mysqli->unknown, mysqli_unknown = '%s'\n", @$mysqli->unknown);
  223. $unknown = 'friday';
  224. @$mysqli->unknown = $unknown;
  225. printf("setting mysqli->unknown, mysqli_unknown = '%s'\n", @$mysqli->unknown);
  226. $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
  227. printf("\nAccess hidden properties for MYSLQI_STATUS_INITIALIZED (TODO documentation):\n");
  228. assert(mysqli_connect_error() === $mysqli->connect_error);
  229. printf("mysqli->connect_error = '%s'/%s ('%s'/%s)\n",
  230. $mysqli->connect_error, gettype($mysqli->connect_error),
  231. mysqli_connect_error(), gettype(mysqli_connect_error()));
  232. assert(mysqli_connect_errno() === $mysqli->connect_errno);
  233. printf("mysqli->connect_errno = '%s'/%s ('%s'/%s)\n",
  234. $mysqli->connect_errno, gettype($mysqli->connect_errno),
  235. mysqli_connect_errno(), gettype(mysqli_connect_errno()));
  236. print "done!";
  237. ?>
  238. --EXPECTF--
  239. Parent class:
  240. bool(false)
  241. Methods:
  242. ok
  243. Class variables:
  244. ok
  245. Object variables:
  246. ok
  247. Magic, magic properties:
  248. mysqli->affected_rows = '%s'/integer ('%s'/integer)
  249. mysqli->client_info = '%s'/%unicode|string% ('%s'/%unicode|string%)
  250. mysqli->client_version = '%d'/integer ('%d'/integer)
  251. mysqli->errno = '0'/integer ('0'/integer)
  252. mysqli->error = ''/%unicode|string% (''/%unicode|string%)
  253. mysqli->field_count = '0'/integer ('0'/integer)
  254. mysqli->insert_id = '0'/integer ('0'/integer)
  255. mysqli->sqlstate = '00000'/%unicode|string% ('00000'/%unicode|string%)
  256. mysqli->stat = 'Uptime: %d Threads: %d Questions: %d Slow queries: %d Opens: %d Flush tables: %d Open tables: %d Queries per second avg: %d.%d'/string ('Uptime: %d Threads: %d Questions: %d Slow queries: %d Opens: %d Flush tables: %d Open tables: %d Queries per second avg: %d.%d'/string)
  257. mysqli->host_info = '%s'/%unicode|string% ('%s'/%unicode|string%)
  258. mysqli->info = ''/NULL (''/NULL)
  259. mysqli->thread_id = '%d'/integer ('%d'/integer)
  260. mysqli->protocol_version = '%d'/integer ('%d'/integer)
  261. mysqli->server_info = '%s'/%unicode|string% ('%s'/%unicode|string%)
  262. mysqli->server_version = '%d'/integer ('%d'/integer)
  263. mysqli->warning_count = '0'/integer ('0'/integer)
  264. Access to undefined properties:
  265. mysqli->unknown = ''
  266. setting mysqli->unknown, mysqli_unknown = '13'
  267. setting mysqli->unknown, mysqli_unknown = 'friday'
  268. Access hidden properties for MYSLQI_STATUS_INITIALIZED (TODO documentation):
  269. mysqli->connect_error = ''/NULL (''/NULL)
  270. mysqli->connect_errno = '0'/integer ('0'/integer)
  271. done!