Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-5.5/ext/mysqli/tests/
H A D057.phpt23 mysqli_stmt_execute($stmt);
30 mysqli_stmt_close($stmt);
34 var_dump(mysqli_stmt_execute($stmt));
35 var_dump(mysqli_stmt_reset($stmt));
38 if ($stmt->affected_rows !== 0)
41 var_dump(mysqli_stmt_execute($stmt));
43 var_dump(mysqli_stmt_reset($stmt));
46 mysqli_stmt_execute($stmt);
47 $result1 = mysqli_stmt_result_metadata($stmt);
48 mysqli_stmt_store_result($stmt);
[all …]
H A Dmysqli_stmt_send_long_data_packet_size_libmysql.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));
60 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
63 if (true !== mysqli_stmt_execute($stmt))
64 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
80 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
85 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_get_client_stats_ps.phpt25 if (!$stmt = mysqli_stmt_init($link))
30 !mysqli_stmt_execute($stmt) ||
31 !mysqli_stmt_store_result($stmt) ||
33 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 while (mysqli_stmt_fetch($stmt))
39 mysqli_stmt_free_result($stmt);
61 !mysqli_stmt_execute($stmt) ||
63 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 while (mysqli_stmt_fetch($stmt))
81 mysqli_stmt_free_result($stmt);
[all …]
H A Dmysqli_stmt_store_result.phpt27 if (!$stmt = mysqli_stmt_init($link))
30 // stmt object status test
31 if (NULL !== ($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 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);
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_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 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));
149 mysqli_stmt_free_result($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 Dmysqli_stmt_param_count.phpt24 if (!$stmt = mysqli_stmt_init($link))
27 if (NULL !== ($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 …]
/PHP-5.5/ext/pdo_pgsql/
H A Dpgsql_statement.c114 stmt->driver_data = NULL; in pgsql_stmt_dtor()
169 stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, in pgsql_stmt_execute()
204 stmt->bound_params ? in pgsql_stmt_execute()
223 if (!stmt->executed && (!stmt->column_count || S->cols == NULL)) { in pgsql_stmt_execute()
260 if (stmt->bound_param_map && SUCCESS == zend_hash_find(stmt->bound_param_map, in pgsql_stmt_param_hook()
264 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", param->name TSRMLS_CC); in pgsql_stmt_param_hook()
279 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook()
298 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined" TSRMLS_CC); in pgsql_stmt_param_hook()
422 if (S->current_row < stmt->row_count) { in pgsql_stmt_fetch()
455 if (stmt->bound_columns && ( in pgsql_stmt_describe()
[all …]
/PHP-5.5/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_variable_columncount.phpt65 $stmt->execute();
79 $stmt->execute();
92 $stmt->execute();
93 check_result(11, $stmt, 1);
94 $stmt->execute();
95 check_result(12, $stmt, 2);
97 $stmt->execute();
98 check_result(13, $stmt, 1);
108 $stmt->execute();
110 $stmt->execute();
[all …]
H A Dpdo_mysql_prepare_native_clear_error.phpt30 if ('00000' !== $stmt->errorCode())
32 var_export($stmt->errorCode(), true),
33 var_export($stmt->errorInfo(), true));
37 if ('00000' !== $stmt->errorCode())
39 var_export($stmt->errorCode(), true),
40 var_export($stmt->errorInfo(), true));
50 if ('00000' !== $stmt->errorCode())
52 var_export($stmt->errorCode(), true),
53 var_export($stmt->errorInfo(), true));
57 if ('00000' !== $stmt->errorCode())
[all …]
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_stmt_bindparam.phpt23 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
25 $stmt->execute();
30 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
34 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
43 $stmt->execute();
56 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
58 if (!$stmt->execute())
60 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
64 $stmt->execute();
69 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
[all …]
H A Dpdo_mysql_stmt_unbuffered_2050.phpt28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
48 $stmt = PDO::query(<some query>)
52 $stmt->fetchAll()
56 $stmt = PDO::query(<some query>)
63 $stmt = PDO::query(<some query>)
68 current value of stmt:
78 PDO to $stmt.
91 $stmt->execute();
95 $stmt->execute();
98 unset($stmt);
[all …]
/PHP-5.5/ext/oci8/tests/
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 …]
H A Dbind_empty.phpt22 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name");
23 oci_bind_by_name($stmt, ":name", $name);
25 var_dump(oci_execute($stmt));
31 oci_bind_by_name($stmt, ":name", $name);
33 var_dump(oci_execute($stmt));
38 $res = oci_execute($stmt);
41 $res = oci_execute($stmt);
45 oci_bind_by_name($stmt, ":name", $name);
47 var_dump(oci_execute($stmt));
58 oci_bind_by_name($stmt, ":name", $name);
[all …]
/PHP-5.5/ext/pdo_firebird/
H A Dfirebird_statement.c58 RECORD_ERROR(stmt); in firebird_stmt_dtor()
148 RECORD_ERROR(stmt); in firebird_stmt_execute()
161 if (!stmt->executed) { in firebird_stmt_fetch()
167 RECORD_ERROR(stmt); in firebird_stmt_fetch()
175 stmt->row_count++; in firebird_stmt_fetch()
233 RECORD_ERROR(stmt); in firebird_fetch_blob()
239 RECORD_ERROR(stmt); in firebird_fetch_blob()
291 RECORD_ERROR(stmt); in firebird_fetch_blob()
421 RECORD_ERROR(stmt); in firebird_bind_blob()
444 RECORD_ERROR(stmt); in firebird_bind_blob()
[all …]
/PHP-5.5/ext/pdo_firebird/tests/
H A Dbug_47415.phpt21 $stmt = $dbh->prepare($query);
22 $stmt->bindColumn('idx', $idx);
23 $stmt->bindColumn('txt', $txt);
24 $stmt->execute();
25 $rows = $stmt->fetch(PDO::FETCH_BOUND);
26 var_dump($stmt->fetch());
27 var_dump($stmt->rowCount());
30 $stmt = $dbh->prepare('DELETE FROM testz');
31 $stmt->execute();
37 unset($stmt);
H A Dbug_48877.phpt22 $stmt = $dbh->prepare($query);
23 $stmt->bindParam(':paramno', $value, PDO::PARAM_STR);
24 $stmt->execute();
25 $rows = $stmt->fetch();
26 var_dump($stmt->fetch());
27 var_dump($stmt->rowCount());
30 $stmt = $dbh->prepare('DELETE FROM testz');
31 $stmt->execute();
37 unset($stmt);
/PHP-5.5/ext/pdo_sqlite/tests/
H A Dbug33841.phpt14 $stmt = $db->prepare("INSERT INTO test VALUES ( :text )");
15 $stmt->bindParam(':text', $name);
17 var_dump($stmt->execute(), $stmt->rowCount());
19 $stmt = $db->prepare("UPDATE test SET text = :text ");
20 $stmt->bindParam(':text', $name);
22 var_dump($stmt->execute(), $stmt->rowCount());
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-5.5/ext/pdo/
H A Dpdo_sql_parser.c497 if (stmt->supports_placeholders == query_type && !stmt->named_rewrite_template) { in pdo_parse_params()
512 params = stmt->bound_params; in pdo_parse_params()
516 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "no parameters were bound" TSRMLS_CC); in pdo_parse_params()
556 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined" TSRMLS_CC); in pdo_parse_params()
569 if (!stmt->dbh->methods->quoter(stmt->dbh, buf, len, &plc->quoted, &plc->qlen, in pdo_parse_params()
573 strncpy(stmt->error_code, stmt->dbh->error_code, 6); in pdo_parse_params()
611 if (!stmt->dbh->methods->quoter(stmt->dbh, Z_STRVAL(tmp_param), in pdo_parse_params()
616 strncpy(stmt->error_code, stmt->dbh->error_code, 6); in pdo_parse_params()
666 const char *tmpl = stmt->named_rewrite_template ? stmt->named_rewrite_template : ":pdo%d"; in pdo_parse_params()
811 if(stmt->dbh->methods->quoter(stmt->dbh, Z_STRVAL_P(param->parameter),
[all …]
/PHP-5.5/ext/pdo_oci/
H A Doci_statement.c64 if (S->stmt) { in oci_stmt_dtor()
71 S->stmt = NULL; in oci_stmt_dtor()
82 stmt->bound_columns = NULL; in oci_stmt_dtor()
88 stmt->bound_params = NULL; in oci_stmt_dtor()
114 stmt->driver_data = NULL; in oci_stmt_dtor()
130 if (stmt->executed) { in oci_stmt_execute()
140 if (stmt->dbh->auto_commit && !stmt->dbh->in_txn) { in oci_stmt_execute()
150 if (!stmt->executed) { in oci_stmt_execute()
608 pdo_stmt_t *stmt; member
659 pdo_stmt_t *stmt = self->stmt; in oci_blob_close() local
[all …]

Completed in 62 milliseconds

12345678910>>...16