}
$stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
return $stmt;
}
require_once "connect.inc";
$mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
if (!$IS_MYSQLND && mysqli_get_client_version() < 50009 || mysqli_get_server_version($mysql) < 50009) {
/* we really want to skip it... */
die(var_dump(63));
}
$a = array();
for ($i = 0; $i < 3; $i++) {
$mysql->query("DROP TABLE IF EXISTS test_067_table_1{$i}");
$mysql->query("CREATE TABLE test_067_table_1{$i} (a int not null) ENGINE=" . $engine);
$mysql->query("INSERT INTO test_067_table_1{$i} VALUES (1),(2),(3),(4),(5),(6)");
$stmt[$i] = open_cursor($mysql, "SELECT a FROM test_067_table_1{$i}");
$stmt[$i]->execute();
$stmt[$i]->bind_result($a[$i]);
}
$cnt = 0;
while ($stmt[0]->fetch()) {
$stmt[1]->fetch();
$stmt[2]->fetch();
$cnt += $a[0] + $a[1] + $a[2];
}
for ($i = 0; $i < 3; $i++) {
$stmt[$i]->close();
}
$mysql->close();
var_dump($cnt);
error_reporting(0);
printf("[001] Cannot create statement object for '%s', [%d] %s\n", $query, $mysql->errno, $mysql->error);
}
$stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
return $stmt;
}
require_once "connect.inc";
$mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
if (!$IS_MYSQLND && mysqli_get_client_version() < 50009 || mysqli_get_server_version($mysql) < 50009) {
/* we really want to skip it... */
die(var_dump(63));
}
$a = array();
for ($i = 0; $i < 3; $i++) {
$mysql->query("DROP TABLE IF EXISTS cursor{$i}");
$mysql->query("CREATE TABLE cursor{$i} (a int not null) ENGINE=" . $engine);
$mysql->query("INSERT INTO cursor{$i} VALUES (1),(2),(3),(4),(5),(6)");
$stmt[$i] = open_cursor($mysql, "SELECT a FROM cursor{$i}");
$stmt[$i]->execute();
$stmt[$i]->bind_result($a[$i]);
}
$cnt = 0;
while ($stmt[0]->fetch()) {
$stmt[1]->fetch();
$stmt[2]->fetch();
$cnt += $a[0] + $a[1] + $a[2];
}
for ($i = 0; $i < 3; $i++) {
$stmt[$i]->close();
}
$mysql->close();
var_dump($cnt);
