Home
last modified time | relevance | path

Searched refs:prepare (Results 26 – 50 of 336) sorted by relevance

12345678910>>...14

/PHP-7.4/ext/pdo_mysql/tests/
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 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_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 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…
H A Dpdo_mysql_stmt_errorcode.phpt23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
39 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
57 Warning: PDO::prepare(): SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.ihopeitdoesn…
H A Dpdo_mysql_prepare_native.phpt2 MySQL PDO->prepare(), native PS
20 $stmt = @$db->prepare($query);
22 $stmt = $db->prepare($query);
24 if (is_array($error_info) && isset($error_info['prepare'])) {
27 if (isset($error_info['prepare']['sqlstate']) &&
28 ($error_info['prepare']['sqlstate'] !== $tmp[0])) {
30 $offset, $error_info['prepare']['sqlstate'], $tmp[0]);
34 if (isset($error_info['prepare']['mysql']) &&
35 ($error_info['prepare']['mysql'] !== $tmp[1])) {
37 $offset, $error_info['prepare']['mysql'], $tmp[0]);
[all …]
H A Dbug_61755.phpt18 $s = $db->prepare("SELECT \"a\0b\", ?");
26 $s = $db->prepare("SELECT /*");
/PHP-7.4/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 …]
H A Dps_cursor_multiple_result_sets.phpt27 $stmt = $db->prepare("call testPs()");
42 $stmt = $db->prepare("call testPs()");
59 $stmt = $db->prepare("call testPs()");
H A Dmysqli_ps_select_union.phpt27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
47 The metadata mysqlnd has available after prepare is better than
52 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
83 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT …
103 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT …
132 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2")))
152 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2")))
173 if (!($stmt = $link->prepare("SELECT 'one' AS column1 UNION SELECT ? UNION SELECT ?")))
192 if (!($stmt = $link->prepare("SELECT 'one' AS column1 UNION SELECT ? UNION SELECT ?")))
213 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST(? AS CHAR) U…
[all …]
H A Dbug66124.phpt34 $stmt = $link->prepare($table_insert);
36 printf("Can't prepare\n");
68 $stmt = $link->prepare($table_insert);
/PHP-7.4/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 ");
H A Dbug78192.phpt13 $stmt = $connection->prepare('INSERT INTO user (id, name) VALUES(:id, :name)');
19 $stmt = $connection->prepare('SELECT * FROM user WHERE id = :id');
/PHP-7.4/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)");
H A Dpdo_028.phpt18 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)');
27 $stmt = $db->prepare('SELECT * from test');
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug70313.phpt18 $stmt = $db->prepare(");");
27 $stmt = $db->prepare(");");
H A Dbug71885.phpt22 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
28 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
H A Dbug_49985.phpt2 Bug #49985 (pdo_pgsql prepare() re-use previous aborted transaction)
21 $stmt = $db->prepare("INSERT INTO test (a) VALUES (?)");
H A Dlarge_objects.phpt25 $stmt = $db->prepare("INSERT INTO test (blobid, bloboid) values (?, ?)");
36 $stmt = $db->prepare("SELECT * from test");
47 $stmt = $db->prepare("SELECT * from test");
58 $stmt = $db->prepare("SELECT * from test");
/PHP-7.4/ext/pdo_firebird/tests/
H A Dbug_62024.phpt21 $sttmt = $dbh->prepare($sql);
36 $sttmt = $dbh->prepare('DELETE FROM test_insert');
H A Dbug_47415.phpt21 $stmt = $dbh->prepare($query);
30 $stmt = $dbh->prepare('DELETE FROM testz');
H A Dbug_48877.phpt23 $stmt = $dbh->prepare($query);
31 $stmt = $dbh->prepare('DELETE FROM testz');
H A Dbug_64037.phpt22 $stmt = $dbh->prepare($query);
30 $stmt = $dbh->prepare('DELETE FROM price');
/PHP-7.4/ext/pdo_oci/tests/
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');
143 $stmt = $db->prepare($query);

Completed in 29 milliseconds

12345678910>>...14