Lines Matching refs:query
25 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
28 …if (!$mysqli->query('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE = ' . $engin…
31 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')"))
38 $mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')");
42 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4"))
48 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
54 if (!$mysqli->query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
61 if (!$mysqli->query("INSERT INTO test(id, label) SELECT id + 10, label FROM test"))
67 if (!$mysqli->query("REPLACE INTO test(id, label) values (4, 'd')"))
73 if (!$mysqli->query("REPLACE INTO test(id, label) values (5, 'e')"))
79 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2"))
85 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2")) {
92 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 100")) {
99 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
