Home
last modified time | relevance | path

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

12345678910>>...19

/PHP-7.4/ext/mysqli/tests/
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_multires.phpt27 printf("[003] [%d] %s\n", $stmt->error, $stmt->errno);
31 printf("[005] [%d] %s\n", $stmt->error, $stmt->errno);
37 printf("[004] [%d] %s\n", $stmt->error, $stmt->errno);
41 if (!$stmt->fetch()) {
42 printf("[006] [%d] %s\n", $stmt->error, $stmt->errno);
47 if ($stmt->fetch()) {
52 if ($stmt->fetch()) {
63 printf("[010] [%d] %s\n", $stmt->error, $stmt->errno);
68 printf("[011] [%d] %s\n", $stmt->error, $stmt->errno);
73 if ($stmt->fetch()) {
[all …]
H A Dbug62046.phpt15 if (FALSE === ($stmt = $link->prepare('SELECT 42'))) {
18 if (FALSE === $stmt->execute()) {
19 printf("[003] Execute failed, [%d] %s\n", $stmt->errorno, $stmt->error);
21 if (FALSE === $stmt->store_result()) {
22 printf("[004] store_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
25 if (FALSE === $stmt->bind_result($one)) {
26 printf("[005] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
28 if (FALSE === $stmt->reset()) {
29 printf("[006] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
31 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_free_result.phpt29 if (!$stmt = mysqli_stmt_init($link))
32 // stmt object status test
37 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_execute($stmt))
43 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 mysqli_stmt_close($stmt);
53 if (!$stmt = mysqli_stmt_init($link))
57 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
59 if (!mysqli_stmt_execute($stmt))
60 printf("[012] [%d] %s\n", 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_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_reset.phpt38 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
48 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
50 if (!mysqli_stmt_fetch($stmt))
51 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
54 mysqli_stmt_close($stmt);
65 printf("[013] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
69 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
77 if (!mysqli_stmt_reset($stmt))
78 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
81 printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
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 Dmysqli_prepare.phpt37 mysqli_stmt_close($stmt);
45 mysqli_stmt_close($stmt);
52 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
54 mysqli_stmt_close($stmt);
60 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
62 mysqli_stmt_close($stmt);
71 mysqli_stmt_close($stmt);
77 if (!mysqli_stmt_bind_param($stmt, 'i', $where) || !mysqli_stmt_execute($stmt))
85 if (!mysqli_stmt_bind_param($stmt, 's', $testvar) || !mysqli_stmt_execute($stmt))
97 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_bind_result($stmt, $id, $testvar))
[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_fetch.phpt29 if (!$stmt = mysqli_stmt_init($link))
32 // stmt object status test
37 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 if (!mysqli_stmt_execute($stmt))
44 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 mysqli_stmt_close($stmt);
54 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 if (!mysqli_stmt_execute($stmt))
57 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_sqlstate.phpt27 if (!$stmt = mysqli_stmt_init($link))
30 if (false !== ($tmp = mysqli_stmt_sqlstate($stmt)))
33 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test"))
34 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 if ('00000' !== ($tmp = mysqli_stmt_sqlstate($stmt)))
38 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
41 printf("[008] Should fail! [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 if ('' === ($tmp = mysqli_stmt_sqlstate($stmt)))
44 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46 mysqli_stmt_close($stmt);
[all …]
/PHP-7.4/ext/pdo_dblib/tests/
H A Dbatch_stmt_transaction.phpt14 $stmt = $db->query(
27 var_dump($stmt->rowCount());
31 var_dump($stmt->rowCount());
35 var_dump($stmt->rowCount());
39 var_dump($stmt->rowCount());
43 var_dump($stmt->rowCount());
47 var_dump($stmt->rowCount());
51 var_dump($stmt->fetchAll());
52 var_dump($stmt->rowCount());
56 var_dump($stmt->rowCount());
[all …]
H A Dbatch_stmt_try.phpt14 $stmt = $db->query(
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());
60 var_dump($stmt->fetchAll());
61 var_dump($stmt->rowCount());
65 var_dump($stmt->rowCount());
[all …]
H A Dbatch_stmt_ins_sel_up_del.phpt14 $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());
37 var_dump($stmt->rowCount());
41 var_dump($stmt->rowCount());
45 var_dump($stmt->rowCount());
49 var_dump($stmt->rowCount());
[all …]
/PHP-7.4/ext/pdo/tests/
H A Dbug_71447.phpt24 $stmt = $db->prepare("
30 $stmt->execute();
34 $stmt = $db->prepare("
40 $stmt->execute();
44 $stmt = $db->prepare("
50 $stmt->execute();
54 $stmt = $db->prepare("
60 $stmt->execute();
64 $stmt = $db->prepare("
70 $stmt->execute();
[all …]
/PHP-7.4/ext/pdo_firebird/tests/
H A DrowCount.phpt21 $stmt = $dbh->prepare($query);
22 $stmt->execute(array('A'));
23 $rows = $stmt->fetch();
24 $rows = $stmt->fetch();
25 var_dump($stmt->fetch());
26 var_dump($stmt->rowCount());
29 $stmt->execute(array('A'));
30 var_dump($stmt->rowCount());
34 $stmt->execute();
35 var_dump($stmt->rowCount());
[all …]
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpecl_bug_5802.phpt16 $stmt = $db->prepare('insert into test (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') or var_dump($db->errorInfo());
32 if($stmt) $stmt->execute();
33 if($stmt) var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-7.4/ext/oci8/tests/
H A Ddefine2.phpt26 oci_bind_by_name( $stmt, ":id", $i, -1);
28 oci_execute($stmt, OCI_DEFAULT);
33 var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $fi));
34 oci_execute($stmt);
36 while (oci_fetch($stmt)) {
44 oci_execute($stmt);
46 while (oci_fetch($stmt)) {
54 oci_execute($stmt);
56 while (oci_fetch($stmt)) {
64 oci_execute($stmt);
[all …]
H A Dbind_long_raw.phpt13 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)");
14 oci_execute($stmt);
16 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)");
20 oci_bind_by_name( $stmt, ":id", $i, -1);
21 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_LBI);
22 oci_execute($stmt, OCI_DEFAULT);
25 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw");
26 oci_execute($stmt);
28 $row = oci_fetch_row($stmt);
32 $stmt = oci_parse($c, "drop table phptestlngraw");
[all …]
H A Dbind_raw.phpt13 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))");
14 oci_execute($stmt);
16 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)");
21 oci_bind_by_name( $stmt, ":id", $i, -1);
22 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_BIN);
23 oci_execute($stmt, OCI_DEFAULT);
26 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable");
27 oci_execute($stmt);
29 $row = oci_fetch_row($stmt);
33 $stmt = oci_parse($c, "drop table phptestrawtable");
[all …]
H A Dbind_raw_2.phpt13 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))");
14 oci_execute($stmt);
16 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)");
21 oci_bind_by_name( $stmt, ":id", $i, -1);
22 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, OCI_B_BIN);
23 oci_execute($stmt, OCI_DEFAULT);
26 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable");
27 oci_execute($stmt);
29 $row = oci_fetch_row($stmt);
33 $stmt = oci_parse($c, "drop table phptestrawtable");
[all …]
H A Dbug71148.phpt45 $stmt = oci_parse($c, $sql);
50 oci_execute($stmt);
54 oci_free_statement($stmt);
67 oci_execute($stmt);
72 oci_free_statement($stmt);
85 oci_execute($stmt);
90 oci_free_statement($stmt);
104 oci_execute($stmt);
122 oci_execute($stmt);
128 oci_free_statement($stmt);
[all …]
H A Ddefine3.phpt23 oci_bind_by_name($stmt,":id",$id);
26 oci_execute($stmt, OCI_DEFAULT);
36 oci_execute($stmt, OCI_DEFAULT);
43 oci_execute($stmt);
45 while (oci_fetch($stmt)) {
53 oci_execute($stmt);
55 while (oci_fetch($stmt)) {
62 oci_execute($stmt);
64 while (oci_fetch($stmt)) {
72 oci_execute($stmt);
[all …]

Completed in 35 milliseconds

12345678910>>...19