23
23
require('table.inc');
25
$charsets = my_get_charsets($link);
25
26
if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) {
26
27
printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
29
while ($tmp = mysqli_fetch_field($res))
30
/* ID column, binary charset */
31
$tmp = mysqli_fetch_field($res);
34
/* label column, result set charset */
35
$tmp = mysqli_fetch_field($res);
37
if ($tmp->charsetnr != $charsets['results']['nr']) {
38
printf("[004] Expecting charset %s/%d got %d\n",
39
$charsets['results']['charset'],
40
$charsets['results']['nr'], $tmp->charsetnr);
42
if ($tmp->length != (1 * $charsets['results']['maxlen'])) {
43
printf("[005] Expecting length %d got %d\n",
44
$charsets['results']['maxlen'],
48
var_dump(mysqli_fetch_field($res));
33
50
mysqli_free_result($res);
35
52
// Read http://bugs.php.net/bug.php?id=42344 on defaults!
36
53
if (NULL !== ($tmp = mysqli_fetch_field($res)))
37
printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
54
printf("[006] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
39
56
if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
40
printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
57
printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
42
59
if (!mysqli_query($link, "CREATE TABLE test(id INT NOT NULL DEFAULT 1)"))
43
printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
60
printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
45
62
if (!mysqli_query($link, "INSERT INTO test(id) VALUES (2)"))
46
printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
63
printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
48
65
if (!$res = mysqli_query($link, "SELECT id as _default_test FROM test")) {
49
printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
66
printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
51
68
var_dump(mysqli_fetch_assoc($res));
52
70
var_dump(mysqli_fetch_field($res));
53
71
mysqli_free_result($res);