Home
last modified time | relevance | path

Searched refs:INSERT (Results 76 – 100 of 433) sorted by relevance

12345678910>>...18

/PHP-5.5/ext/pdo/tests/
H A Dpdo_017.phpt39 $db->exec("INSERT INTO test VALUES(1, 'A')");
40 $db->exec("INSERT INTO test VALUES(2, 'B')");
41 $db->exec("INSERT INTO test VALUES(3, 'C')");
H A Dpdo_005.phpt18 $db->exec("INSERT INTO test VALUES(1, 'A', 'AA')");
19 $db->exec("INSERT INTO test VALUES(2, 'B', 'BB')");
20 $db->exec("INSERT INTO test VALUES(3, 'C', 'CC')");
H A Dpdo_021.phpt36 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
45 $stmt2 = $db->prepare("INSERT INTO test VALUES(:first, :second, :third)");
/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_insert_id.phpt35 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, 'a')")) {
45 if (!$res = mysqli_query($link, "INSERT INTO test(label) VALUES ('a')")) {
70 if (!mysqli_query($link, "INSERT INTO test(label) VALUES ('b')")) {
82 if (!mysqli_query($link, "INSERT INTO test(label) VALUES ('c'), ('d'), ('e')")) {
115 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (1000, 'a')")) {
121 if (!$res = mysqli_query($link, "INSERT INTO test(label) VALUES ('b'), ('c')")) {
H A Dmysqli_stmt_param_count.phpt45 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id) VALUES (?)", 1, 20);
46 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, ?)", 2, 30);
47 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, '?')", 1, 40);
H A D015.phpt33 !mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')"))
42 !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
59 !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
H A D014.phpt30 if (!mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')"))
39 if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
59 if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
/PHP-5.5/ext/pdo_mysql/tests/
H A Dbug_41698.phpt19 $db->exec('INSERT INTO test VALUES(2.34)');
21 $stmt = $db->prepare('INSERT INTO test VALUES(?)');
H A Dpdo_mysql_attr_multi_statements.phpt25 $db->exec(sprintf('INSERT INTO %s(id) VALUES (1)', $table));
26 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table));
38 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (3)', $table, $table));
H A Dpdo_mysql_prepare_native_named_placeholder.phpt24 // INSERT a single row
25 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES (100, ':placeholder')");
29 // The ':placeholder' is a string constant in the INSERT statement.
48 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(101, ':placeholder')");
H A Dpdo_mysql_rollback.phpt23 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
27 printf("[001] INSERT has failed, test will fail\n");
36 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
50 $db->query('INSERT INTO test2(id) VALUES (1)');
H A Dpdo_mysql_prepare_emulated.phpt101 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
112 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
114 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
203 prepex(47, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
208 prepex(50, $db, "INSERT INTO test(id, label) VALUES(1, '?')",
214 prepex(53, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
216 prepex(54, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
242 prepex(62, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
260 prepex(71, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
262 prepex(72, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
[all …]
H A Dpdo_mysql_last_insert_id.phpt37 $db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
46 @$db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
50 $db->exec("INSERT INTO test(id, col1) VALUES (101, 'b')");
70 $db->exec("INSERT INTO test(col1) VALUES ('c'), ('d'), ('e')");
94 $db->exec("INSERT INTO test(col1) VALUES ('z')");
H A Dpdo_mysql_stmt_blobfromsteam.phpt59 if (!$stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)')) {
82 printf("[%03d + 7] Failed to INSERT data, %s\n", $offset, var_export($stmt->errorInfo(), true));
89 printf("[%03d + 8] INSERT and/or SELECT has failed, dumping data.\n", $offset);
98 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)');
107 printf("[%03d + 10] INSERT and/or SELECT has failed, dumping data.\n", $offset);
H A Dbug_44707.phpt38 $stmt = $db->prepare('INSERT INTO test(id, mybool) VALUES (?, ?)');
40 // From MySQL 4.1 on boolean and TINYINT don't match! INSERT will fail.
51 $stmt = $db->prepare('INSERT INTO test(id, mybool) VALUES (?, ?)');
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt25 // INSERT a single row
26 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES (1, :placeholder, :placeholder)'…
45 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES(2, :placeholder, :placeholder)');
63 $db->exec("INSERT INTO test (id, label1, label2) VALUES (1, 'row1', 'row2')");
H A Dpdo_mysql_exec.phpt41 exec_and_count(4, $db, "INSERT INTO test(id, col1) VALUES (1, 'a')", 1);
42 exec_and_count(5, $db, "INSERT INTO test(id, col1) VALUES (2, 'b'), (3, 'c')", 2);
44 …exec_and_count(7, $db, "INSERT INTO test(id, col1) VALUES (1, 'd') ON DUPLICATE KEY UPDATE id = 3"…
46 …exec_and_count(9, $db, "INSERT INTO test(id, col1) VALUES (5, 'e') ON DUPLICATE KEY UPDATE id = 6"…
57 exec_and_count(37, $db, "INSERT INTO test(id, col1) VALUES (1, 'a')", 1);
162 $tmp = @$db->exec('INSERT INTO test(id) VALUES (1); INSERT INTO test(id) VALUES (2)');
H A Dpdo_mysql_exec_select.phpt41 exec_and_count(4, $db, "INSERT INTO test(id, col1) VALUES (1, 'a')", 1);
46 exec_and_count(6, $db, "INSERT INTO test(id, col1) VALUES (2, 'b')", 1);
64 [006] Expecting '1'/integer got ''/boolean when running 'INSERT INTO test(id, col1) VALUES (2, 'b')…
/PHP-5.5/ext/oci8/tests/
H A Dstatement_type.phpt13 "INSERT INTO table VALUES(1)",
37 string(6) "INSERT"
H A Dstatement_type_old.phpt20 "INSERT INTO table VALUES(1)",
45 string(6) "INSERT"
H A Dlob_037.phpt15 $ora_sql = "INSERT INTO
32 $ora_sql = "INSERT INTO
/PHP-5.5/ext/pdo_firebird/tests/
H A Dddl.phpt16 $db->exec("CREATE TRIGGER ddl_bi FOR ddl BEFORE INSERT AS
22 var_dump($db->exec("INSERT INTO ddl (text) VALUES ('bla')"));
/PHP-5.5/ext/odbc/tests/
H A Dbug68087.phpt19 odbc_exec($conn, "INSERT INTO FOO(ID, VARCHAR_COL, DATE_COL) VALUES (1, 'hello', '$id_1_date')");
20 odbc_exec($conn, "INSERT INTO FOO(ID, VARCHAR_COL, DATE_COL) VALUES (2, 'helloagain', '$id_2_date')…
H A Dodbc_free_result_001.phpt17 odbc_exec($conn, 'INSERT INTO FOO VALUES (1)');
18 odbc_exec($conn, 'INSERT INTO FOO VALUES (2)');
/PHP-5.5/ext/mysql/tests/
H A Dmysql_info.phpt19 if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link))
25 if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')", $link))
31 if (!$res = mysql_query('INSERT INTO test(id, label) SELECT id + 200, label FROM test', $link))

Completed in 20 milliseconds

12345678910>>...18