Lines Matching refs:query
20 if (!($res = $link->query("SELECT LAST_INSERT_ID() AS _id"))) {
34 if (!$link->query("DROP TABLE IF EXISTS test") ||
35 …!$link->query("CREATE TABLE test (id INT auto_increment, label varchar(10) not null, PRIMARY KEY (…
36 !$link->query("INSERT INTO test (id, label) VALUES (null, 'a')")) {
50 if (!($res = $link->query("SELECT 1 FROM DUAL")))
58 …printf("[007] API id should have been reset to 0 because previous query was SELECT, got API %d, SQ…
66 if ($link->query("INSERT INTO test (id, label) VALUES (null, null)")) {
73 …printf("[010] API id should have been reset to 0 because previous query was SELECT, got API %d, SQ…
81 if (!$link->query("UPDATE test SET id=LAST_INSERT_ID(id+1)"))
96 if (!$link->query("SET @myvar=1"))
102 …printf("[017] API id should have been reset to 0 because previous query was SET, got API %d, SQL %…
109 if (!$link->query("INSERT INTO test(id, label) VALUES (LAST_INSERT_ID(id + 1), 'b')"))
117 if (!$link->query("INSERT INTO test(label) VALUES ('c')"))
125 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
134 if (!$link->query("INSERT INTO test(label) SELECT CONCAT(label, id) FROM test ORDER BY id ASC"))
142 …if ($link->query("INSERT INTO test(id, label) SELECT id, CONCAT(label, id) FROM test ORDER BY id A…
148 …printf("[027] API id should have been reset to 0 because previous query failed, got API %d, SQL %d…
156 …if (!$link->query(sprintf("INSERT INTO test(id, label) VALUES (%d, 'z') ON DUPLICATE KEY UPDATE id…
167 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
