Lines Matching refs:mysqli
4 mysqli
23 $mysqli = new mysqli();
25 $mysqli->commit();
30 if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) {
35 if (true !== ($tmp = $mysqli->commit())) {
39 if (true !== ($tmp = $mysqli->autocommit(false))) {
43 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
44 printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error);
47 if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
48 printf("[005] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
51 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)')) {
52 printf("[006] [%d] %s\n", $mysqli->errno, $mysqli->error);
55 $tmp = $mysqli->commit();
60 if (!$mysqli->query('ROLLBACK'))
61 printf("[008] [%d] %s\n", $mysqli->errno, $mysqli->error);
63 if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test')) {
64 printf("[009] [%d] %s\n", $mysqli->errno, $mysqli->error);
73 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
74 printf("[011] [%d] %s\n", $mysqli->errno, $mysqli->error);
77 if (!$mysqli->commit(0 , "tx_name0123")) {
78 printf("[012] [%d] %s\n", $mysqli->errno, $mysqli->error);
81 var_dump($mysqli->commit(0 , "*/ nonsense"));
83 var_dump($mysqli->commit(0 , "tx_name ulf вендел"));
85 var_dump($mysqli->commit(0 , "tx_name \t\n\r\b"));
87 if (!$mysqli->commit(MYSQLI_TRANS_COR_AND_CHAIN | MYSQLI_TRANS_COR_NO_RELEASE , "tx_name")) {
88 printf("[016] [%d] %s\n", $mysqli->errno, $mysqli->error);
91 $mysqli->close();
94 $mysqli->commit();
105 mysqli object is not fully initialized
107 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
110 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
113 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
