Lines Matching refs:mysqli
4 mysqli
18 $mysqli = new mysqli();
20 $mysqli->commit();
25 $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
27 if (true !== ($tmp = $mysqli->commit())) {
31 if (true !== ($tmp = $mysqli->autocommit(false))) {
35 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
36 printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error);
39 if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
40 printf("[005] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
43 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)')) {
44 printf("[006] [%d] %s\n", $mysqli->errno, $mysqli->error);
47 $tmp = $mysqli->commit();
52 if (!$mysqli->query('ROLLBACK'))
53 printf("[008] [%d] %s\n", $mysqli->errno, $mysqli->error);
55 if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test')) {
56 printf("[009] [%d] %s\n", $mysqli->errno, $mysqli->error);
65 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
66 printf("[011] [%d] %s\n", $mysqli->errno, $mysqli->error);
69 if (!$mysqli->commit(0 , "tx_name0123")) {
70 printf("[012] [%d] %s\n", $mysqli->errno, $mysqli->error);
73 var_dump($mysqli->commit(0 , "*/ nonsense"));
75 var_dump($mysqli->commit(0 , "tx_name ulf вендел"));
77 var_dump($mysqli->commit(0 , "tx_name \t\n\r\b"));
79 if (!$mysqli->commit(MYSQLI_TRANS_COR_AND_CHAIN | MYSQLI_TRANS_COR_NO_RELEASE , "tx_name")) {
80 printf("[016] [%d] %s\n", $mysqli->errno, $mysqli->error);
83 $mysqli->close();
86 $mysqli->commit();
98 mysqli object is not fully initialized
100 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
103 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
106 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …