Lines Matching refs:mysqli
4 mysqli
16 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
19 $mysqli->query('DROP TABLE IF EXISTS test');
20 $mysqli->query('CREATE TABLE test (first int) ENGINE = InnoDB');
21 $mysqli->query('INSERT INTO test VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
23 function testStmtStoreResult(mysqli $mysqli, string $name) {
24 $mysqli->query("SET innodb_lock_wait_timeout = 1");
25 $mysqli->query("START TRANSACTION");
28 $stmt = $mysqli->prepare($query);
37 function testStmtGetResult(mysqli $mysqli, string $name) {
38 $mysqli->query("SET innodb_lock_wait_timeout = 1");
39 $mysqli->query("START TRANSACTION");
42 $stmt = $mysqli->prepare($query);
51 function testNormalQuery(mysqli $mysqli, string $name) {
52 $mysqli->query("SET innodb_lock_wait_timeout = 1");
53 $mysqli->query("START TRANSACTION");
57 $res = $mysqli->query($query);
63 function testStmtUseResult(mysqli $mysqli, string $name) {
64 $mysqli->query("SET innodb_lock_wait_timeout = 1");
65 $mysqli->query("START TRANSACTION");
68 $stmt = $mysqli->prepare($query);
78 function testResultFetchRow(mysqli $mysqli, string $name) {
79 $mysqli->query("SET innodb_lock_wait_timeout = 1");
80 $mysqli->query("START TRANSACTION");
83 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
93 testStmtStoreResult($mysqli, 'first connection');
96 $mysqli->close();
101 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
104 testStmtGetResult($mysqli, 'first connection');
107 $mysqli->close();
112 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
115 testNormalQuery($mysqli, 'first connection');
118 $mysqli->close();
123 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
126 testStmtUseResult($mysqli, 'first connection');
129 $mysqli->close();
134 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
137 testResultFetchRow($mysqli, 'first connection');
140 $mysqli->close();