Lines Matching refs:link
18 function get_sql_id($link) {
19 if (!($res = $link->query("SELECT LAST_INSERT_ID() AS _id"))) {
20 printf("[003] [%d] %s\n", $link->errno, $link->error);
29 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
33 if (!$link->query("DROP TABLE IF EXISTS test") ||
34 …!$link->query("CREATE TABLE test (id INT auto_increment, label varchar(10) not null, PRIMARY KEY (…
35 !$link->query("INSERT INTO test (id, label) VALUES (null, 'a')")) {
36 printf("[002] [%d] %s\n", $link->errno, $link->error);
39 $api_id = $link->insert_id;
40 $sql_id = get_sql_id($link);
44 printf("[004] Expecting id > 0 got %d, [%d] %s\n", $api_id, $link->errno, $link->error) ;
49 if (!($res = $link->query("SELECT 1 FROM DUAL")))
50 printf("[006] [%d] %s\n", $link->errno, $link->error);
54 $api_id = $link->insert_id;
55 $new_sql_id = get_sql_id($link);
65 if ($link->query("INSERT INTO test (id, label) VALUES (null, null)")) {
66 printf("[009] The INSERT did not fail as planned, [%d] %s\n", $link->errno, $link->error);
68 $api_id = $link->insert_id;
69 $new_sql_id = get_sql_id($link);
80 if (!$link->query("UPDATE test SET id=LAST_INSERT_ID(id+1)"))
81 printf("[012] [%d] %s\n", $link->errno, $link->error);
83 $api_id = $link->insert_id;
84 $new_sql_id = get_sql_id($link);
86 printf("[013] Expecting id > 0 got %d, [%d] %s\n", $api_id, $link->errno, $link->error) ;
95 if (!$link->query("SET @myvar=1"))
96 printf("[016] [%d] %s\n", $link->errno, $link->error);
98 $api_id = $link->insert_id;
99 $new_sql_id = get_sql_id($link);
108 if (!$link->query("INSERT INTO test(id, label) VALUES (LAST_INSERT_ID(id + 1), 'b')"))
109 printf("[019] [%d] %s\n", $link->errno, $link->error);
111 $api_id = $link->insert_id;
112 $sql_id = get_sql_id($link);
116 if (!$link->query("INSERT INTO test(label) VALUES ('c')"))
117 printf("[021] [%d] %s\n", $link->errno, $link->error);
119 $api_id = $link->insert_id;
120 $sql_id = get_sql_id($link);
124 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
125 printf("[023] [%d] %s\n", $link->errno, $link->error);
133 if (!$link->query("INSERT INTO test(label) SELECT CONCAT(label, id) FROM test ORDER BY id ASC"))
134 printf("[024] [%d] %s\n", $link->errno, $link->error);
136 $api_id = $link->insert_id;
137 $sql_id = get_sql_id($link);
141 …if ($link->query("INSERT INTO test(id, label) SELECT id, CONCAT(label, id) FROM test ORDER BY id A…
142 …] INSERT should have failed because of duplicate PK value, [%d] %s\n", $link->errno, $link->error);
144 $api_id = $link->insert_id;
145 $new_sql_id = get_sql_id($link);
155 …if (!$link->query(sprintf("INSERT INTO test(id, label) VALUES (%d, 'z') ON DUPLICATE KEY UPDATE id…
156 printf("[029] [%d] %s\n", $link->errno, $link->error);
158 $api_id = $link->insert_id;
159 $new_sql_id = get_sql_id($link);
166 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
167 printf("[032] [%d] %s\n", $link->errno, $link->error);
