/PHP-5.5/ext/pdo_firebird/tests/ |
H A D | bug_64037.phpt | 16 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (1, 'test', -1.0)"); 17 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (2, 'test', -0.99)"); 18 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (3, 'test', -1.01)");
|
H A D | rowCount.phpt | 15 $dbh->exec("INSERT INTO testz VALUES ('A')"); 16 $dbh->exec("INSERT INTO testz VALUES ('A')"); 17 $dbh->exec("INSERT INTO testz VALUES ('B')");
|
/PHP-5.5/ext/oci8/tests/ |
H A D | bug42496_1.phpt | 19 "INSERT INTO bug42496_1_tab VALUES('test1', 'test1')", 20 "INSERT INTO bug42496_1_tab VALUES('test2', 'test2')", 21 "INSERT INTO bug42496_1_tab VALUES('test3', 'test3')"
|
H A D | bind_misccoltypes.phpt | 59 $insert_sql = "INSERT INTO bind_misccoltypes_tab ( id, " 189 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t92) VALUES (52, :n1)"); 199 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t92) VALUES (53, :n1)"); 209 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (54, :n1)"); 218 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (55, :n1)"); 229 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (56, :n1)"); 237 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, varchar2_t10) VALUES (58, :c2)"); 246 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, char_t10) VALUES (59, :c2)"); 255 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, date_t) VALUES (60, to_date(:c2, 'YYYY-M…
|
/PHP-5.5/ext/pdo/tests/ |
H A D | pdo_007.phpt | 18 $db->exec("INSERT INTO test VALUES('A', 'A')"); 19 $db->exec("INSERT INTO test VALUES('B', 'A')"); 20 $db->exec("INSERT INTO test VALUES('C', 'C')");
|
H A D | pdo_020.phpt | 18 $db->exec("INSERT INTO test VALUES(1, 'A', 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B', 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C', 'C')");
|
H A D | pdo_032.phpt | 18 $db->exec("INSERT INTO test VALUES(1, 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C')");
|
H A D | pdo_027.phpt | 18 $db->exec("INSERT INTO test (id,name) VALUES(1,'test1')"); 19 $db->exec("INSERT INTO test (id,name) VALUES(2,'test2')");
|
/PHP-5.5/ext/mysqli/tests/ |
H A D | mysqli_affected_rows_oo.phpt | 31 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')")) 37 // ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented 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"))
|
H A D | 004.phpt | 23 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567890', 'this is a test0')")) 26 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567891', 'this is a test1')")) 29 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567892', 'this is a test2')")) 32 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567893', 'this is a test3')"))
|
H A D | mysqli_affected_rows.phpt | 39 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')")) 45 // ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented 46 mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')"); 50 …if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id =… 56 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')")) 62 if (!mysqli_query($link, "INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) { 69 if (!mysqli_query($link, "INSERT INTO test(id, label) SELECT id + 10, label FROM test"))
|
H A D | mysqli_options_init_command.phpt | 22 !mysqli_query($link, "INSERT INTO test(id) VALUES (1)")) 37 if (true !== mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(id) VALUES (2)")) 56 …if (true !== mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(i_do_no_exist) VALUES (2… 62 …if (true !== mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(i_do_no_exist) VALUES (2…
|
/PHP-5.5/ext/interbase/tests/ |
H A D | ibase_affected_rows_001.phpt | 12 ibase_query($x, 'INSERT INTO test1 VALUES (1, 100)'); 13 ibase_query($x, 'INSERT INTO test1 VALUES (10000, 100)');
|
/PHP-5.5/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_transaction.phpt | 16 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")'); 17 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
|
H A D | pdo_sqlite_lastinsertid.phpt | 10 $db->query('INSERT INTO foo VALUES (NULL, "PHP")'); 11 $db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
|
H A D | pdo_sqlite_createaggregate.phpt | 12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")'); 13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
|
H A D | pdo_sqlite_createfunction.phpt | 12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")'); 13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
|
/PHP-5.5/ext/odbc/tests/ |
H A D | odbc_exec_002.phpt | 16 odbc_exec($conn, 'INSERT INTO FOO VALUES (1)'); 17 odbc_exec($conn, 'INSERT INTO FOO VALUES (2)');
|
/PHP-5.5/ext/sqlite3/tests/ |
H A D | bug45798.phpt | 12 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'a')"); 13 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'b')");
|
H A D | sqlite3result_fetcharray_with_two_params_fails.phpt | 12 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')"); 13 $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");
|
H A D | sqlite3result_reset_with_params_fails.phpt | 12 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')"); 13 $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");
|
/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | bug43925.phpt | 26 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (1, 1, 1, 6);'); 27 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (2, 1, 2, 3);'); 28 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (3, 1, 4, 5);');
|
/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pecl_bug_5780.phpt | 17 $db->exec("INSERT INTO test2 (login, password) VALUES ('testing', 'testing')"); 18 $db->exec("INSERT INTO test2 (login, password) VALUES ('test2', 'testpw2')"); 20 $logstmt = $db->prepare('INSERT INTO test (login, data) VALUES (:var1, :var2)');
|
H A D | pdo_mysql_prepare_native.phpt | 127 prepex(10, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)', 129 prepex(11, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)', 186 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')"); 187 $db->exec("INSERT INTO test(id, label) VALUES (2, 'row2')"); 204 prepex(35, $db, "INSERT INTO test(id, label) VALUES(1, '?')"); 209 prepex(38, $db, 'INSERT INTO test(id, label) VALUES(1, ?)', 211 prepex(39, $db, 'INSERT INTO test(id, label) VALUES(2, ?)', 234 prepex(45, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)', 273 prepex(54, $db, 'INSERT INTO test(id, label) VALUES (1, ?)', 275 prepex(55, $db, 'INSERT INTO test(id, label) VALUES (1, ?)', [all …]
|
/PHP-5.5/ext/mysql/tests/ |
H A D | mysql_affected_rows.phpt | 39 if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link)) 45 // ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented 46 @mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link); 50 if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4", $lin… 56 if (!mysql_query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')", $link)) 62 if (!mysql_query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')", $link)) { 69 if (!mysql_query("INSERT INTO test(id, label) SELECT id + 10, label FROM test", $link))
|