xref: /PHP-8.0/ext/mysqli/tests/bug49027.phpt (revision e3e67b72)
1--TEST--
2Bug #49027 (mysqli_options() doesn't work when using mysqlnd)
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifconnectfailure.inc');
7?>
8--FILE--
9<?php
10    include ("connect.inc");
11
12    $link = mysqli_init();
13    if (!mysqli_options($link, MYSQLI_INIT_COMMAND, "SELECT 1")) {
14        printf("[001] Cannot set INIT_COMMAND\n");
15    }
16
17    if (!my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket)) {
18        printf("[002] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
19    }
20
21    var_dump($link->query("SELECT 42")->fetch_row());
22
23    if (!mysqli_query($link, "DROP TABLE IF EXISTS test") ||
24        !mysqli_query($link, sprintf("CREATE TABLE test(id INT) ENGINE=%s", $engine))) {
25        printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
26    }
27
28    mysqli_close($link);
29
30    $link = mysqli_init();
31    if (!mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(id) VALUES(1)")) {
32        printf("[004] Cannot set INIT_COMMAND\n");
33    }
34
35    if (!my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket)) {
36        printf("[005] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
37    }
38
39    if (!$res = mysqli_query($link, "SELECT id FROM test"))
40        printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
41
42    var_dump(mysqli_fetch_assoc($res));
43
44    mysqli_free_result($res);
45    mysqli_close($link);
46
47    print "done!";
48?>
49--CLEAN--
50<?php
51    require_once("clean_table.inc");
52?>
53--EXPECT--
54array(1) {
55  [0]=>
56  string(2) "42"
57}
58array(1) {
59  ["id"]=>
60  string(1) "1"
61}
62done!
63