/PHP-5.5/ext/pdo/tests/ |
H A D | pdo_017.phpt | 39 $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 D | pdo_005.phpt | 18 $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 D | pdo_021.phpt | 36 $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 D | mysqli_insert_id.phpt | 35 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 D | mysqli_stmt_param_count.phpt | 45 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 D | 015.phpt | 33 !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 D | 014.phpt | 30 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 D | bug_41698.phpt | 19 $db->exec('INSERT INTO test VALUES(2.34)'); 21 $stmt = $db->prepare('INSERT INTO test VALUES(?)');
|
H A D | pdo_mysql_attr_multi_statements.phpt | 25 $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 D | pdo_mysql_prepare_native_named_placeholder.phpt | 24 // 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 D | pdo_mysql_rollback.phpt | 23 $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 D | pdo_mysql_prepare_emulated.phpt | 101 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 D | pdo_mysql_last_insert_id.phpt | 37 $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 D | pdo_mysql_stmt_blobfromsteam.phpt | 59 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 D | bug_44707.phpt | 38 $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 D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 25 // 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 D | pdo_mysql_exec.phpt | 41 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 D | pdo_mysql_exec_select.phpt | 41 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 D | statement_type.phpt | 13 "INSERT INTO table VALUES(1)", 37 string(6) "INSERT"
|
H A D | statement_type_old.phpt | 20 "INSERT INTO table VALUES(1)", 45 string(6) "INSERT"
|
H A D | lob_037.phpt | 15 $ora_sql = "INSERT INTO 32 $ora_sql = "INSERT INTO
|
/PHP-5.5/ext/pdo_firebird/tests/ |
H A D | ddl.phpt | 16 $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 D | bug68087.phpt | 19 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 D | odbc_free_result_001.phpt | 17 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 D | mysql_info.phpt | 19 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))
|