Home
last modified time | relevance | path

Searched refs:stmt (Results 26 – 50 of 492) sorted by relevance

12345678910>>...20

/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_stmt_free_result.phpt18 if (!$stmt = mysqli_stmt_init($link))
21 // stmt object status test
23 mysqli_stmt_free_result($stmt);
29 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
34 if (!mysqli_stmt_execute($stmt))
35 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 mysqli_stmt_close($stmt);
49 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 if (!mysqli_stmt_execute($stmt))
52 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_execute_bind.phpt20 $stmt->execute();
22 $stmt = null;
28 $stmt = null;
37 $stmt = null;
46 $stmt = null;
55 $stmt = null;
64 $stmt = null;
73 $stmt = null;
82 $stmt = null;
90 $stmt = null;
[all …]
H A Dmysqli_stmt_sqlstate.phpt13 if (!$stmt = mysqli_stmt_init($link))
17 mysqli_stmt_sqlstate($stmt);
22 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test"))
23 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
25 if ('00000' !== ($tmp = mysqli_stmt_sqlstate($stmt)))
27 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
30 printf("[008] Should fail! [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
32 if ('' === ($tmp = mysqli_stmt_sqlstate($stmt)))
33 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
35 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_fetch_fields_win32_unicode.phpt15 if (!($stmt = mysqli_stmt_init($link)) ||
17 !mysqli_stmt_execute($stmt) ||
18 !($result = mysqli_stmt_result_metadata($stmt)) ||
19 !mysqli_stmt_bind_result($stmt, $id, $bind_res) ||
23 while (mysqli_stmt_fetch($stmt)) {
27 mysqli_stmt_close($stmt);
29 if (!($stmt = mysqli_stmt_init($link)) ||
31 !mysqli_stmt_execute($stmt) ||
32 !($result = mysqli_stmt_result_metadata($stmt)) ||
40 while (mysqli_stmt_fetch($stmt)) {
[all …]
H A Dmysqli_stmt_fetch.phpt21 // stmt object status test
23 mysqli_stmt_fetch($stmt);
29 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
35 if (!mysqli_stmt_execute($stmt))
36 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
41 mysqli_stmt_close($stmt);
46 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
58 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_reset.phpt23 mysqli_stmt_reset($stmt);
30 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_fetch($stmt))
43 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46 mysqli_stmt_close($stmt);
57 printf("[013] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
61 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
70 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
73 printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dbug62046.phpt16 if (FALSE === ($stmt = $link->prepare('SELECT 42'))) {
19 if (FALSE === $stmt->execute()) {
20 printf("[003] Execute failed, [%d] %s\n", $stmt->errorno, $stmt->error);
22 if (FALSE === $stmt->store_result()) {
23 printf("[004] store_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
26 if (FALSE === $stmt->bind_result($one)) {
27 printf("[005] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
29 if (FALSE === $stmt->reset()) {
30 printf("[006] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
32 while ($stmt->fetch()) {
[all …]
H A Dmysqli_stmt_execute_stored_proc_next_result.phpt36 if (!mysqli_stmt_execute($stmt))
37 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 mysqli_stmt_free_result($stmt);
54 if (!mysqli_stmt_close($stmt))
82 printf("[018] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
87 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
95 printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
100 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_bind_param_references.phpt60 printf("[001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
68 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
79 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
90 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
101 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
109 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
130 printf("[019] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
140 printf("[022] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
150 printf("[025] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_prepare.phpt26 mysqli_stmt_close($stmt);
34 mysqli_stmt_close($stmt);
41 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
43 mysqli_stmt_close($stmt);
49 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
51 mysqli_stmt_close($stmt);
60 mysqli_stmt_close($stmt);
66 if (!mysqli_stmt_bind_param($stmt, 'i', $where) || !mysqli_stmt_execute($stmt))
74 if (!mysqli_stmt_bind_param($stmt, 's', $testvar) || !mysqli_stmt_execute($stmt))
86 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_bind_result($stmt, $id, $testvar))
[all …]
H A Dmysqli_stmt_get_result_field_count.phpt16 if (!$stmt = mysqli_stmt_init($link))
19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3"))
20 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
22 if (!mysqli_stmt_execute($stmt))
23 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
25 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
27 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
30 if (!is_object($res_meta = mysqli_stmt_result_metadata($stmt)) ||
33 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_get_result_non_select.phpt21 if (!$stmt = mysqli_stmt_init($link))
28 !$stmt->execute())
29 printf("[002] [%d] %s\n", $stmt->errno, $stmt->error);
31 if (!$res = $stmt->get_result())
32 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
55 !$stmt->execute())
56 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error);
59 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error);
74 !$stmt->execute())
75 printf("[009] [%d] %s\n", $stmt->errno, $stmt->error);
[all …]
H A Dgh8058.phpt17 $stmt = $mysqli->prepare("select 1,2,3");
18 $stmt->bind_result($a,$a,$a);
19 $stmt->prepare("");
21 unset($stmt); // trigger dtor
24 $stmt = $mysqli->prepare("select 1,2,3");
25 $stmt->bind_result($a,$a,$a);
26 $stmt->prepare("");
27 $stmt->prepare("select 1");
28 unset($stmt); // trigger dtor
31 $stmt = $mysqli->prepare("select 1,2,3");
[all …]
H A Dmysqli_stmt_fetch_geom.phpt43 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
44 mysqli_stmt_close($stmt);
48 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_store_result($stmt)) {
49 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
50 mysqli_stmt_close($stmt);
55 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 mysqli_stmt_close($stmt);
75 $offset + 17, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
78 mysqli_stmt_close($stmt);
87 … printf("[%04d] [%d] %s\n", $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
/PHP-8.3/ext/oci8/tests/
H A Dbind_long.phpt17 @oci_execute($stmt);
20 oci_execute($stmt);
29 oci_bind_by_name( $stmt, ":id", $i, -1);
31 oci_execute($stmt, OCI_DEFAULT);
35 oci_execute($stmt);
37 $row = oci_fetch_row($stmt);
47 oci_bind_by_name( $stmt, ":id", $i, -1);
49 oci_execute($stmt, OCI_DEFAULT);
53 oci_execute($stmt);
55 $row = oci_fetch_row($stmt);
[all …]
H A Ddefine2.phpt29 oci_bind_by_name( $stmt, ":id", $i, -1);
31 oci_execute($stmt, OCI_DEFAULT);
36 var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $fi));
37 oci_execute($stmt);
39 while (oci_fetch($stmt)) {
47 oci_execute($stmt);
49 while (oci_fetch($stmt)) {
57 oci_execute($stmt);
59 while (oci_fetch($stmt)) {
67 oci_execute($stmt);
[all …]
H A Dbug71148.phpt48 $stmt = oci_parse($c, $sql);
53 oci_execute($stmt);
57 oci_free_statement($stmt);
70 oci_execute($stmt);
75 oci_free_statement($stmt);
88 oci_execute($stmt);
93 oci_free_statement($stmt);
107 oci_execute($stmt);
125 oci_execute($stmt);
131 oci_free_statement($stmt);
[all …]
/PHP-8.3/ext/pdo_dblib/tests/
H A Dbatch_stmt_transaction.phpt15 $stmt = $db->query(
28 var_dump($stmt->rowCount());
32 var_dump($stmt->rowCount());
36 var_dump($stmt->rowCount());
40 var_dump($stmt->rowCount());
44 var_dump($stmt->rowCount());
48 var_dump($stmt->rowCount());
52 var_dump($stmt->fetchAll());
53 var_dump($stmt->rowCount());
57 var_dump($stmt->rowCount());
[all …]
H A Dbatch_stmt_try.phpt15 $stmt = $db->query(
31 var_dump($stmt->rowCount());
32 var_dump($stmt->nextRowset());
35 var_dump($stmt->rowCount());
39 var_dump($stmt->rowCount());
43 var_dump($stmt->rowCount());
47 var_dump($stmt->rowCount());
61 var_dump($stmt->fetchAll());
62 var_dump($stmt->rowCount());
66 var_dump($stmt->rowCount());
[all …]
H A Dbatch_stmt_ins_sel_up_del.phpt15 $stmt = $db->query(
26 var_dump($stmt->rowCount());
27 var_dump($stmt->nextRowset());
30 var_dump($stmt->rowCount());
31 var_dump($stmt->nextRowset());
34 var_dump($stmt->rowCount());
38 var_dump($stmt->rowCount());
42 var_dump($stmt->rowCount());
46 var_dump($stmt->rowCount());
50 var_dump($stmt->rowCount());
[all …]
/PHP-8.3/ext/pdo/tests/
H A Dbug_71447.phpt25 $stmt = $db->prepare("
31 $stmt->execute();
35 $stmt = $db->prepare("
41 $stmt->execute();
45 $stmt = $db->prepare("
51 $stmt->execute();
55 $stmt = $db->prepare("
61 $stmt->execute();
65 $stmt = $db->prepare("
71 $stmt->execute();
[all …]
/PHP-8.3/ext/pdo_mysql/tests/
H A Dpecl_bug_5802.phpt18 $stmt = $db->prepare('insert into test (bar) values(:bar)') or var_dump($db->errorInfo());
21 $stmt->bindParam(':bar', $bar);
22 $stmt->execute() or var_dump($stmt->errorInfo());
25 $stmt->bindParam(':bar', $bar);
26 $stmt->execute() or var_dump($stmt->errorInfo());
29 $stmt->bindParam(':bar', $bar);
30 $stmt->execute() or var_dump($stmt->errorInfo());
32 $stmt = $db->prepare('select * from test') or var_dump($db->errorInfo());
34 if($stmt) $stmt->execute();
35 if($stmt) var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dbug66878.phpt18 $stmt = $pdo->query($sql);
19 var_dump($stmt->nextRowset());
20 var_dump($stmt->nextRowset());
21 var_dump($stmt->nextRowset());
22 $stmt->closeCursor();
24 $stmt = $pdo->query($sql);
25 var_dump($stmt->nextRowset());
26 var_dump($stmt->nextRowset());
27 var_dump($stmt->nextRowset());
28 $stmt->closeCursor();
/PHP-8.3/ext/pdo_firebird/tests/
H A DrowCount.phpt24 $stmt = $dbh->prepare($query);
25 $stmt->execute(array('A'));
26 $rows = $stmt->fetch();
27 $rows = $stmt->fetch();
28 var_dump($stmt->fetch());
29 var_dump($stmt->rowCount());
32 $stmt->execute(array('A'));
33 var_dump($stmt->rowCount());
37 $stmt->execute();
38 var_dump($stmt->rowCount());
[all …]
/PHP-8.3/ext/pdo_dblib/
H A Ddblib_stmt.c131 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbresults() returned FAIL"); in pdo_dblib_stmt_next_rowset_no_cancel()
143 stmt->row_count = DBCOUNT(H->link); in pdo_dblib_stmt_next_rowset_no_cancel()
144 stmt->column_count = num_fields; in pdo_dblib_stmt_next_rowset_no_cancel()
162 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbnextrow() returned FAIL"); in pdo_dblib_stmt_next_rowset()
177 pdo_dblib_stmt_cursor_closer(stmt); in pdo_dblib_stmt_execute()
189 stmt->row_count = DBCOUNT(H->link); in pdo_dblib_stmt_execute()
190 stmt->column_count = dbnumcols(H->link); in pdo_dblib_stmt_execute()
207 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbnextrow() returned FAIL"); in pdo_dblib_stmt_fetch()
233 col = &stmt->columns[colno]; in pdo_dblib_stmt_describe()
274 if (stmt->dbh->stringify) { in pdo_dblib_stmt_should_stringify_col()
[all …]

Completed in 55 milliseconds

12345678910>>...20