Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-8.3/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_match_against.phpt21 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
25 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
29 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
H A Dbug44327.phpt17 $stmt = $db->prepare("SELECT 1 AS \"one\"");
30 $stmt = $db->prepare("SELECT id FROM test");
39 $stmt = $db->prepare('foo');
H A Dbug_61207.phpt20 $handle1 = $db->prepare('insert into test(id) values(1);
36 $handle2 = $db->prepare('select * from test where id = ?;
52 $handle3 = $db->prepare('update test set id = 2 where id = ?;
68 $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
26 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES (100, ':placeholder')");
39 $stmt = $db->prepare('SELECT id, label FROM test');
49 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(101, ':placeholder')");
59 $stmt = $db->prepare('SELECT id, label FROM test ORDER BY id');
H A Dpdo_mysql_stmt_errorinfo.phpt23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
29 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
46 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
50 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
109 Warning: PDO::prepare(): SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.ihopeitdoesn…
H A Dbug67004.phpt19 $stmt = $dbh->prepare("SELECT ?");
27 $stmt = $dbh->prepare("SELECT ?");
H A Dpdo_mysql_prepare_native.phpt2 MySQL PDO->prepare(), native PS
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])) {
31 $offset, $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_stmt_errorcode.phpt24 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
40 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
58 Warning: PDO::prepare(): SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.ihopeitdoesn…
/PHP-8.3/ext/pdo_firebird/tests/
H A Ddialect_1.phpt27 $query = $dbh->prepare($sql);
39 $query = $dbh->prepare($sql);
44 $query = $dbh->prepare($sql);
H A Dignore_parammarks.phpt22 $query = $dbh->prepare($sql);
33 $query = $dbh->prepare($sql);
H A Dbug_47415.phpt24 $stmt = $dbh->prepare($query);
33 $stmt = $dbh->prepare('DELETE FROM testz');
H A Dbug_62024.phpt23 $sttmt = $dbh->prepare($sql);
38 $sttmt = $dbh->prepare('DELETE FROM test_insert');
/PHP-8.3/ext/sqlite3/tests/
H A Dsqlite3_35_stmt_readonly.phpt26 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
30 $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?");
34 $stmt = $db->prepare("DELETE FROM test");
H A Dgh9032.phpt16 $st = $db->prepare('attach database :a AS "db2"');
26 Unable to prepare statement: not authorized
H A Dsqlite3_rename_column.phpt19 $res1 = $db->prepare('select * from tbl')->execute();
20 $res2 = $db->prepare('select * from tbl')->execute();
/PHP-8.3/ext/pdo/tests/
H A Dbug_40285.phpt2 PDO Common: Bug #40285 (The prepare parser goes into an infinite loop on ': or ":)
22 $s = $db->prepare("INSERT INTO test VALUES( ':id', 'name', 'section', 22)" );
H A Dpdo_021.phpt24 $select = $db->prepare('SELECT COUNT(id) FROM test');
37 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
46 $stmt2 = $db->prepare("INSERT INTO test VALUES(:first, :second, :third)");
H A Dbug_72368.phpt24 $stmt = $db->prepare($sql);
33 $stmt = $db->prepare($sql);
H A Dpdo_028.phpt19 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)');
28 $stmt = $db->prepare('SELECT * from test');
/PHP-8.3/ext/pdo_pgsql/tests/
H A Dbug71885.phpt24 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
30 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
H A Dbug70313.phpt20 $stmt = $db->prepare(");");
29 $stmt = $db->prepare(");");
/PHP-8.3/ext/pdo_sqlite/tests/
H A Dbug33841.phpt12 $stmt = $db->prepare("INSERT INTO test_33841 VALUES ( :text )");
17 $stmt = $db->prepare("UPDATE test_33841 SET text = :text ");
H A Dbug78192.phpt11 $stmt = $connection->prepare('INSERT INTO user (id, name) VALUES(:id, :name)');
17 $stmt = $connection->prepare('SELECT * FROM user WHERE id = :id');
/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_ps_select_union.phpt27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
46 The metadata mysqlnd has available after prepare is better than
51 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
81 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT …
100 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT …
128 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2")))
147 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2")))
167 if (!($stmt = $link->prepare("SELECT 'one' AS column1 UNION SELECT ? UNION SELECT ?")))
185 if (!($stmt = $link->prepare("SELECT 'one' AS column1 UNION SELECT ? UNION SELECT ?")))
205 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST(? AS CHAR) U…
[all …]
H A Dps_cursor_multiple_result_sets.phpt28 $stmt = $db->prepare("call testPs()");
43 $stmt = $db->prepare("call testPs()");
60 $stmt = $db->prepare("call testPs()");

Completed in 63 milliseconds

12345678910>>...16