Home
last modified time | relevance | path

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

12345678910>>...16

/php-src/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.phpt21 $stmt = $conn->prepare("SELECT strval, $field FROM data");
50 [*] Sending - Stmt prepare data intval: 0c0000010001000000020000000000003200000203646566087068705f7…
55 [*] Sending - Stmt prepare data fltval: 0c0000010001000000020000000000003200000203646566087068705f7…
60 [*] Sending - Stmt prepare data dblval: 0c0000010001000000020000000000003200000203646566087068705f7…
65 [*] Sending - Stmt prepare data datval: 0c0000010001000000020000000000003200000203646566087068705f7…
70 [*] Sending - Stmt prepare data timval: 0c0000010001000000020000000000003200000203646566087068705f7…
75 [*] Sending - Stmt prepare data dtival: 0c0000010001000000020000000000003200000203646566087068705f7…
80 [*] Sending - Stmt prepare data bitval: 0c0000010001000000020000000000003200000203646566087068705f7…
85 [*] Sending - Stmt prepare data strval: 0c0000010001000000020000000000003200000203646566087068705f7…
H A Dmysqli_stmt_execute_bind.phpt18 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
25 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
31 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
40 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
49 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
58 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
67 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
76 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
85 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?');
93 $stmt = $link->prepare('SELECT label FROM test WHERE id=1');
[all …]
/php-src/ext/pdo_mysql/tests/
H A Dbug80458.phpt23 $stmt = $db->prepare('DELETE FROM test_80458 WHERE first=1');
30 $stmt2 = $db->prepare('DELETE FROM test_80458 WHERE first=3');
36 $stmt3 = $db->prepare('DELETE FROM test_80458 WHERE first=4');
47 $stmt4 = $db->prepare("CALL {$procedure_nores}()");
55 $stmt5 = $db->prepare("CALL {$procedure_ret}()");
66 $stmt = $db->prepare('DELETE FROM test_80458 WHERE first=8');
73 $stmt2 = $db->prepare('DELETE FROM test_80458 WHERE first=10');
79 $stmt3 = $db->prepare('DELETE FROM test_80458 WHERE first=11');
88 $stmt4 = $db->prepare("CALL {$procedure_nores}()");
92 $stmt5 = $db->prepare("CALL {$procedure_ret}()");
[all …]
H A Dbug70272.phpt22 $a->b = $db->prepare("select 1");
23 $a->d = $db->prepare("select 2");
24 $a->e = $db->prepare("select 3");
25 $a->f = $db->prepare("select 4");
H A Dbug_38546.phpt53 $st = $db->prepare("UPDATE test_38546 SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
72 print("ok prepare 1\n");
79 $st = $db->prepare("UPDATE test_38546 SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
98 print("ok prepare 2\n");
106 $st = $db->prepare("UPDATE test_38546 SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
125 print("ok prepare 3\n");
152 print("ok prepare 4\n");
179 print("ok prepare 5\n");
205 ok prepare 1
217 ok prepare 2
[all …]
H A Dpdo_mysql_prepare_native.phpt2 MySQL PDO->prepare(), native PS
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
22 if (is_array($error_info) && isset($error_info['prepare'])) {
25 if (isset($error_info['prepare']['sqlstate']) &&
26 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
28 $offset, $error_info['prepare']['sqlstate'], $tmp[0]);
32 if (isset($error_info['prepare']['mysql']) &&
33 ($error_info['prepare']['mysql'] !== $tmp[1])) {
35 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_native_myisam.phpt2 MySQL PDO->prepare(), native PS
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
22 if (is_array($error_info) && isset($error_info['prepare'])) {
25 if (isset($error_info['prepare']['sqlstate']) &&
26 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
28 $offset, $error_info['prepare']['sqlstate'], $tmp[0]);
32 if (isset($error_info['prepare']['mysql']) &&
33 ($error_info['prepare']['mysql'] !== $tmp[1])) {
35 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_native_myisam_index.phpt2 MySQL PDO->prepare(), native PS
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
22 if (is_array($error_info) && isset($error_info['prepare'])) {
25 if (isset($error_info['prepare']['sqlstate']) &&
26 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
28 $offset, $error_info['prepare']['sqlstate'], $tmp[0]);
32 if (isset($error_info['prepare']['mysql']) &&
33 ($error_info['prepare']['mysql'] !== $tmp[1])) {
35 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_emulated_anonymous_placeholders.phpt2 MySQL PDO->prepare(), emulated PS
18 if (is_array($error_info) && isset($error_info['prepare']))
19 $stmt = @$db->prepare($query);
21 $stmt = $db->prepare($query);
23 if (is_array($error_info) && isset($error_info['prepare'])) {
26 if (isset($error_info['prepare']['sqlstate']) &&
27 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
33 if (isset($error_info['prepare']['mysql']) &&
34 ($error_info['prepare']['mysql'] !== $tmp[1])) {
36 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_emulated_myisam.phpt2 MySQL PDO->prepare(), emulated PS
18 if (is_array($error_info) && isset($error_info['prepare']))
19 $stmt = @$db->prepare($query);
21 $stmt = $db->prepare($query);
23 if (is_array($error_info) && isset($error_info['prepare'])) {
26 if (isset($error_info['prepare']['sqlstate']) &&
27 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
33 if (isset($error_info['prepare']['mysql']) &&
34 ($error_info['prepare']['mysql'] !== $tmp[1])) {
36 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_emulated_myisam_index.phpt2 MySQL PDO->prepare(), emulated PS
20 if (is_array($error_info) && isset($error_info['prepare']))
21 $stmt = @$db->prepare($query);
23 $stmt = $db->prepare($query);
25 if (is_array($error_info) && isset($error_info['prepare'])) {
28 if (isset($error_info['prepare']['sqlstate']) &&
29 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
35 if (isset($error_info['prepare']['mysql']) &&
36 ($error_info['prepare']['mysql'] !== $tmp[1])) {
38 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_native_mixed_style.phpt2 MySQL PDO->prepare(), native PS, mixed, wired style
23 $stmt = $db->prepare("INSERT INTO {$table}(id, label) VALUES (1, ?), (2, ?)");
25 …$stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id = :placeholder AND label = (SELECT l…
38 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number: mixed named and positional para…
40 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number in %s on line %d
H A Dpdo_mysql_prepare_emulated.phpt2 MySQL PDO->prepare(), emulated PS
18 if (is_array($error_info) && isset($error_info['prepare']))
19 $stmt = @$db->prepare($query);
21 $stmt = $db->prepare($query);
23 if (is_array($error_info) && isset($error_info['prepare'])) {
26 if (isset($error_info['prepare']['sqlstate']) &&
27 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
33 if (isset($error_info['prepare']['mysql']) &&
34 ($error_info['prepare']['mysql'] !== $tmp[1])) {
36 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_native_anonymous_placeholder.phpt2 MySQL PDO->prepare(), native PS
18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
22 if (is_array($error_info) && isset($error_info['prepare'])) {
25 if (isset($error_info['prepare']['sqlstate']) &&
26 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
28 $offset, $error_info['prepare']['sqlstate'], $tmp[0]);
32 if (isset($error_info['prepare']['mysql']) &&
33 ($error_info['prepare']['mysql'] !== $tmp[1])) {
35 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt2 MySQL PDO->prepare(), native PS, named placeholder II
25 …$stmt = $db->prepare('INSERT INTO test_prepare_native_dup_named(id, label1, label2) VALUES (1, :pl…
34 … $stmt = $db->prepare('SELECT id, label1, label2 FROM test_prepare_native_dup_named WHERE id = 1');
44 …$stmt = $db->prepare('INSERT INTO test_prepare_native_dup_named(id, label1, label2) VALUES(2, :pla…
53 … $stmt = $db->prepare('SELECT id, label1, label2 FROM test_prepare_native_dup_named WHERE id = 2');
66 $stmt = $db->prepare($sql);
80 $stmt = $db->prepare($sql);
H A Dpdo_mysql_prepare_native_column.phpt2 MySQL PDO->prepare(), native PS, named placeholder
22 $stmt = $db->prepare("SELECT :param FROM {$table} ORDER BY id ASC LIMIT 1");
26 $db->prepare("SELECT :placeholder FROM {$table} WHERE :placeholder > :placeholder");
/php-src/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: 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-src/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-src/ext/pdo_pgsql/tests/
H A Dbug64953.phpt21 $st = $pdo->prepare('SELECT ?::char as i');
27 $st = $pdo->prepare('SELECT (?)::char as i');
34 $st = $pdo->prepare("SELECT :int::int as i");
38 $st = $pdo->prepare("SELECT '''?'''::text as \":text\"");
H A Ddisable_prepares.phpt18 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
21 $stmt2 = $db->prepare("SELECT (?)::int2");
30 $stmt3 = $db->prepare("SELECT (?)::int4", array(
H A Dbug72294.phpt103 public function prepare( $pdo, $sql )
105 //return $pdo->prepare( $sql );
106 $this->cached_statements[$sql] = $pdo->prepare( $sql );
121 $statement = $prepared_statement_cache->prepare( $pdo, <<<SQL
137 $statement = $this->cache->prepare( $pdo, 'SELECT * FROM test72294 WHERE test_column > 0' );
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_statement_getattribute.phpt10 $st = $db->prepare('SELECT 1;');
14 $st = $db->prepare('CREATE TABLE test_sqlite_stmt_getattribute (a TEXT);');

Completed in 21 milliseconds

12345678910>>...16