Home
last modified time | relevance | path

Searched refs:stmt (Results 51 – 75 of 467) sorted by relevance

12345678910>>...19

/PHP-7.4/ext/mysqli/tests/
H A Dbug55653.phpt18 if (!($stmt = $link->stmt_init()))
21 if (!($stmt->prepare("SELECT ?")) ||
22 !($stmt->bind_param("s", $in_and_out)) ||
23 !($stmt->execute()) ||
24 !($stmt->bind_result($in_and_out)))
25 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
27 if (!$stmt->fetch())
28 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
H A Dmysqli_stmt_bind_param_check_param_no_change.phpt27 $stmt->bind_result($one);
28 $stmt->execute();
29 $stmt->fetch();
30 $stmt->free_result();
44 $stmt->execute();
47 $stmt->bind_result($one, $two);
48 $stmt->fetch();
49 $stmt->free_result();
59 $stmt->execute();
60 $stmt->fetch();
[all …]
H A D057.phpt23 mysqli_stmt_execute($stmt);
30 mysqli_stmt_close($stmt);
34 var_dump(mysqli_stmt_execute($stmt));
35 var_dump(mysqli_stmt_reset($stmt));
38 if ($stmt->affected_rows !== 0)
41 var_dump(mysqli_stmt_execute($stmt));
43 var_dump(mysqli_stmt_reset($stmt));
46 mysqli_stmt_execute($stmt);
47 $result1 = mysqli_stmt_result_metadata($stmt);
48 mysqli_stmt_store_result($stmt);
[all …]
H A D058.phpt22 mysqli_stmt_bind_param($stmt, "is", $a, $b);
27 mysqli_stmt_execute($stmt);
29 mysqli_stmt_bind_param($stmt, "is", $c, $d);
34 mysqli_stmt_execute($stmt);
35 mysqli_stmt_close($stmt);
37 $stmt = mysqli_prepare($link, "SELECT * FROM mbind");
38 mysqli_stmt_execute($stmt);
40 mysqli_stmt_bind_result($stmt, $e, $f);
41 mysqli_stmt_fetch($stmt);
43 mysqli_stmt_bind_result($stmt, $g, $h);
[all …]
H A Dmysqli_stmt_num_rows.phpt24 if (!$stmt = mysqli_stmt_init($link))
30 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
34 if (!mysqli_stmt_execute($stmt)) {
35 … printf("[%03d] [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 … printf("[%03d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 mysqli_stmt_free_result($stmt);
74 printf("[051] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
76 if (mysqli_stmt_execute($stmt)) {
83 } while (mysqli_stmt_fetch($stmt));
99 printf("[055] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A D045.phpt12 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
13 mysqli_stmt_execute($stmt);
15 if (!$stmt->field_count) {
18 $stmt->close();
28 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
29 mysqli_stmt_execute($stmt);
31 mysqli_stmt_bind_result($stmt, $c1, $c2);
32 mysqli_stmt_fetch($stmt);
33 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_get_warnings.phpt40 if (!$stmt = mysqli_stmt_init($link))
43 if (false !== ($tmp = mysqli_stmt_get_warnings($stmt)))
46 if (!mysqli_stmt_prepare($stmt, "SET sql_mode=''") || !mysqli_stmt_execute($stmt))
47 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt))
50 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
55 …if (!mysqli_stmt_prepare($stmt, "CREATE TABLE test(id SMALLINT, label CHAR(1))") || !mysqli_stmt_e…
56 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
62 !mysqli_stmt_execute($stmt))
63 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
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 …]
/PHP-7.4/ext/pdo_dblib/tests/
H A Dbatch_stmt_ins_up.phpt14 $stmt = $db->query(
23 var_dump($stmt->rowCount());
24 var_dump($stmt->nextRowset());
27 var_dump($stmt->rowCount());
28 var_dump($stmt->nextRowset());
31 var_dump($stmt->rowCount());
32 var_dump($stmt->nextRowset());
35 var_dump($stmt->rowCount());
36 var_dump($stmt->nextRowset());
39 var_dump($stmt->rowCount());
[all …]
H A Dbug_69592.phpt19 $stmt = $db->query($sql);
20 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
21 var_dump($stmt->nextRowset());
22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
23 $stmt->closeCursor();
29 $stmt = $db->query($sql);
30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
31 var_dump($stmt->nextRowset());
32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
33 $stmt->closeCursor();
/PHP-7.4/ext/pdo_dblib/
H A Ddblib_stmt.c134 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbresults() returned FAIL"); in pdo_dblib_stmt_next_rowset_no_cancel()
146 stmt->row_count = DBCOUNT(H->link); in pdo_dblib_stmt_next_rowset_no_cancel()
147 stmt->column_count = num_fields; in pdo_dblib_stmt_next_rowset_no_cancel()
165 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbnextrow() returned FAIL"); in pdo_dblib_stmt_next_rowset()
180 pdo_dblib_stmt_cursor_closer(stmt); in pdo_dblib_stmt_execute()
192 stmt->row_count = DBCOUNT(H->link); in pdo_dblib_stmt_execute()
193 stmt->column_count = dbnumcols(H->link); in pdo_dblib_stmt_execute()
210 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbnextrow() returned FAIL"); in pdo_dblib_stmt_fetch()
236 col = &stmt->columns[colno]; in pdo_dblib_stmt_describe()
278 if (stmt->dbh->stringify) { in pdo_dblib_stmt_should_stringify_col()
[all …]
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt29 if ('00000' !== $stmt->errorCode())
31 var_export($stmt->errorCode(), true),
32 var_export($stmt->errorInfo(), true));
36 $stmt->execute();
48 if ('00000' !== $stmt->errorCode())
50 var_export($stmt->errorCode(), true),
55 $stmt->execute();
67 $stmt = $db->prepare($sql);
69 if ('00000' !== $stmt->errorCode())
81 $stmt = $db->prepare($sql);
[all …]
H A Dpdo_mysql_stmt_bindparam.phpt23 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
25 $stmt->execute();
30 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
34 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
43 $stmt->execute();
56 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
58 if (!$stmt->execute())
60 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
64 $stmt->execute();
69 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
[all …]
H A Dpdo_mysql_prepare_native_clear_error.phpt30 if ('00000' !== $stmt->errorCode())
32 var_export($stmt->errorCode(), true),
33 var_export($stmt->errorInfo(), true));
37 if ('00000' !== $stmt->errorCode())
39 var_export($stmt->errorCode(), true),
40 var_export($stmt->errorInfo(), true));
50 if ('00000' !== $stmt->errorCode())
52 var_export($stmt->errorCode(), true),
53 var_export($stmt->errorInfo(), true));
57 if ('00000' !== $stmt->errorCode())
[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 …]
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 …]
/PHP-7.4/ext/pdo_firebird/tests/
H A Dbug_47415.phpt21 $stmt = $dbh->prepare($query);
22 $stmt->bindColumn('idx', $idx);
23 $stmt->bindColumn('txt', $txt);
24 $stmt->execute();
25 $rows = $stmt->fetch(PDO::FETCH_BOUND);
26 var_dump($stmt->fetch());
27 var_dump($stmt->rowCount());
30 $stmt = $dbh->prepare('DELETE FROM testz');
31 $stmt->execute();
35 unset($stmt);
/PHP-7.4/ext/sqlite3/tests/
H A Dsqlite3stmt_getsql_expanded.phpt17 $stmt = $db->prepare('SELECT :a, :b, ?;');
19 $stmt->bindValue(':a', 42);
20 $stmt->bindValue(':b', 'php');
21 $stmt->bindValue(3, 43);
24 var_dump($stmt->getSQL(true));
27 var_dump($res = $stmt->execute());
32 $stmt->reset();
35 $stmt->bindValue(':a', 'TEST');
36 $stmt->bindValue(':b', '!!!');
37 $stmt->bindValue(3, 40);
[all …]
/PHP-7.4/ext/pdo_pgsql/
H A Dpgsql_statement.c129 stmt->driver_data = NULL; in pgsql_stmt_dtor()
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()
245 if (!stmt->executed && (!stmt->column_count || S->cols == NULL)) { in pgsql_stmt_execute()
282 if (stmt->bound_param_map && (namevar = zend_hash_find_ptr(stmt->bound_param_map, in pgsql_stmt_param_hook()
287 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", ZSTR_VAL(param->name)); in pgsql_stmt_param_hook()
295 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook()
299 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined"); in pgsql_stmt_param_hook()
309 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook()
[all …]
/PHP-7.4/ext/oci8/tests/
H A Ddefine5.phpt24 $stmt = oci_parse($c, "select string from define5_tab where id = 1");
25 oci_execute($stmt);
26 var_dump(oci_define_by_name($stmt, "STRING", $string));
27 while (oci_fetch($stmt)) {
29 var_dump(oci_result($stmt, 'STRING'));
34 var_dump(oci_define_by_name($stmt, "STRING", $string));
35 oci_execute($stmt);
37 while (oci_fetch($stmt)) {
43 oci_execute($stmt);
44 while (oci_fetch($stmt)) {
[all …]
H A Dbug71422.phpt20 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1');
21 oci_execute($stmt);
22 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
26 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes…
28 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_INT);
29 oci_execute($stmt);
30 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
34 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test…
36 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_CHR);
37 oci_execute($stmt);
[all …]
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 …]
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dbug33841.phpt14 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )");
15 $stmt->bindParam(':text', $name);
17 var_dump($stmt->execute(), $stmt->rowCount());
19 $stmt = $db->prepare("UPDATE test SET text = :text ");
20 $stmt->bindParam(':text', $name);
22 var_dump($stmt->execute(), $stmt->rowCount());
/PHP-7.4/ext/pdo_odbc/
H A Dodbc_stmt.c145 if (stmt->executed) { in odbc_stmt_dtor()
146 SQLCloseCursor(S->stmt); in odbc_stmt_dtor()
149 S->stmt = SQL_NULL_HANDLE; in odbc_stmt_dtor()
152 free_cols(stmt, S); in odbc_stmt_dtor()
168 if (stmt->executed) { in odbc_stmt_execute()
169 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
172 rc = SQLExecute(S->stmt); in odbc_stmt_execute()
208 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
224 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
264 stmt->row_count = row_count; in odbc_stmt_execute()
[all …]

Completed in 72 milliseconds

12345678910>>...19