Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-5.5/ext/mysqli/tests/
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.phpt41 !mysqli_stmt_fetch($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))
81 !mysqli_stmt_fetch($stmt))
82 printf("[018] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
87 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
94 !mysqli_stmt_fetch($stmt))
95 printf("[021] [%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_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_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));
74 printf("[015 - %d] [%d] %s\n", $i, mysqli_stmt_errno($stmt), mysqli_stmt_error($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.phpt28 !$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);
58 if (!$res = $stmt->get_result())
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_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_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))
79 mysqli_stmt_close($stmt);
85 if (!mysqli_stmt_bind_param($stmt, 's', $testvar) || !mysqli_stmt_execute($stmt))
[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 (NULL !== ($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 …]
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 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 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 …]
/PHP-5.5/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 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 …]
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 …]
/PHP-5.5/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));
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 …]
/PHP-5.5/ext/pdo/
H A Dpdo.php11 $stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES (:name, :value)"); variable
13 $stmt->bindParam(":name", $the_name, PDO_PARAM_STR, 32);
14 $stmt->bindParam(":value", $the_value, PDO_PARAM_STR, 32);
20 if (!$stmt->execute()) {
25 $stmt = null; variable
47 $stmt = $x->prepare("select NAME, VALUE from test where value like ?"); variable
49 $stmt->execute(array($the_name)) or die("failed to execute!");
50 $stmt->bindColumn('VALUE', $value);
52 while ($row = $stmt->fetch()) {
/PHP-5.5/ext/pdo_firebird/tests/
H A DrowCount.phpt22 $stmt = $dbh->prepare($query);
23 $stmt->execute(array('A'));
24 $rows = $stmt->fetch();
25 $rows = $stmt->fetch();
26 var_dump($stmt->fetch());
27 var_dump($stmt->rowCount());
30 $stmt->execute(array('A'));
31 var_dump($stmt->rowCount());
35 $stmt->execute();
36 var_dump($stmt->rowCount());
[all …]
/PHP-5.5/ext/pdo_odbc/
H A Dodbc_stmt.c146 if (stmt->executed) { in odbc_stmt_dtor()
147 SQLCloseCursor(S->stmt); in odbc_stmt_dtor()
150 S->stmt = SQL_NULL_HANDLE; in odbc_stmt_dtor()
153 free_cols(stmt, S TSRMLS_CC); in odbc_stmt_dtor()
169 if (stmt->executed) { in odbc_stmt_execute()
170 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
173 rc = SQLExecute(S->stmt); in odbc_stmt_execute()
203 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
219 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
259 stmt->row_count = row_count; in odbc_stmt_execute()
[all …]

Completed in 45 milliseconds

12345678910>>...16