Lines Matching refs:mysqli
4 mysqli
21 $mysqli = new mysqli();
23 $mysqli->commit();
28 if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) {
33 if (true !== ($tmp = $mysqli->commit())) {
37 if (true !== ($tmp = $mysqli->autocommit(false))) {
41 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
42 printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error);
45 if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
46 printf("[005] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
49 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)')) {
50 printf("[006] [%d] %s\n", $mysqli->errno, $mysqli->error);
53 $tmp = $mysqli->commit();
58 if (!$mysqli->query('ROLLBACK'))
59 printf("[008] [%d] %s\n", $mysqli->errno, $mysqli->error);
61 if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test')) {
62 printf("[009] [%d] %s\n", $mysqli->errno, $mysqli->error);
71 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
72 printf("[011] [%d] %s\n", $mysqli->errno, $mysqli->error);
75 if (!$mysqli->commit(0 , "tx_name0123")) {
76 printf("[012] [%d] %s\n", $mysqli->errno, $mysqli->error);
79 var_dump($mysqli->commit(0 , "*/ nonsense"));
81 var_dump($mysqli->commit(0 , "tx_name ulf вендел"));
83 var_dump($mysqli->commit(0 , "tx_name \t\n\r\b"));
85 if (!$mysqli->commit(MYSQLI_TRANS_COR_AND_CHAIN | MYSQLI_TRANS_COR_NO_RELEASE , "tx_name")) {
86 printf("[016] [%d] %s\n", $mysqli->errno, $mysqli->error);
89 $mysqli->close();
92 $mysqli->commit();
104 mysqli object is not fully initialized
106 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
109 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
112 Warning: mysqli::commit(): Transaction name has been truncated, since it can only contain the A-Z, …
