Home
last modified time | relevance | path

Searched refs:prepare (Results 1 – 25 of 383) sorted by relevance

12345678910>>...16

/PHP-8.1/ext/mysqli/tests/
H A Dgh8058.phpt17 $stmt = $mysqli->prepare("select 1,2,3");
19 $stmt->prepare("");
20 $stmt->prepare("select ".str_repeat("'A',", 0x1201)."1");
24 $stmt = $mysqli->prepare("select 1,2,3");
26 $stmt->prepare("");
27 $stmt->prepare("select 1");
31 $stmt = $mysqli->prepare("select 1,2,3");
34 $stmt->prepare("");
H A Dprotocol_stmt_row_fetch_data.phpt20 $stmt = $conn->prepare("SELECT strval, $field FROM data");
49 [*] Sending - Stmt prepare data intval: 0c0000010001000000020000000000003200000203646566087068705f7…
54 [*] Sending - Stmt prepare data fltval: 0c0000010001000000020000000000003200000203646566087068705f7…
59 [*] Sending - Stmt prepare data dblval: 0c0000010001000000020000000000003200000203646566087068705f7…
64 [*] Sending - Stmt prepare data datval: 0c0000010001000000020000000000003200000203646566087068705f7…
69 [*] Sending - Stmt prepare data timval: 0c0000010001000000020000000000003200000203646566087068705f7…
74 [*] Sending - Stmt prepare data dtival: 0c0000010001000000020000000000003200000203646566087068705f7…
79 [*] Sending - Stmt prepare data bitval: 0c0000010001000000020000000000003200000203646566087068705f7…
84 [*] Sending - Stmt prepare data strval: 0c0000010001000000020000000000003200000203646566087068705f7…
H A Dmysqli_stmt_execute_bind.phpt23 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
30 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
36 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
45 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
54 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
63 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
72 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
81 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
90 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
98 $stmt = $link->prepare('SELECT label FROM test WHERE id=1');
[all …]
H A Dmysqli_stmt_attr_set.phpt31 $stmt->prepare("SELECT * FROM test");
51 $stmt->prepare("SELECT label FROM test");
67 $stmt->prepare("SELECT label FROM test");
87 $stmt->prepare("SELECT label FROM test");
111 $stmt->prepare("SELECT id, label FROM test");
135 $stmt->prepare("SELECT id, label FROM test");
147 $stmt->prepare("SELECT id, label FROM test");
164 $stmt->prepare("SELECT id, label FROM test");
186 $stmt->prepare("SELECT id, label FROM test");
208 $stmt->prepare("SELECT label FROM test");
[all …]
/PHP-8.1/ext/pdo_oci/tests/
H A Dpdo_oci_templob_1.phpt28 $stmt= $db->prepare($clobquery1);
31 $stmt= $db->prepare($clobquery2);
34 $stmt= $db->prepare($clobquery3);
37 $stmt= $db->prepare($clobquery4);
40 $stmt= $db->prepare($clobquery5);
43 $stmt= $db->prepare($clobquery6);
46 $stmt= $db->prepare($clobquery7);
49 $stmt= $db->prepare($clobquery8);
52 $stmt= $db->prepare($clobquery9);
61 $stmt1 = $db->prepare($query1);
[all …]
H A Dpdo_oci_attr_prefetch_2.phpt18 $s = $dbh->prepare("select '' as myempty, null as mynull from dual", array(PDO::ATTR_PREFETCH => 10…
20 echo "Test 1: Can't set prefetch after prepare\n";
24 $s = $dbh->prepare("select dummy from dual" );
31 $s = $dbh->prepare("select '' as myempty, null as mynull from dual", array(PDO::ATTR_PREFETCH => 0)…
32 $s = $dbh->prepare("select dummy from dual" );
42 Test 1: Can't set prefetch after prepare
H A Dpdo_oci_attr_prefetch_1.phpt25 $s = $dbh->prepare("select dummy from dual" );
36 $s = $dbh->prepare("select dummy from dual" );
47 $s = $dbh->prepare("select dummy from dual" );
58 $s = $dbh->prepare("select dummy from dual" );
/PHP-8.1/ext/pdo_mysql/tests/
H A Dbug80458.phpt25 $stmt = $db->prepare('DELETE FROM test WHERE first=1');
32 $stmt2 = $db->prepare('DELETE FROM test WHERE first=3');
38 $stmt3 = $db->prepare('DELETE FROM test WHERE first=4');
48 $stmt4 = $db->prepare('CALL nores()');
55 $stmt5 = $db->prepare('CALL ret()');
66 $stmt = $db->prepare('DELETE FROM test WHERE first=8');
73 $stmt2 = $db->prepare('DELETE FROM test WHERE first=10');
79 $stmt3 = $db->prepare('DELETE FROM test WHERE first=11');
89 $stmt4 = $db->prepare('CALL nores()');
96 $stmt5 = $db->prepare('CALL ret()');
[all …]
H A Dbug70272.phpt24 $a->b = $db->prepare("select 1");
25 $a->d = $db->prepare("select 2");
26 $a->e = $db->prepare("select 3");
27 $a->f = $db->prepare("select 4");
H A Dbug_38546.phpt58 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
77 print("ok prepare 1\n");
84 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
103 print("ok prepare 2\n");
111 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
130 print("ok prepare 3\n");
157 print("ok prepare 4\n");
184 print("ok prepare 5\n");
210 ok prepare 1
222 ok prepare 2
[all …]
H A Dpdo_mysql_prepare_native_mixed_style.phpt2 MySQL PDO->prepare(), native PS, mixed, wired style
22 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)');
24 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label…
36 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number: mixed named and positional para…
38 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number in %s on line %d
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt2 MySQL PDO->prepare(), native PS, named placeholder II
28 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES (1, :placeholder, :placeholder)'…
37 $stmt = $db->prepare('SELECT id, label1, label2 FROM test WHERE id = 1');
47 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES(2, :placeholder, :placeholder)');
56 $stmt = $db->prepare('SELECT id, label1, label2 FROM test WHERE id = 2');
69 $stmt = $db->prepare($sql);
83 $stmt = $db->prepare($sql);
H A Dpdo_mysql_prepare_native_column.phpt2 MySQL PDO->prepare(), native PS, named placeholder
21 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1");
25 $db->prepare('SELECT :placeholder FROM test WHERE :placeholder > :placeholder');
H A Dpdo_mysql_prepare_native_clear_error.phpt2 MySQL PDO->prepare(), native PS, clear line after error
30 … $stmt = $db->prepare('SELECT unknown_column FROM test WHERE id > :placeholder ORDER BY id ASC');
37 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC');
50 … $stmt = $db->prepare('SELECT unknown_column FROM test WHERE id > :placeholder ORDER BY id ASC');
57 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC');
96 Warning: PDO::prepare(): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unknown_column' in…
H A Dbug_pecl_12925.phpt22 $stmt = $db->prepare("UPDATE test SET id = 'b'");
24 $stmt = $db->prepare("UPDATE test SET id = 'c'");
26 $stmt = $db->prepare('SELECT id FROM test');
H A Dpdo_mysql_prepare_emulated_anonymous.phpt2 MySQL PDO->prepare(), emulated PS, anonymous placeholder
24 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')");
32 $stmt = $db->prepare('SELECT id, label FROM test');
43 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')");
51 $stmt = $db->prepare('SELECT id, label FROM test');
/PHP-8.1/ext/sqlite3/tests/
H A Dsqlite3_prepare_faultystmt.phpt2 SQLite3::prepare test, testing for faulty statement
14 $stmt = $db->prepare('SELECT foo FROM bar');
19 Warning: SQLite3::prepare(): Unable to prepare statement: 1, no such table: bar in %s on line %d
H A Dsqlite3_bind_bug68849.phpt16 $s = $db->prepare('SELECT * FROM test WHERE (a+2) = ?;');
21 $s = $db->prepare('SELECT * FROM test WHERE a = ?;');
26 $s = $db->prepare('SELECT * FROM test WHERE a = ?;');
31 $s = $db->prepare('SELECT * FROM test WHERE c = ?;');
H A Dsqlite3_prepare_with_empty_string.phpt2 SQLite3::prepare test with empty string argument
11 var_dump($db->prepare(''));
/PHP-8.1/ext/pdo/tests/
H A Dbug_71447.phpt25 $stmt = $db->prepare("
35 $stmt = $db->prepare("
45 $stmt = $db->prepare("
55 $stmt = $db->prepare("
65 $stmt = $db->prepare("
75 $stmt = $db->prepare("
86 $stmt = $db->prepare("
/PHP-8.1/ext/pdo_pgsql/tests/
H A Dbug64953.phpt22 $st = $pdo->prepare('SELECT ?::char as i');
28 $st = $pdo->prepare('SELECT (?)::char as i');
35 $st = $pdo->prepare("SELECT :int::int as i");
39 $st = $pdo->prepare("SELECT '''?'''::text as \":text\"");
H A Ddisable_prepares.phpt19 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
22 $stmt2 = $db->prepare("SELECT (?)::int2");
31 $stmt3 = $db->prepare("SELECT (?)::int4", array(
H A Dbug72294.phpt102 public function prepare( $pdo, $sql )
104 //return $pdo->prepare( $sql );
105 $this->cached_statements[$sql] = $pdo->prepare( $sql );
120 $statement = $prepared_statement_cache->prepare( $pdo, <<<SQL
136 $statement = $this->cache->prepare( $pdo, 'SELECT * FROM temp_table WHERE test_column > 0' );
/PHP-8.1/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_statement_getattribute.phpt10 $st = $db->prepare('SELECT 1;');
14 $st = $db->prepare('CREATE TABLE test (a TEXT);');
/PHP-8.1/ext/pdo_firebird/tests/
H A DrowCount.phpt24 $stmt = $dbh->prepare($query);
31 $stmt = $dbh->prepare('UPDATE testZ SET A="A" WHERE A != ?');
36 $stmt = $dbh->prepare('DELETE FROM testz');

Completed in 24 milliseconds

12345678910>>...16