Lines Matching refs:mysqli
4 mysqli
15 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
18 $mysqli->query('DROP TABLE IF EXISTS test');
19 $mysqli->query('CREATE TABLE test (first int) ENGINE = InnoDB');
20 $mysqli->query('INSERT INTO test VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
22 function testStmtStoreResult(mysqli $mysqli, string $name) {
23 $mysqli->query("SET innodb_lock_wait_timeout = 1");
24 $mysqli->query("START TRANSACTION");
27 $stmt = $mysqli->prepare($query);
36 function testStmtGetResult(mysqli $mysqli, string $name) {
37 $mysqli->query("SET innodb_lock_wait_timeout = 1");
38 $mysqli->query("START TRANSACTION");
41 $stmt = $mysqli->prepare($query);
50 function testNormalQuery(mysqli $mysqli, string $name) {
51 $mysqli->query("SET innodb_lock_wait_timeout = 1");
52 $mysqli->query("START TRANSACTION");
56 $res = $mysqli->query($query);
62 function testStmtUseResult(mysqli $mysqli, string $name) {
63 $mysqli->query("SET innodb_lock_wait_timeout = 1");
64 $mysqli->query("START TRANSACTION");
67 $stmt = $mysqli->prepare($query);
77 function testResultFetchRow(mysqli $mysqli, string $name) {
78 $mysqli->query("SET innodb_lock_wait_timeout = 1");
79 $mysqli->query("START TRANSACTION");
82 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
92 testStmtStoreResult($mysqli, 'first connection');
95 $mysqli->close();
100 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
103 testStmtGetResult($mysqli, 'first connection');
106 $mysqli->close();
111 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
114 testNormalQuery($mysqli, 'first connection');
117 $mysqli->close();
122 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
125 testStmtUseResult($mysqli, 'first connection');
128 $mysqli->close();
133 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
136 testResultFetchRow($mysqli, 'first connection');
139 $mysqli->close();