Lines Matching refs:mysqli
14 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
17 $mysqli->query('DROP TABLE IF EXISTS test');
18 $mysqli->query('CREATE TABLE test (first int) ENGINE = InnoDB');
19 $mysqli->query('INSERT INTO test VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
21 function testStmtStoreResult(mysqli $mysqli, string $name) {
22 $mysqli->query("SET innodb_lock_wait_timeout = 1");
23 $mysqli->query("START TRANSACTION");
26 $stmt = $mysqli->prepare($query);
35 function testStmtGetResult(mysqli $mysqli, string $name) {
36 $mysqli->query("SET innodb_lock_wait_timeout = 1");
37 $mysqli->query("START TRANSACTION");
40 $stmt = $mysqli->prepare($query);
49 function testNormalQuery(mysqli $mysqli, string $name) {
50 $mysqli->query("SET innodb_lock_wait_timeout = 1");
51 $mysqli->query("START TRANSACTION");
55 $res = $mysqli->query($query);
61 function testStmtUseResult(mysqli $mysqli, string $name) {
62 $mysqli->query("SET innodb_lock_wait_timeout = 1");
63 $mysqli->query("START TRANSACTION");
66 $stmt = $mysqli->prepare($query);
76 function testResultFetchRow(mysqli $mysqli, string $name) {
77 $mysqli->query("SET innodb_lock_wait_timeout = 1");
78 $mysqli->query("START TRANSACTION");
81 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
91 testStmtStoreResult($mysqli, 'first connection');
94 $mysqli->close();
99 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
102 testStmtGetResult($mysqli, 'first connection');
105 $mysqli->close();
110 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
113 testNormalQuery($mysqli, 'first connection');
116 $mysqli->close();
121 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
124 testStmtUseResult($mysqli, 'first connection');
127 $mysqli->close();
132 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
135 testResultFetchRow($mysqli, 'first connection');
138 $mysqli->close();
