Home
last modified time | relevance | path

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

12345678910>>...15

/PHP-8.0/ext/mysqli/tests/
H A Dgh8058.phpt16 $stmt = $mysqli->prepare("select 1,2,3");
18 $stmt->prepare("");
19 $stmt->prepare("select ".str_repeat("'A',", 0x1201)."1");
23 $stmt = $mysqli->prepare("select 1,2,3");
25 $stmt->prepare("");
26 $stmt->prepare("select 1");
30 $stmt = $mysqli->prepare("select 1,2,3");
33 $stmt->prepare("");
H A Dmysqli_stmt_attr_set.phpt30 $stmt->prepare("SELECT * FROM test");
50 $stmt->prepare("SELECT label FROM test");
66 $stmt->prepare("SELECT label FROM test");
86 $stmt->prepare("SELECT label FROM test");
110 $stmt->prepare("SELECT id, label FROM test");
134 $stmt->prepare("SELECT id, label FROM test");
146 $stmt->prepare("SELECT id, label FROM test");
163 $stmt->prepare("SELECT id, label FROM test");
185 $stmt->prepare("SELECT id, label FROM test");
207 $stmt->prepare("SELECT label FROM test");
[all …]
/PHP-8.0/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-8.0/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 Dbug80458.phpt23 $stmt = $db->prepare('DELETE FROM test WHERE first=1');
30 $stmt2 = $db->prepare('DELETE FROM test WHERE first=3');
36 $stmt3 = $db->prepare('DELETE FROM test WHERE first=4');
46 $stmt4 = $db->prepare('CALL nores()');
53 $stmt5 = $db->prepare('CALL ret()');
64 $stmt = $db->prepare('DELETE FROM test WHERE first=8');
71 $stmt2 = $db->prepare('DELETE FROM test WHERE first=10');
77 $stmt3 = $db->prepare('DELETE FROM test WHERE first=11');
87 $stmt4 = $db->prepare('CALL nores()');
94 $stmt5 = $db->prepare('CALL ret()');
[all …]
H A Dbug_38546.phpt56 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
75 print("ok prepare 1\n");
82 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
101 print("ok prepare 2\n");
109 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
128 print("ok prepare 3\n");
155 print("ok prepare 4\n");
182 print("ok prepare 5\n");
208 ok prepare 1
220 ok prepare 2
[all …]
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_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_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_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 Dbug44327.phpt15 $stmt = $db->prepare("SELECT 1 AS \"one\"");
28 $stmt = $db->prepare("SELECT id FROM test");
37 $stmt = $db->prepare('foo');
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');
/PHP-8.0/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(''));
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-8.0/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-8.0/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-8.0/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.0/ext/pdo_dblib/tests/
H A Dtimeout.phpt16 $stmt = $db->prepare($sql);
25 $stmt = $db->prepare($sql);
39 $stmt = $db->prepare($sql);
51 $stmt = $db->prepare($sql);
63 $stmt = $db->prepare($sql);
/PHP-8.0/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');

Completed in 28 milliseconds

12345678910>>...15