Annotation of embedaddon/php/ext/mysqli/tests/mysqli_stmt_errno.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli_stmt_errno()
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 (!is_null($tmp = @mysqli_stmt_errno()))
17: printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
18:
19: if (!is_null($tmp = @mysqli_stmt_errno($link)))
20: printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
21:
22: require('table.inc');
23:
24: if (!$stmt = mysqli_stmt_init($link))
25: printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
26:
27: // properly initialized?
28: if (0 !== ($tmp = mysqli_stmt_errno($stmt)))
29: printf("[004] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp);
30:
31: if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
32: printf("[005] Statement should have failed!\n");
33:
34: // set after error server?
35: if (0 === ($tmp = mysqli_stmt_errno($stmt)))
36: printf("[006] Expecting int/any non zero, got %s/%s\n", gettype($tmp), $tmp);
37:
38: if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
39: printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40:
41: // reset after error & success
42: if (0 != ($tmp = mysqli_stmt_errno($stmt)))
43: printf("[008] Expecting zero, got %s/%s\n", gettype($tmp), $tmp);
44:
45: mysqli_kill($link, mysqli_thread_id($link));
46:
47: if (true === ($tmp = mysqli_stmt_execute($stmt)))
48: printf("[009] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
49:
50: // set after client error
51: if (0 === ($tmp = mysqli_stmt_errno($stmt)))
52: printf("[010] Execting int/any non zero, got %s/%s\n", gettype($tmp), $tmp);
53:
54: mysqli_stmt_close($stmt);
55:
56: if (NULL !== ($tmp = mysqli_stmt_errno($stmt)))
57: printf("[011] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
58:
59: mysqli_close($link);
60: print "done!";
61: ?>
62: --CLEAN--
63: <?php
64: require_once("clean_table.inc");
65: ?>
66: --EXPECTF--
67: Warning: mysqli_stmt_errno(): Couldn't fetch mysqli_stmt in %s on line %d
68: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>