Home
last modified time | relevance | path

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

12345678910>>...20

/PHP-8.1/ext/oci8/tests/
H A Ddefine3.phpt25 oci_bind_by_name($stmt,":id",$id);
28 oci_execute($stmt, OCI_DEFAULT);
38 oci_execute($stmt, OCI_DEFAULT);
45 oci_execute($stmt);
47 while (oci_fetch($stmt)) {
55 oci_execute($stmt);
57 while (oci_fetch($stmt)) {
64 oci_execute($stmt);
66 while (oci_fetch($stmt)) {
74 oci_execute($stmt);
[all …]
H A Dbind_long_raw.phpt15 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)");
16 oci_execute($stmt);
18 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)");
22 oci_bind_by_name( $stmt, ":id", $i, -1);
23 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_LBI);
24 oci_execute($stmt, OCI_DEFAULT);
27 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw");
28 oci_execute($stmt);
30 $row = oci_fetch_row($stmt);
34 $stmt = oci_parse($c, "drop table phptestlngraw");
[all …]
H A Dbind_raw.phpt15 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))");
16 oci_execute($stmt);
18 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)");
23 oci_bind_by_name( $stmt, ":id", $i, -1);
24 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_BIN);
25 oci_execute($stmt, OCI_DEFAULT);
28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable");
29 oci_execute($stmt);
31 $row = oci_fetch_row($stmt);
35 $stmt = oci_parse($c, "drop table phptestrawtable");
[all …]
H A Dbind_raw_2.phpt15 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))");
16 oci_execute($stmt);
18 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)");
23 oci_bind_by_name( $stmt, ":id", $i, -1);
24 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, OCI_B_BIN);
25 oci_execute($stmt, OCI_DEFAULT);
28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable");
29 oci_execute($stmt);
31 $row = oci_fetch_row($stmt);
35 $stmt = oci_parse($c, "drop table phptestrawtable");
[all …]
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 …]
/PHP-8.1/ext/mysqli/tests/
H A Dmysqli_stmt_num_rows.phpt15 if (!$stmt = mysqli_stmt_init($link))
21 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
25 if (!mysqli_stmt_execute($stmt)) {
26 … printf("[%03d] [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
31 … printf("[%03d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 mysqli_stmt_free_result($stmt);
65 printf("[051] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
67 if (mysqli_stmt_execute($stmt)) {
90 printf("[055] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_param_count.phpt15 if (!$stmt = mysqli_stmt_init($link))
19 mysqli_stmt_param_count($stmt);
24 function func_test_mysqli_stmt_param_count($stmt, $query, $expected, $offset) {
26 if (!mysqli_stmt_prepare($stmt, $query)) {
27 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_error($stmt));
31 if ($expected !== ($tmp = mysqli_stmt_param_count($stmt)))
38 func_test_mysqli_stmt_param_count($stmt, "SELECT 1 AS a", 0, 10);
39 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id) VALUES (?)", 1, 20);
40 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, ?)", 2, 30);
43 mysqli_stmt_close($stmt);
[all …]
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 Dbug55653.phpt19 if (!($stmt = $link->stmt_init()))
22 if (!($stmt->prepare("SELECT ?")) ||
23 !($stmt->bind_param("s", $in_and_out)) ||
24 !($stmt->execute()) ||
25 !($stmt->bind_result($in_and_out)))
26 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
28 if (!$stmt->fetch())
29 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
H A Dmysqli_stmt_store_result.phpt15 if (!$stmt = mysqli_stmt_init($link))
18 // stmt object status test
20 mysqli_stmt_store_result($stmt);
26 !mysqli_stmt_execute($stmt))
27 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
33 !mysqli_stmt_execute($stmt))
34 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
48 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
53 while (mysqli_stmt_fetch($stmt)) {
66 mysqli_stmt_close($stmt);
[all …]
H A D057.phpt24 mysqli_stmt_execute($stmt);
31 mysqli_stmt_close($stmt);
35 var_dump(mysqli_stmt_execute($stmt));
36 var_dump(mysqli_stmt_reset($stmt));
39 if ($stmt->affected_rows !== 0)
42 var_dump(mysqli_stmt_execute($stmt));
46 mysqli_stmt_execute($stmt);
47 $result1 = mysqli_stmt_result_metadata($stmt);
48 mysqli_stmt_store_result($stmt);
50 printf ("Rows: %d\n", mysqli_stmt_affected_rows($stmt));
[all …]
H A Dmysqli_stmt_get_warnings.phpt31 if (!$stmt = mysqli_stmt_init($link))
35 mysqli_stmt_get_warnings($stmt);
40 if (!mysqli_stmt_prepare($stmt, "SET sql_mode=''") || !mysqli_stmt_execute($stmt))
41 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt))
44 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
50 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 !mysqli_stmt_execute($stmt))
57 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
87 mysqli_stmt_close($stmt);
[all …]
H A D058.phpt23 mysqli_stmt_bind_param($stmt, "is", $a, $b);
28 mysqli_stmt_execute($stmt);
30 mysqli_stmt_bind_param($stmt, "is", $c, $d);
35 mysqli_stmt_execute($stmt);
36 mysqli_stmt_close($stmt);
38 $stmt = mysqli_prepare($link, "SELECT * FROM mbind");
39 mysqli_stmt_execute($stmt);
41 mysqli_stmt_bind_result($stmt, $e, $f);
42 mysqli_stmt_fetch($stmt);
44 mysqli_stmt_bind_result($stmt, $g, $h);
[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);
/PHP-8.1/ext/pdo_dblib/tests/
H A Dbatch_stmt_ins_up.phpt15 $stmt = $db->query(
24 var_dump($stmt->rowCount());
25 var_dump($stmt->nextRowset());
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());
37 var_dump($stmt->nextRowset());
40 var_dump($stmt->rowCount());
[all …]
H A Dbug_69592.phpt20 $stmt = $db->query($sql);
21 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
22 var_dump($stmt->nextRowset());
23 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
24 $stmt->closeCursor();
30 $stmt = $db->query($sql);
31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
32 var_dump($stmt->nextRowset());
33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
34 $stmt->closeCursor();
/PHP-8.1/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt31 if ('00000' !== $stmt->errorCode())
33 var_export($stmt->errorCode(), true),
38 $stmt->execute();
39 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
50 if ('00000' !== $stmt->errorCode())
57 $stmt->execute();
69 $stmt = $db->prepare($sql);
70 $stmt->execute(array(':placeholder' => 1));
71 if ('00000' !== $stmt->errorCode())
83 $stmt = $db->prepare($sql);
[all …]
H A Dpdo_mysql_stmt_bindparam.phpt24 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
26 $stmt->execute();
31 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
35 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
44 $stmt->execute();
57 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
59 if (!$stmt->execute())
61 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
65 $stmt->execute();
70 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
[all …]
H A Dpdo_mysql_stmt_variable_columncount.phpt28 $stmt->nextRowSet();
62 $stmt->execute();
76 $stmt->execute();
89 $stmt->execute();
90 check_result(11, $stmt, 1);
91 $stmt->execute();
92 check_result(12, $stmt, 2);
94 $stmt->execute();
105 $stmt->execute();
107 $stmt->execute();
[all …]
H A Dpdo_mysql_prepare_native_clear_error.phpt31 $stmt->execute(array(':placeholder' => 0));
32 if ('00000' !== $stmt->errorCode())
34 var_export($stmt->errorCode(), true),
38 $stmt->execute(array(':placeholder' => 0));
39 if ('00000' !== $stmt->errorCode())
41 var_export($stmt->errorCode(), true),
43 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
51 $stmt->execute(array(':placeholder' => 0));
52 if ('00000' !== $stmt->errorCode())
58 $stmt->execute(array(':placeholder' => 0));
[all …]
/PHP-8.1/ext/pdo_firebird/tests/
H A Dbug_47415.phpt24 $stmt = $dbh->prepare($query);
25 $stmt->bindColumn('idx', $idx);
26 $stmt->bindColumn('txt', $txt);
27 $stmt->execute();
28 $rows = $stmt->fetch(PDO::FETCH_BOUND);
29 var_dump($stmt->fetch());
30 var_dump($stmt->rowCount());
33 $stmt = $dbh->prepare('DELETE FROM testz');
34 $stmt->execute();
38 unset($stmt);
/PHP-8.1/ext/sqlite3/tests/
H A Dsqlite3stmt_getsql_expanded.phpt18 $stmt = $db->prepare('SELECT :a, :b, ?;');
20 $stmt->bindValue(':a', 42);
21 $stmt->bindValue(':b', 'php');
22 $stmt->bindValue(3, 43);
25 var_dump($stmt->getSQL(true));
28 var_dump($res = $stmt->execute());
33 $stmt->reset();
36 $stmt->bindValue(':a', 'TEST');
37 $stmt->bindValue(':b', '!!!');
38 $stmt->bindValue(3, 40);
[all …]
/PHP-8.1/ext/pdo_odbc/
H A Dodbc_stmt.c140 if (stmt->executed) { in odbc_stmt_dtor()
141 SQLCloseCursor(S->stmt); in odbc_stmt_dtor()
144 S->stmt = SQL_NULL_HANDLE; in odbc_stmt_dtor()
147 free_cols(stmt, S); in odbc_stmt_dtor()
163 if (stmt->executed) { in odbc_stmt_execute()
164 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
167 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 …]
/PHP-8.1/ext/pdo_firebird/
H A Dfirebird_statement.c31 #define RECORD_ERROR(stmt) _firebird_error(NULL, stmt, __FILE__, __LINE__) argument
87 RECORD_ERROR(stmt); in firebird_stmt_dtor()
193 RECORD_ERROR(stmt); in firebird_stmt_execute()
206 if (!stmt->executed) { in firebird_stmt_fetch()
222 stmt->row_count++; in firebird_stmt_fetch()
303 RECORD_ERROR(stmt); in firebird_fetch_blob()
309 RECORD_ERROR(stmt); in firebird_fetch_blob()
369 RECORD_ERROR(stmt); in firebird_fetch_blob()
511 RECORD_ERROR(stmt); in firebird_bind_blob()
536 RECORD_ERROR(stmt); in firebird_bind_blob()
[all …]
/PHP-8.1/ext/pdo_sqlite/tests/
H A Dbug33841.phpt12 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )");
13 $stmt->bindParam(':text', $name);
15 var_dump($stmt->execute(), $stmt->rowCount());
17 $stmt = $db->prepare("UPDATE test SET text = :text ");
18 $stmt->bindParam(':text', $name);
20 var_dump($stmt->execute(), $stmt->rowCount());

Completed in 38 milliseconds

12345678910>>...20