Home
last modified time | relevance | path

Searched refs:stmt (Results 251 – 275 of 467) sorted by last modified time

1...<<111213141516171819

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_columncount.phpt25 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test");
26 $stmt->execute();
27 var_dump($stmt->columnCount());
29 $stmt = $db->query('SELECT * FROM test');
30 var_dump($stmt->columnCount());
43 $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test");
44 $stmt->execute();
45 var_dump($stmt->columnCount());
47 $stmt = $db->query('SELECT * FROM test');
48 var_dump($stmt->columnCount());
H A Dpdo_mysql_stmt_errorcode.phpt23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
24 $stmt->execute();
25 var_dump($stmt->errorCode());
39 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
40 $stmt->execute();
41 var_dump($stmt->errorCode());
H A Dpdo_mysql_stmt_unbuffered_2050.phpt28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
48 $stmt = PDO::query(<some query>)
52 $stmt->fetchAll()
56 $stmt = PDO::query(<some query>)
63 $stmt = PDO::query(<some query>)
68 current value of stmt:
78 PDO to $stmt.
91 $stmt->execute();
95 $stmt->execute();
98 unset($stmt);
[all …]
H A Dpdo_mysql_stmt_variable_columncount.phpt65 $stmt->execute();
79 $stmt->execute();
92 $stmt->execute();
93 check_result(11, $stmt, 1);
94 $stmt->execute();
95 check_result(12, $stmt, 2);
97 $stmt->execute();
98 check_result(13, $stmt, 1);
108 $stmt->execute();
110 $stmt->execute();
[all …]
/PHP-7.4/ext/pdo_oci/tests/
H A Dbug46274.phpt27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl…
35 $stmt->bindparam(':id', $id);
36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
37 $stmt->execute();
45 $stmt->bindparam(':id', $id);
46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
47 $stmt->execute();
H A Dbug54379.phpt24 $stmt = $db->prepare("SELECT * FROM test");
25 $stmt->execute();
26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_oci_attr_action.phpt18 $stmt = $dbh->query($query);
19 $row = $stmt->fetch();
25 $stmt = $dbh->query($query);
26 $row = $stmt->fetch();
32 $stmt = $dbh->query($query);
33 $row = $stmt->fetch();
39 $stmt = $dbh->query($query);
40 $row = $stmt->fetch();
H A Dpdo_oci_attr_client_info.phpt18 $stmt = $dbh->query($query);
19 $row = $stmt->fetch();
25 $stmt = $dbh->query($query);
26 $row = $stmt->fetch();
32 $stmt = $dbh->query($query);
33 $row = $stmt->fetch();
39 $stmt = $dbh->query($query);
40 $row = $stmt->fetch();
H A Dpdo_oci_fread_1.phpt30 foreach ($stmtarray as $stmt) {
31 $dbh->exec($stmt);
53 foreach ($stmtarray as $stmt) {
54 $dbh->exec($stmt);
H A Dpdo_oci_quote1.phpt17 $stmt = $db->prepare('select * from poq_tab');
33 $stmt->execute();
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_oci_stmt_getcolumnmeta.phpt41 $stmt->execute();
66 $stmt->execute();
67 $native = $stmt->getColumnMeta(0);
77 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
138 $stmt = $db->prepare($sql);
139 $stmt->execute();
148 $stmt->execute();
149 $meta = $stmt->getColumnMeta(1);
221 $meta = $stmt->getColumnMeta(0);
234 $stmt = $db->prepare($sql);
[all …]
H A Dpdo_oci_stream_1.phpt26 foreach ($stmtarray as $stmt) {
27 $dbh->exec($stmt);
82 foreach ($stmtarray as $stmt) {
83 $dbh->exec($stmt);
H A Dpdo_oci_stream_2a.phpt18 $stmt = $db->prepare($query);
19 $stmt->execute();
22 $stmt = $db->prepare($query);
23 $stmt->execute();
28 …$stmt = $db->prepare("insert into pdo_oci_stream_2 (id, data1, data2) values (:id, empty_blob(), e…
29 $stmt->bindParam(':id', $id);
30 $stmt->bindParam(':blob1', $blob1, PDO::PARAM_LOB);
31 $stmt->bindParam(':blob2', $blob2, PDO::PARAM_LOB);
34 $stmt->execute();
H A Dpdo_oci_templob_1.phpt27 $stmt->execute();
28 $row = $stmt->fetch();
30 $stmt->execute();
33 $stmt->execute();
36 $stmt->execute();
39 $stmt->execute();
42 $stmt->execute();
45 $stmt->execute();
48 $stmt->execute();
51 $stmt->execute();
[all …]
H A Dpecl_bug_6364.phpt21 $stmt = $dbh->prepare("call bug_6364_sp('p1','p2','p3',?,?)");
26 $stmt->bindParam(1, $out_param1,PDO::PARAM_STR, 1024);
27 $stmt->bindParam(2, $out_param2,PDO::PARAM_STR, 1024);
29 $stmt->execute() or die ("Execution error: " . var_dump($dbh->errorInfo()));
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug70861.phpt35 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)", array(PDO::ATTR_CURSOR => P…
37 $stmt->bindparam(':foo', $f, PDO::PARAM_LOB);
38 $stmt->execute();
H A Dbug71885.phpt22 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
23 $stmt->execute();
28 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
29 $stmt->execute();
31 var_dump($stmt->fetch());
H A Dbug71885_2.phpt30 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?");
31 $stmt->execute(['b']);
32 var_dump($stmt->fetch());
34 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???");
35 $stmt->execute(['a']);
36 var_dump($stmt->fetch());
H A Dcopy_from.phpt43 $stmt = $db->query("select * from test");
44 foreach($stmt as $r) {
52 $stmt = $db->query("select * from test");
53 foreach($stmt as $r) {
61 $stmt = $db->query("select * from test");
62 foreach($stmt as $r) {
80 $stmt = $db->query("select * from test");
81 foreach($stmt as $r) {
89 $stmt = $db->query("select * from test");
90 foreach($stmt as $r) {
[all …]
H A Dbug36727.phpt16 $stmt = $db->prepare('SELECT * FROM child');
17 var_dump($stmt->bindValue(':test', 1, PDO::PARAM_INT));
H A Dbug43925.phpt31 $stmt = $dbh->prepare('
41 $stmt->bindValue('left', 1, PDO::PARAM_INT);
42 $stmt->bindValue('rootId', 3, PDO::PARAM_INT);
43 $stmt->bindValue('x', 5, PDO::PARAM_INT);
44 $stmt->bindValue('y', 50, PDO::PARAM_INT);
46 $stmt->execute();
48 foreach ($stmt->fetchAll() as $row) {
H A Dbug46274.phpt24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)");
31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
32 $stmt->execute();
35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
36 $stmt->execute();
43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
44 $stmt->execute();
47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
48 $stmt->execute();
H A Dbug46274_2.phpt24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)");
31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
32 $stmt->execute();
35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
36 $stmt->execute();
43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
44 $stmt->execute();
47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
48 $stmt->execute();
H A Dbug48764.phpt54 $stmt = $db->prepare("SELECT ?", $options);
55 $stmt->execute(array(1));
H A Dbug66584.phpt49 $stmt = $pdo->prepare("SELECT COUNT(*) FROM b66584 WHERE a IN ({$bind})");
53 $stmt->execute($data);
55 var_dump($stmt->fetchColumn());

Completed in 43 milliseconds

1...<<111213141516171819