Home
last modified time | relevance | path

Searched refs:stmt (Results 76 – 100 of 490) sorted by relevance

12345678910>>...20

/PHP-8.1/ext/oci8/tests/
H A Dbind_empty.phpt22 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name");
23 oci_bind_by_name($stmt, ":name", $name);
25 var_dump(oci_execute($stmt));
31 oci_bind_by_name($stmt, ":name", $name);
33 var_dump(oci_execute($stmt));
38 $res = oci_execute($stmt);
41 $res = oci_execute($stmt);
45 oci_bind_by_name($stmt, ":name", $name);
47 var_dump(oci_execute($stmt));
58 oci_bind_by_name($stmt, ":name", $name);
[all …]
H A Dbug71422.phpt18 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1');
19 oci_execute($stmt);
20 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
24 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes…
26 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_INT);
27 oci_execute($stmt);
28 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
32 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test…
34 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_CHR);
35 oci_execute($stmt);
[all …]
H A Ddefine4.phpt22 $stmt = oci_parse($c, "select value, string from define4_tab");
26 var_dump(oci_define_by_name($stmt, "STRING", $string));
28 oci_execute($stmt);
32 while (oci_fetch($stmt)) {
33 var_dump(oci_result($stmt, 'VALUE'));
35 var_dump(oci_result($stmt, 'STRING'));
37 var_dump(oci_result($stmt, 'VALUE'));
38 var_dump(oci_result($stmt, 'STRING'));
42 var_dump(oci_free_statement($stmt));
46 var_dump(oci_result($stmt, 'STRING'));
/PHP-8.1/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_unbuffered_2050.phpt29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
49 $stmt = PDO::query(<some query>)
53 $stmt->fetchAll()
57 $stmt = PDO::query(<some query>)
64 $stmt = PDO::query(<some query>)
69 current value of stmt:
79 PDO to $stmt.
92 $stmt->execute();
96 $stmt->execute();
99 unset($stmt);
[all …]
H A Dpdo_mysql_stmt_closecursor_empty.phpt28 if (!$stmt->bindParam(1, $in))
30 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
32 $stmt->execute();
35 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
37 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
39 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
41 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
43 while ($stmt->fetch(PDO::FETCH_BOUND))
49 $stmt->closeCursor();
50 $stmt->execute();
[all …]
H A Dpdo_mysql_stmt_fetchobject_ctor_args.phpt13 $stmt = $db->prepare($query);
14 $ok = @$stmt->execute();
29 $stmt = $db->prepare($query);
44 $stmt->execute();
46 $obj = $stmt->fetchObject(Foo::class);
51 $stmt->execute();
58 $stmt->execute();
62 $stmt->execute();
63 $obj = $stmt->fetchObject(Bar::class);
66 $stmt->execute();
[all …]
H A Dbug67004.phpt19 $stmt = $dbh->prepare("SELECT ?");
21 $stmt->execute(["foo"]);
22 var_dump($stmt->fetchColumn(0));
24 $stmt->execute(["bar"]);
25 var_dump($stmt->fetchColumn(0));
27 $stmt = $dbh->prepare("SELECT ?");
28 $stmt->execute(["baz"]);
29 var_dump($stmt->fetchColumn(0));
H A Dpdo_mysql_prepare_emulated_anonymous.phpt26 $stmt->execute(array('first row'));
27 if ('00000' !== $stmt->errorCode())
29 var_export($stmt->errorCode(), true),
30 var_export($stmt->errorInfo(), true));
33 $stmt->execute();
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
45 $stmt->execute(array('first row'));
46 if ('00000' !== $stmt->errorCode())
48 var_export($stmt->errorCode(), true),
52 $stmt->execute();
[all …]
H A Dbug_44707.phpt13 $stmt = $db->query('SELECT VERSION() as _version');
14 $row = $stmt->fetch(PDO::FETCH_ASSOC);
40 $stmt->bindParam(1, $id);
44 $stmt->execute();
47 $stmt = $db->query('SELECT * FROM test');
48 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
51 $stmt->bindParam(1, $id);
53 $stmt->bindParam(2, $mybool, PDO::PARAM_INT);
54 $stmt->execute();
56 $stmt = $db->query('SELECT * FROM test');
[all …]
/PHP-8.1/ext/pdo_pgsql/
H A Dpgsql_statement.c127 stmt->driver_data = NULL; in pgsql_stmt_dtor()
137 bool in_trans = stmt->dbh->methods->in_transaction(stmt->dbh); in pgsql_stmt_execute()
183 stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, in pgsql_stmt_execute()
218 stmt->bound_params ? in pgsql_stmt_execute()
228 stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, in pgsql_stmt_execute()
257 if (in_trans && !stmt->dbh->methods->in_transaction(stmt->dbh)) { in pgsql_stmt_execute()
258 pdo_pgsql_close_lob_streams(stmt->dbh); in pgsql_stmt_execute()
286 if (stmt->bound_param_map && (namevar = zend_hash_find_ptr(stmt->bound_param_map, in pgsql_stmt_param_hook()
299 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook()
314 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook()
[all …]
/PHP-8.1/ext/mysqli/tests/
H A Dmysqli_stmt_send_long_data_packet_size_libmysql.phpt16 if (!$stmt = mysqli_stmt_init($link))
26 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
30 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label))
31 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
63 if (true !== mysqli_stmt_execute($stmt))
64 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
80 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
85 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_get_client_stats_ps.phpt25 if (!$stmt = mysqli_stmt_init($link))
30 !mysqli_stmt_execute($stmt) ||
31 !mysqli_stmt_store_result($stmt) ||
33 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 while (mysqli_stmt_fetch($stmt))
39 mysqli_stmt_free_result($stmt);
61 !mysqli_stmt_execute($stmt) ||
63 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 while (mysqli_stmt_fetch($stmt))
81 mysqli_stmt_free_result($stmt);
[all …]
H A Dmysqli_stmt_bind_result.phpt14 $stmt = mysqli_stmt_init($link);
16 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
18 mysqli_stmt_close($stmt);
19 $stmt = mysqli_stmt_init($link);
32 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
50 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 mysqli_stmt_close($stmt);
95 mysqli_stmt_close($stmt);
138 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
296 printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A D026.phpt22 $stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
23 mysqli_stmt_bind_param($stmt, "sb", $c1, $c2);
27 mysqli_stmt_send_long_data($stmt, 1, "This is the first sentence.");
28 mysqli_stmt_send_long_data($stmt, 1, " And this is the second sentence.");
31 mysqli_stmt_execute($stmt);
32 mysqli_stmt_close($stmt);
34 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
35 mysqli_stmt_bind_result($stmt, $d1, $d2);
36 mysqli_stmt_execute($stmt);
37 mysqli_stmt_fetch($stmt);
[all …]
H A Dmysqli_stmt_errno.phpt15 if (!$stmt = mysqli_stmt_init($link))
19 if (0 !== ($tmp = mysqli_stmt_errno($stmt)))
22 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
26 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
29 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
30 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
33 if (0 != ($tmp = mysqli_stmt_errno($stmt)))
38 if (true === ($tmp = mysqli_stmt_execute($stmt)))
42 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
45 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_error.phpt15 if (!$stmt = mysqli_stmt_init($link))
19 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
22 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
26 if ('' === ($tmp = mysqli_stmt_error($stmt)))
29 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
30 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt));
33 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
38 if (true === ($tmp = mysqli_stmt_execute($stmt)))
42 if ('' === ($tmp = mysqli_stmt_error($stmt)))
45 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_send_long_data_packet_size_mysqlnd.phpt16 if (!$stmt = mysqli_stmt_init($link))
26 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
30 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label))
31 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
57 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 if (true !== mysqli_stmt_execute($stmt))
61 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
85 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
88 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
90 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dbug42378.phpt69 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
73 if (!mysqli_stmt_execute($stmt)) {
76 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
97 if (!mysqli_stmt_fetch($stmt)) {
100 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
126 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
148 mysqli_stmt_free_result($stmt);
[all …]
/PHP-8.1/ext/pdo_sqlite/tests/
H A Dbug46139.phpt18 $stmt = $db->query("SELECT 'foo' test, 1");
19 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
20 $r1 = $stmt->fetch();
23 $stmt = $db->query("SELECT 'foo' test, 1");
24 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
25 $r1 = $stmt->fetchAll();
28 $stmt = $db->query("SELECT 'foo' test, 1");
29 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
30 $r1 = $stmt->fetch(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE);
/PHP-8.1/ext/pdo_dblib/tests/
H A Dbug_67130.phpt13 $stmt = $db->query('SELECT 1; SELECT 2; SELECT 3;');
14 var_dump($stmt->fetch());
15 var_dump($stmt->fetch());
16 var_dump($stmt->nextRowset());
17 var_dump($stmt->nextRowset());
18 var_dump($stmt->fetch());
19 var_dump($stmt->nextRowset());
H A Dbatch_stmt_ins_exec.phpt26 $stmt = $db->query(
33 var_dump($stmt->rowCount());
34 var_dump($stmt->nextRowset());
37 var_dump($stmt->rowCount());
38 var_dump($stmt->nextRowset());
41 var_dump($stmt->rowCount());
42 var_dump($stmt->nextRowset());
45 var_dump($stmt->rowCount());
46 var_dump($stmt->nextRowset());
49 var_dump($stmt->rowCount());
[all …]
/PHP-8.1/ext/pdo_firebird/tests/
H A Dbug_48877.phpt26 $stmt = $dbh->prepare($query);
27 $stmt->bindParam(':paramno', $value, PDO::PARAM_STR);
28 $stmt->execute();
29 $rows = $stmt->fetch();
30 var_dump($stmt->fetch());
31 var_dump($stmt->rowCount());
34 $stmt = $dbh->prepare('DELETE FROM testz');
35 $stmt->execute();
41 unset($stmt);
/PHP-8.1/ext/sqlite3/tests/
H A Dbug77051.phpt11 $stmt = $db->prepare('SELECT :a, :b, ?;');
14 $stmt->bindParam(':a', $a, SQLITE3_INTEGER);
15 $stmt->bindValue(':b', 'php');
16 $stmt->bindValue(':b', 'PHP');
17 $stmt->bindValue(3, 424242);
20 var_dump($res = $stmt->execute());
29 var_dump($res = $stmt->execute());
36 $stmt->bindValue(':b', 'TEST');
37 $stmt->bindValue(3, '!!!');
40 var_dump($res = $stmt->execute());
/PHP-8.1/ext/odbc/tests/
H A Dbug46050.phpt11 $stmt = odbc_prepare($conn, "SELECT 1");
12 var_dump(odbc_execute($stmt));
13 var_dump(odbc_fetch_array($stmt));
14 var_dump(odbc_next_result($stmt));
15 var_dump(odbc_execute($stmt));
16 var_dump(odbc_fetch_array($stmt));
/PHP-8.1/ext/pdo_pgsql/tests/
H A Dlarge_objects.phpt28 $stmt->bindValue(1, 1);
33 $stmt->bindParam(2, $stm, PDO::PARAM_LOB);
34 $stmt->execute();
38 $stmt = $db->prepare("SELECT * from test");
40 $stmt->execute();
42 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
49 $stmt = $db->prepare("SELECT * from test");
50 $stmt->execute();
53 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
60 $stmt = $db->prepare("SELECT * from test");
[all …]

Completed in 41 milliseconds

12345678910>>...20