Home
last modified time | relevance | path

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

12345678910>>...18

/PHP-8.2/ext/mysqli/tests/
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 …]
H A Dmysqli_stmt_param_count.phpt13 if (!$stmt = mysqli_stmt_init($link))
17 mysqli_stmt_param_count($stmt);
22 function func_test_mysqli_stmt_param_count($stmt, $query, $expected, $offset) {
24 if (!mysqli_stmt_prepare($stmt, $query)) {
25 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_error($stmt));
29 if ($expected !== ($tmp = mysqli_stmt_param_count($stmt)))
36 func_test_mysqli_stmt_param_count($stmt, "SELECT 1 AS a", 0, 10);
37 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id) VALUES (?)", 1, 20);
38 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, ?)", 2, 30);
41 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_num_rows.phpt13 if (!$stmt = mysqli_stmt_init($link))
19 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
23 if (!mysqli_stmt_execute($stmt)) {
24 … printf("[%03d] [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
29 … printf("[%03d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
38 mysqli_stmt_free_result($stmt);
63 printf("[051] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
65 if (mysqli_stmt_execute($stmt)) {
88 printf("[055] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
91 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_get_warnings.phpt27 if (!$stmt = mysqli_stmt_init($link))
31 mysqli_stmt_get_warnings($stmt);
36 if (!mysqli_stmt_prepare($stmt, "SET sql_mode=''") || !mysqli_stmt_execute($stmt))
37 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
39 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt))
40 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
52 !mysqli_stmt_execute($stmt))
53 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 mysqli_stmt_close($stmt);
[all …]
/PHP-8.2/ext/pdo_dblib/tests/
H A Dbatch_stmt_transaction.phpt16 $stmt = $db->query(
29 var_dump($stmt->rowCount());
33 var_dump($stmt->rowCount());
37 var_dump($stmt->rowCount());
41 var_dump($stmt->rowCount());
45 var_dump($stmt->rowCount());
49 var_dump($stmt->rowCount());
53 var_dump($stmt->fetchAll());
54 var_dump($stmt->rowCount());
58 var_dump($stmt->rowCount());
[all …]
H A Dbatch_stmt_try.phpt16 $stmt = $db->query(
32 var_dump($stmt->rowCount());
33 var_dump($stmt->nextRowset());
36 var_dump($stmt->rowCount());
40 var_dump($stmt->rowCount());
44 var_dump($stmt->rowCount());
48 var_dump($stmt->rowCount());
62 var_dump($stmt->fetchAll());
63 var_dump($stmt->rowCount());
67 var_dump($stmt->rowCount());
[all …]
H A Dbatch_stmt_ins_sel_up_del.phpt17 $stmt = $db->query(
28 var_dump($stmt->rowCount());
29 var_dump($stmt->nextRowset());
32 var_dump($stmt->rowCount());
33 var_dump($stmt->nextRowset());
36 var_dump($stmt->rowCount());
40 var_dump($stmt->rowCount());
44 var_dump($stmt->rowCount());
48 var_dump($stmt->rowCount());
52 var_dump($stmt->rowCount());
[all …]
H A Dbatch_stmt_ins_up.phpt16 $stmt = $db->query(
25 var_dump($stmt->rowCount());
26 var_dump($stmt->nextRowset());
29 var_dump($stmt->rowCount());
30 var_dump($stmt->nextRowset());
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());
[all …]
/PHP-8.2/ext/pdo_mysql/tests/
H A Dpecl_bug_5802.phpt16 $stmt = $db->prepare('insert into test_pcl_bug_5802 (bar) values(:bar)') or var_dump($db->errorInfo…
19 $stmt->bindParam(':bar', $bar);
20 $stmt->execute() or var_dump($stmt->errorInfo());
23 $stmt->bindParam(':bar', $bar);
24 $stmt->execute() or var_dump($stmt->errorInfo());
27 $stmt->bindParam(':bar', $bar);
28 $stmt->execute() or var_dump($stmt->errorInfo());
30 $stmt = $db->prepare('select * from test_pcl_bug_5802') or var_dump($db->errorInfo());
32 if($stmt) $stmt->execute();
33 if($stmt) var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dbug66878.phpt17 $stmt = $pdo->query($sql);
18 var_dump($stmt->nextRowset());
19 var_dump($stmt->nextRowset());
20 var_dump($stmt->nextRowset());
21 $stmt->closeCursor();
23 $stmt = $pdo->query($sql);
24 var_dump($stmt->nextRowset());
25 var_dump($stmt->nextRowset());
26 var_dump($stmt->nextRowset());
27 $stmt->closeCursor();
/PHP-8.2/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.2/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 …]
/PHP-8.2/ext/pdo_firebird/tests/
H A DrowCount.phpt23 $stmt = $dbh->prepare($query);
24 $stmt->execute(array('A'));
25 $rows = $stmt->fetch();
26 $rows = $stmt->fetch();
27 var_dump($stmt->fetch());
28 var_dump($stmt->rowCount());
31 $stmt->execute(array('A'));
32 var_dump($stmt->rowCount());
35 $stmt->execute();
36 var_dump($stmt->rowCount());
[all …]

Completed in 75 milliseconds

12345678910>>...18