Home
last modified time | relevance | path

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

1234567891011

/PHP-5.5/ext/pdo_oci/tests/
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 Dbug57702.phpt19 $stmt = $db->prepare($query);
23 $stmt = $db->prepare($query);
29 …$stmt = $db->prepare("insert into bug57702 (id, data1, data2) values (:id, empty_blob(), empty_blo…
52 $stmt = $db->prepare('select data1, data2 from bug57702 order by id');
74 $stmt = $db->prepare('select data1 as d3_1, data2 as d3_2 from bug57702 order by id');
128 $stmt = $db->prepare($query);
/PHP-5.5/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_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-5.5/ext/pdo_mysql/tests/
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);
H A Dpdo_mysql_prepare_native_named_placeholder.phpt2 MySQL PDO->prepare(), native PS, named placeholder
25 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES (100, ':placeholder')");
38 $stmt = $db->prepare('SELECT id, label FROM test');
48 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(101, ':placeholder')");
58 $stmt = $db->prepare('SELECT id, label FROM test ORDER BY id');
H A Dpdo_mysql_prepare_match_against.phpt20 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
24 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
28 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
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 Dpdo_mysql_stmt_errorinfo.phpt22 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
28 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
45 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
49 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
108 Warning: PDO::prepare(): SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.ihopeitdoesn…
/PHP-5.5/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\"");
/PHP-5.5/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-5.5/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-5.5/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-5.5/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 …]
/PHP-5.5/ext/pdo/tests/
H A Dbug_40285.phpt2 PDO Common: Bug #40285 (The prepare parser goes into an infinite loop on ': or ":)
21 $s = $db->prepare("INSERT INTO test VALUES( ':id', 'name', 'section', 22)" );
H A Dpdo_021.phpt23 $select = $db->prepare('SELECT COUNT(id) FROM test');
36 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
45 $stmt2 = $db->prepare("INSERT INTO test VALUES(:first, :second, :third)");
/PHP-5.5/ext/pdo_sqlite/tests/
H A Dbug33841.phpt14 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )");
19 $stmt = $db->prepare("UPDATE test SET text = :text ");

Completed in 50 milliseconds

1234567891011