Home
last modified time | relevance | path

Searched refs:stmt (Results 76 – 100 of 467) sorted by relevance

12345678910>>...19

/PHP-7.4/ext/pdo_sqlite/tests/
H A Dbug46139.phpt20 $stmt = $db->query("SELECT 'foo' test, 1");
21 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
22 $r1 = $stmt->fetch();
25 $stmt = $db->query("SELECT 'foo' test, 1");
26 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
27 $r1 = $stmt->fetchAll();
30 $stmt = $db->query("SELECT 'foo' test, 1");
31 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
32 $r1 = $stmt->fetch(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE);
/PHP-7.4/ext/pdo_firebird/tests/
H A Dbug_48877.phpt23 $stmt = $dbh->prepare($query);
24 $stmt->bindParam(':paramno', $value, PDO::PARAM_STR);
25 $stmt->execute();
26 $rows = $stmt->fetch();
27 var_dump($stmt->fetch());
28 var_dump($stmt->rowCount());
31 $stmt = $dbh->prepare('DELETE FROM testz');
32 $stmt->execute();
38 unset($stmt);
/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_store_result.phpt27 if (!$stmt = mysqli_stmt_init($link))
30 // stmt object status test
31 if (false !== ($tmp = @mysqli_stmt_store_result($stmt)))
35 !mysqli_stmt_execute($stmt))
36 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 !mysqli_stmt_execute($stmt))
43 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 if (!mysqli_stmt_bind_result($stmt, $id, $label))
57 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
62 while (mysqli_stmt_fetch($stmt)) {
[all …]
H A D026.phpt21 $stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
22 mysqli_stmt_bind_param($stmt, "sb", $c1, $c2);
26 mysqli_stmt_send_long_data($stmt, 1, "This is the first sentence.");
27 mysqli_stmt_send_long_data($stmt, 1, " And this is the second sentence.");
30 mysqli_stmt_execute($stmt);
31 mysqli_stmt_close($stmt);
33 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
34 mysqli_stmt_bind_result($stmt, $d1, $d2);
35 mysqli_stmt_execute($stmt);
36 mysqli_stmt_fetch($stmt);
[all …]
H A Dmysqli_stmt_param_count.phpt24 if (!$stmt = mysqli_stmt_init($link))
27 if (false !== ($tmp = mysqli_stmt_param_count($stmt)))
30 function func_test_mysqli_stmt_param_count($stmt, $query, $expected, $offset) {
32 if (!mysqli_stmt_prepare($stmt, $query)) {
33 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_error($stmt));
37 if ($expected !== ($tmp = mysqli_stmt_param_count($stmt)))
44 func_test_mysqli_stmt_param_count($stmt, "SELECT 1 AS a", 0, 10);
45 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id) VALUES (?)", 1, 20);
46 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, ?)", 2, 30);
49 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_send_long_data_packet_size_mysqlnd.phpt16 if (!$stmt = mysqli_stmt_init($link))
26 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
30 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label))
31 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
57 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 if (true !== mysqli_stmt_execute($stmt))
61 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
85 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
88 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
90 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_send_long_data.phpt24 if (!$stmt = mysqli_stmt_init($link))
37 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
41 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label))
42 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
81 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
85 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
89 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
96 if (true !== mysqli_stmt_execute($stmt))
97 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dbug42378.phpt69 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
73 if (!mysqli_stmt_execute($stmt)) {
76 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
97 if (!mysqli_stmt_fetch($stmt)) {
100 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
126 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
148 mysqli_stmt_free_result($stmt);
[all …]
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_closecursor_empty.phpt27 if (!$stmt->bindParam(1, $in))
29 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
31 $stmt->execute();
34 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
36 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
38 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
40 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
42 while ($stmt->fetch(PDO::FETCH_BOUND))
48 $stmt->closeCursor();
49 $stmt->execute();
[all …]
H A Dpdo_mysql_prepare_emulated_anonymous.phpt25 $stmt->execute(array('first row'));
26 if ('00000' !== $stmt->errorCode())
28 var_export($stmt->errorCode(), true),
29 var_export($stmt->errorInfo(), true));
32 $stmt->execute();
33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
44 $stmt->execute(array('first row'));
45 if ('00000' !== $stmt->errorCode())
47 var_export($stmt->errorCode(), true),
48 var_export($stmt->errorInfo(), true));
[all …]
H A Dpdo_mysql_prepare_native_named_placeholder.phpt31 $stmt->execute(array(':placeholder' => 'row1'));
32 if ('00000' !== $stmt->errorCode())
34 var_export($stmt->errorCode(), true),
35 var_export($stmt->errorInfo(), true));
39 $stmt->execute();
40 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
52 if ('00000' !== $stmt->errorCode())
54 var_export($stmt->errorCode(), true),
55 var_export($stmt->errorInfo(), true));
59 $stmt->execute();
[all …]
H A Dbug_44707.phpt13 $row = $stmt->fetch(PDO::FETCH_ASSOC);
39 $stmt->bindParam(1, $id);
40 $stmt->bindParam(2, $mybool, PDO::PARAM_BOOL);
43 $stmt->execute();
46 $stmt = $db->query('SELECT * FROM test');
47 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
50 $stmt->bindParam(1, $id);
52 $stmt->bindParam(2, $mybool, PDO::PARAM_INT);
53 $stmt->execute();
55 $stmt = $db->query('SELECT * FROM test');
[all …]
H A Dpdo_mysql_stmt_bindcolumn.phpt22 $stmt->execute();
25 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
27 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
31 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
34 while ($stmt->fetch(PDO::FETCH_BOUND)) {
43 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
62 $stmt->execute();
65 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
67 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
71 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
[all …]
/PHP-7.4/ext/pdo_dblib/tests/
H A Dtimeout.phpt16 $stmt = $db->prepare($sql);
17 if ($stmt->execute()) {
24 $stmt = $db->prepare($sql);
25 if (!$stmt->execute()) {
29 if ($stmt->errorCode() != '00000') {
37 $stmt = $db->prepare($sql);
38 if (!$stmt->execute()) {
49 $stmt = $db->prepare($sql);
50 if (!$stmt->execute()) {
61 $stmt = $db->prepare($sql);
[all …]
H A Dbug_67130.phpt12 $stmt = $db->query('SELECT 1; SELECT 2; SELECT 3;');
13 var_dump($stmt->fetch());
14 var_dump($stmt->fetch());
15 var_dump($stmt->nextRowset());
16 var_dump($stmt->nextRowset());
17 var_dump($stmt->fetch());
18 var_dump($stmt->nextRowset());
H A Dbatch_stmt_ins_exec.phpt25 $stmt = $db->query(
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());
41 var_dump($stmt->nextRowset());
44 var_dump($stmt->rowCount());
45 var_dump($stmt->nextRowset());
48 var_dump($stmt->rowCount());
[all …]
/PHP-7.4/ext/odbc/tests/
H A Dbug46050.phpt9 $stmt = odbc_prepare($conn, "SELECT 1");
10 var_dump(odbc_execute($stmt));
11 var_dump(odbc_fetch_array($stmt));
12 var_dump(odbc_next_result($stmt));
13 var_dump(odbc_execute($stmt));
14 var_dump(odbc_fetch_array($stmt));
/PHP-7.4/ext/pdo_firebird/
H A Dfirebird_statement.c33 #define RECORD_ERROR(stmt) _firebird_error(NULL, stmt, __FILE__, __LINE__) argument
58 RECORD_ERROR(stmt); in firebird_stmt_dtor()
171 RECORD_ERROR(stmt); in firebird_stmt_execute()
184 if (!stmt->executed) { in firebird_stmt_fetch()
189 stmt->row_count = 1; in firebird_stmt_fetch()
200 stmt->row_count++; in firebird_stmt_fetch()
275 RECORD_ERROR(stmt); in firebird_fetch_blob()
281 RECORD_ERROR(stmt); in firebird_fetch_blob()
338 RECORD_ERROR(stmt); in firebird_fetch_blob()
486 RECORD_ERROR(stmt); in firebird_bind_blob()
[all …]
/PHP-7.4/ext/sqlite3/tests/
H A Dbug77051.phpt11 $stmt = $db->prepare('SELECT :a, :b, ?;');
14 $stmt->bindParam(':a', $a, SQLITE3_INTEGER);
15 $stmt->bindValue(':b', 'php');
16 $stmt->bindValue(':b', 'PHP');
17 $stmt->bindValue(3, 424242);
20 var_dump($res = $stmt->execute());
29 var_dump($res = $stmt->execute());
36 $stmt->bindValue(':b', 'TEST');
37 $stmt->bindValue(3, '!!!');
40 var_dump($res = $stmt->execute());
/PHP-7.4/ext/oci8/tests/
H A Ddefine4.phpt22 $stmt = oci_parse($c, "select value, string from define4_tab");
26 var_dump(oci_define_by_name($stmt, "STRING", $string));
28 oci_execute($stmt);
32 while (oci_fetch($stmt)) {
33 var_dump(oci_result($stmt, 'VALUE'));
35 var_dump(oci_result($stmt, 'STRING'));
37 var_dump(oci_result($stmt, 'VALUE'));
38 var_dump(oci_result($stmt, 'STRING'));
42 var_dump(oci_free_statement($stmt));
44 var_dump(oci_result($stmt, 'STRING'));
H A Dbug36096.phpt11 $stmt = oci_parse($c, $sql);
13 if(oci_execute($stmt, OCI_COMMIT_ON_SUCCESS)){
14 var_dump(oci_fetch($stmt));
15 var_dump(oci_result($stmt, 1));
16 var_dump(oci_field_name($stmt, 1));
17 var_dump(oci_field_type($stmt, 1));
/PHP-7.4/ext/pdo/tests/
H A Dbug_44173.phpt22 $stmt = $db->query();
23 var_dump($stmt);
28 var_dump($stmt);
32 $stmt = $db->query("SELECT * FROM test", 'abc');
33 var_dump($stmt);
38 var_dump($stmt);
42 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
43 var_dump($stmt);
48 var_dump($stmt);
52 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
[all …]
H A Dpdo_026.phpt49 $stmt->setFetchMode(PDO::FETCH_ASSOC);
50 $stmt->execute();
51 return $stmt;
60 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
61 var_dump(get_class($stmt));
63 $stmt->execute($row);
66 unset($stmt);
68 $stmt = $db->query('SELECT * FROM test');
69 var_dump(get_class($stmt));
70 var_dump(get_class($stmt->dbh));
[all …]
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dlarge_objects.phpt26 $stmt->bindValue(1, 1);
31 $stmt->bindParam(2, $stm, PDO::PARAM_LOB);
32 $stmt->execute();
36 $stmt = $db->prepare("SELECT * from test");
38 $stmt->execute();
40 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
47 $stmt = $db->prepare("SELECT * from test");
48 $stmt->execute();
51 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
58 $stmt = $db->prepare("SELECT * from test");
[all …]
/PHP-7.4/ext/pdo/
H A Dphp_pdo_error.h24 PDO_API void pdo_handle_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt);
33 #define PDO_STMT_CLEAR_ERR() strcpy(stmt->error_code, PDO_ERR_NONE)
35 #define PDO_HANDLE_STMT_ERR() if (strcmp(stmt->error_code, PDO_ERR_NONE)) { pdo_handle_error(stmt…

Completed in 32 milliseconds

12345678910>>...19