Home
last modified time | relevance | path

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

12345678910>>...13

/PHP-7.1/ext/pdo_oci/tests/
H A Dpdo_oci_templob_1.phpt26 $stmt= $db->prepare($clobquery1);
29 $stmt= $db->prepare($clobquery2);
32 $stmt= $db->prepare($clobquery3);
35 $stmt= $db->prepare($clobquery4);
38 $stmt= $db->prepare($clobquery5);
41 $stmt= $db->prepare($clobquery6);
44 $stmt= $db->prepare($clobquery7);
47 $stmt= $db->prepare($clobquery8);
50 $stmt= $db->prepare($clobquery9);
59 $stmt1 = $db->prepare($query1);
[all …]
H A Dpdo_oci_attr_prefetch_2.phpt16 $s = $dbh->prepare("select '' as myempty, null as mynull from dual", array(PDO::ATTR_PREFETCH => 10…
18 echo "Test 1: Can't set prefetch after prepare\n";
22 $s = $dbh->prepare("select dummy from dual" );
29 $s = $dbh->prepare("select '' as myempty, null as mynull from dual", array(PDO::ATTR_PREFETCH => 0)…
30 $s = $dbh->prepare("select dummy from dual" );
40 Test 1: Can't set prefetch after prepare
H A Dpdo_oci_attr_prefetch_1.phpt23 $s = $dbh->prepare("select dummy from dual" );
34 $s = $dbh->prepare("select dummy from dual" );
45 $s = $dbh->prepare("select dummy from dual" );
56 $s = $dbh->prepare("select dummy from dual" );
/PHP-7.1/ext/pdo_mysql/tests/
H A Dbug70272.phpt23 $a->b = $db->prepare("select 1");
24 $a->d = $db->prepare("select 2");
25 $a->e = $db->prepare("select 3");
26 $a->f = $db->prepare("select 4");
H A Dpdo_mysql_prepare_native_mixed_style.phpt2 MySQL PDO->prepare(), native PS, mixed, wired style
21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)');
23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label…
35 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number: mixed named and positional para…
37 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
26 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES (1, :placeholder, :placeholder)'…
35 $stmt = $db->prepare('SELECT id, label1, label2 FROM test WHERE id = 1');
45 …$stmt = $db->prepare('INSERT INTO test(id, label1, label2) VALUES(2, :placeholder, :placeholder)');
54 $stmt = $db->prepare('SELECT id, label1, label2 FROM test WHERE id = 2');
67 $stmt = $db->prepare($sql);
81 $stmt = $db->prepare($sql);
H A Dpdo_mysql_prepare_native_column.phpt2 MySQL PDO->prepare(), native PS, named placeholder
20 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1");
24 $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
28 $stmt = $db->prepare('SELECT unknown_column FROM test WHERE id > :placeholder ORDER BY id ASC');
35 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC');
48 $stmt = $db->prepare('SELECT unknown_column FROM test WHERE id > :placeholder ORDER BY id ASC');
55 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC');
94 Warning: PDO::prepare(): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unknown_column' in…
H A Dpdo_mysql_prepare_emulated_anonymous.phpt2 MySQL PDO->prepare(), emulated PS, anonymous placeholder
23 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')");
31 $stmt = $db->prepare('SELECT id, label FROM test');
42 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')");
50 $stmt = $db->prepare('SELECT id, label FROM test');
H A Dbug_pecl_12925.phpt21 $stmt = $db->prepare("UPDATE test SET id = 'b'");
23 $stmt = $db->prepare("UPDATE test SET id = 'c'");
25 $stmt = $db->prepare('SELECT id FROM test');
H A Dbug_61207.phpt18 $handle1 = $db->prepare('insert into test(id) values(1);
34 $handle2 = $db->prepare('select * from test where id = ?;
50 $handle3 = $db->prepare('update test set id = 2 where id = ?;
66 $handle4 = $db->prepare('insert into test(id) values(3);
/PHP-7.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_prepare_wrongparams.phpt2 SQLite3::prepare test, testing for wrong parameters
15 $stmt = $db->prepare();
19 Warning: SQLite3::prepare() expects exactly 1 parameter, 0 given 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(''));
H A Dsqlite3_35_stmt_readonly.phpt24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
28 $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?");
32 $stmt = $db->prepare("DELETE FROM test");
/PHP-7.1/ext/pdo/tests/
H A Dbug_71447.phpt24 $stmt = $db->prepare("
34 $stmt = $db->prepare("
44 $stmt = $db->prepare("
54 $stmt = $db->prepare("
64 $stmt = $db->prepare("
74 $stmt = $db->prepare("
85 $stmt = $db->prepare("
/PHP-7.1/ext/pdo_pgsql/tests/
H A Dbug64953.phpt20 $st = $pdo->prepare('SELECT ?::char as i');
26 $st = $pdo->prepare('SELECT (?)::char as i');
33 $st = $pdo->prepare("SELECT :int::int as i");
37 $st = $pdo->prepare("SELECT '''?'''::text as \":text\"");
H A Dbug72294.phpt100 public function prepare( $pdo, $sql )
102 //return $pdo->prepare( $sql );
103 $this->cached_statements[$sql] = $pdo->prepare( $sql );
118 $statement = $prepared_statement_cache->prepare( $pdo, <<<SQL
134 $statement = $this->cache->prepare( $pdo, 'SELECT * FROM temp_table WHERE test_column > 0' );
H A Ddisable_prepares.phpt17 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
20 $stmt2 = $db->prepare("SELECT (?)::int2");
29 $stmt3 = $db->prepare("SELECT (?)::int4", array(
/PHP-7.1/ext/pdo_dblib/tests/
H A Dtimeout.phpt16 $stmt = $db->prepare($sql);
24 $stmt = $db->prepare($sql);
37 $stmt = $db->prepare($sql);
49 $stmt = $db->prepare($sql);
61 $stmt = $db->prepare($sql);
/PHP-7.1/ext/interbase/tests/
H A D006.phpt40 /* prepare data */
110 /* prepare data */
177 echo "prepare and exec insert\n";
179 /* prepare table */
182 /* prepare query */
194 echo "prepare and exec select\n";
196 /* prepare query */
237 prepare and exec insert
250 prepare and exec select
/PHP-7.1/ext/pdo_firebird/tests/
H A DrowCount.phpt22 $stmt = $dbh->prepare($query);
29 $stmt = $dbh->prepare('UPDATE testZ SET A="A" WHERE A != ?');
34 $stmt = $dbh->prepare('DELETE FROM testz');
/PHP-7.1/ext/pdo/
H A Dpdo.php11 $stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES (:name, :value)");
47 $stmt = $x->prepare("select NAME, VALUE from test where value like ?");
/PHP-7.1/ext/mysqli/tests/
H A Dmysqli_stmt_attr_set.phpt47 $stmt->prepare("SELECT * FROM test");
77 $stmt->prepare("SELECT label FROM test");
93 $stmt->prepare("SELECT label FROM test");
113 $stmt->prepare("SELECT label FROM test");
148 $stmt->prepare("SELECT id, label FROM test");
168 $stmt->prepare("SELECT id, label FROM test");
180 $stmt->prepare("SELECT id, label FROM test");
197 $stmt->prepare("SELECT id, label FROM test");
223 $stmt->prepare("SELECT id, label FROM test");
238 $stmt->prepare("SELECT label FROM test");
[all …]

Completed in 37 milliseconds

12345678910>>...13