mysqli_autocommit_oo.phpt - OpenGrok cross reference for /PHP-8.1/ext/mysqli/tests/mysqli_autocommit

Lines Matching refs:mysqli
2 mysqli->autocommit()
4 mysqli
23     if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) {
28     if (!is_bool($tmp = $mysqli->autocommit(true)))
31     if (!$mysqli->query('SET AUTOCOMMIT = 0'))
32         printf("[003] [%d] %s\n", $mysqli->errno, $mysqli->error);
34     if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
35         printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error);
42     if (true !== ($tmp = $mysqli->autocommit( true)))
45     if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
46         printf("[007] [%d] %s\n", $mysqli->errno, $mysqli->error);
52     if (!$mysqli->query('DROP TABLE IF EXISTS test'))
53         printf("[009] [%d] %s\n", $mysqli->errno, $mysqli->error);
55     if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
56         printf("[010] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
59     if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
60         printf("[011] [%d] %s\n", $mysqli->errno, $mysqli->error);
62     if (!$mysqli->query('ROLLBACK'))
63         printf("[012] [%d] %s\n", $mysqli->errno, $mysqli->error);
65     if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test'))
66         printf("[013] [%d] %s\n", $mysqli->errno, $mysqli->error);
70             $tmp['num'], $mysqli->errno, $mysqli->error);
74     if (!$mysqli->query('DROP TABLE IF EXISTS test'))
75         printf("[015] [%d] %s\n", $mysqli->errno, $mysqli->error);
77     if (!$mysqli->query('SET AUTOCOMMIT = 1'))
78         printf("[016] [%d] %s\n", $mysqli->errno, $mysqli->error);
80     if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
81         printf("[017] [%d] %s\n", $mysqli->errno, $mysqli->error);
88     if (true !== ($tmp = $mysqli->autocommit( false)))
91     if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
92         printf("[020] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
95     if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
96         printf("[021] [%d] %s\n", $mysqli->errno, $mysqli->error);
98     if (!$mysqli->query('ROLLBACK'))
99         printf("[022] [%d] %s\n", $mysqli->errno, $mysqli->error);
101     if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test'))
102         printf("[023] [%d] %s\n", $mysqli->errno, $mysqli->error);
108     if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
109         printf("[025] [%d] %s\n", $mysqli->errno, $mysqli->error);
111     if (!$mysqli->query('COMMIT'))
112         printf("[025] [%d] %s\n", $mysqli->errno, $mysqli->error);
114     if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test'))
115         printf("[027] [%d] %s\n", $mysqli->errno, $mysqli->error);
119             $tmp['num'], $mysqli->errno, $mysqli->error);
122     if (!$mysqli->query('DROP TABLE IF EXISTS test'))
123         printf("[029] [%d] %s\n", $mysqli->errno, $mysqli->error);
125     $mysqli->close();
128         $mysqli->autocommit(false);