Home
last modified time | relevance | path

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

12345678910>>...20

/PHP-8.3/ext/mysqli/tests/
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 …]
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.phpt13 if (!$stmt = mysqli_stmt_init($link))
16 // stmt object status test
18 mysqli_stmt_store_result($stmt);
24 !mysqli_stmt_execute($stmt))
25 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
31 !mysqli_stmt_execute($stmt))
32 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 while (mysqli_stmt_fetch($stmt)) {
64 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 D045.phpt11 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
12 mysqli_stmt_execute($stmt);
14 if (!$stmt->field_count) {
17 $stmt->close();
27 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
28 mysqli_stmt_execute($stmt);
30 mysqli_stmt_bind_result($stmt, $c1, $c2);
31 mysqli_stmt_fetch($stmt);
32 mysqli_stmt_close($stmt);
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 Dmysqli_stmt_bind_param_check_param_no_change.phpt32 $stmt->bind_result($one);
33 $stmt->execute();
34 $stmt->fetch();
35 $stmt->free_result();
49 $stmt->execute();
52 $stmt->bind_result($one, $two);
53 $stmt->fetch();
54 $stmt->free_result();
64 $stmt->execute();
65 $stmt->fetch();
[all …]
/PHP-8.3/ext/oci8/tests/
H A Ddefine3.phpt26 oci_bind_by_name($stmt,":id",$id);
29 oci_execute($stmt, OCI_DEFAULT);
39 oci_execute($stmt, OCI_DEFAULT);
46 oci_execute($stmt);
48 while (oci_fetch($stmt)) {
56 oci_execute($stmt);
58 while (oci_fetch($stmt)) {
65 oci_execute($stmt);
67 while (oci_fetch($stmt)) {
75 oci_execute($stmt);
[all …]
H A Dbind_long_raw.phpt16 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)");
17 oci_execute($stmt);
19 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)");
23 oci_bind_by_name( $stmt, ":id", $i, -1);
24 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_LBI);
25 oci_execute($stmt, OCI_DEFAULT);
28 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw");
29 oci_execute($stmt);
31 $row = oci_fetch_row($stmt);
35 $stmt = oci_parse($c, "drop table phptestlngraw");
[all …]
H A Dbind_raw.phpt16 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))");
17 oci_execute($stmt);
19 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)");
24 oci_bind_by_name( $stmt, ":id", $i, -1);
25 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_BIN);
26 oci_execute($stmt, OCI_DEFAULT);
29 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable");
30 oci_execute($stmt);
32 $row = oci_fetch_row($stmt);
36 $stmt = oci_parse($c, "drop table phptestrawtable");
[all …]
H A Dbind_raw_2.phpt16 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))");
17 oci_execute($stmt);
19 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)");
24 oci_bind_by_name( $stmt, ":id", $i, -1);
25 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, OCI_B_BIN);
26 oci_execute($stmt, OCI_DEFAULT);
29 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable");
30 oci_execute($stmt);
32 $row = oci_fetch_row($stmt);
36 $stmt = oci_parse($c, "drop table phptestrawtable");
[all …]
H A Ddefine5.phpt28 $stmt = oci_parse($c, "select string from define5_tab where id = 1");
29 oci_execute($stmt);
30 var_dump(oci_define_by_name($stmt, "STRING", $string));
31 while (oci_fetch($stmt)) {
33 var_dump(oci_result($stmt, 'STRING'));
38 var_dump(oci_define_by_name($stmt, "STRING", $string));
39 oci_execute($stmt);
41 while (oci_fetch($stmt)) {
47 oci_execute($stmt);
48 while (oci_fetch($stmt)) {
[all …]
/PHP-8.3/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.3/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 …]
H A Dpdo_mysql_stmt_unbuffered_2050.phpt29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
49 $stmt = PDO::query(<some query>)
53 $stmt->fetchAll()
57 $stmt = PDO::query(<some query>)
64 $stmt = PDO::query(<some query>)
69 current value of stmt:
79 PDO to $stmt.
92 $stmt->execute();
96 $stmt->execute();
99 unset($stmt);
[all …]
/PHP-8.3/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.3/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.3/ext/pdo_firebird/
H A Dfirebird_statement.c31 #define RECORD_ERROR(stmt) _firebird_error(NULL, stmt, __FILE__, __LINE__) argument
92 RECORD_ERROR(stmt); in firebird_stmt_dtor()
198 RECORD_ERROR(stmt); in firebird_stmt_execute()
211 if (!stmt->executed) { in firebird_stmt_fetch()
227 stmt->row_count++; in firebird_stmt_fetch()
311 RECORD_ERROR(stmt); in firebird_fetch_blob()
317 RECORD_ERROR(stmt); in firebird_fetch_blob()
377 RECORD_ERROR(stmt); in firebird_fetch_blob()
519 RECORD_ERROR(stmt); in firebird_bind_blob()
544 RECORD_ERROR(stmt); in firebird_bind_blob()
[all …]
/PHP-8.3/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()
209 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
225 SQLCloseCursor(S->stmt); in odbc_stmt_execute()
268 stmt->row_count = row_count; in odbc_stmt_execute()
[all …]

Completed in 52 milliseconds

12345678910>>...20