summaryrefslogtreecommitdiff
path: root/ext/mysqli/tests/bug62046.phpt
blob: 5913ef399e54dcb62719531b02aa5efa758aac16 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
--TEST--
Bug #62046 	mysqli@mysqlnd can't iterate over stored sets after call to mysqli_stmt_reset()
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifconnectfailure.inc');
?>
--FILE--
<?php
    require_once("connect.inc");

    if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
        printf("[001] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
    }
    if (FALSE === ($stmt = $link->prepare('SELECT 42'))) {
        printf("[002] Prepare failed, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
    }
    if (FALSE === $stmt->execute()) {
        printf("[003] Execute failed, [%d] %s\n", $stmt->errorno, $stmt->error);
    }
    if (FALSE === $stmt->store_result()) {
        printf("[004] store_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
    }
    $one = NULL;
    if (FALSE === $stmt->bind_result($one)) {
        printf("[005] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
    }
    if (FALSE === $stmt->reset()) {
        printf("[006] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
    }
    while ($stmt->fetch()) {
        var_dump($one);
    }
    $stmt->close();
    $link->close();
    echo "done!";
?>
--EXPECT--
int(42)
done!