Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-5.5/ext/pdo_mysql/tests/
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_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 …]
H A Dpdo_mysql_stmt_blobs.phpt32 $stmt->bindValue(1, 1);
33 $stmt->bindValue(2, $value);
34 if (!$stmt->execute()) {
36 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
40 $stmt = $db->query('SELECT id, label FROM test');
42 $stmt->bindColumn(1, $id, PDO::PARAM_INT);
43 $stmt->bindColumn(2, $label, PDO::PARAM_LOB);
45 if (!$stmt->fetch(PDO::FETCH_BOUND)) {
47 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
63 $stmt = $db->query('SELECT id, label FROM test');
[all …]
H A Dbug_44707.phpt13 $row = $stmt->fetch(PDO::FETCH_ASSOC);
39 $stmt->bindParam(1, $id);
42 $stmt->bindParam(2, $mybool, PDO::PARAM_BOOL);
45 $stmt->execute();
48 $stmt = $db->query('SELECT * FROM test');
49 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
52 $stmt->bindParam(1, $id);
54 $stmt->bindParam(2, $mybool, PDO::PARAM_INT);
55 $stmt->execute();
57 $stmt = $db->query('SELECT * FROM test');
[all …]
H A Dpdo_mysql_attr_multi_statements.phpt26 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table));
27 $stmt->closeCursor();
30 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
33 $stmt = $db->query('SELECT 1 AS value;');
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
39 var_dump($stmt);
43 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
44 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
46 $stmt = $db->query('SELECT 1 AS value;');
[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 …]
/PHP-5.5/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-5.5/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 …]
H A Dpdo_029.phpt55 $stmt->setFetchMode(PDO::FETCH_ASSOC);
56 $stmt->execute();
57 return $stmt;
66 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
67 var_dump(get_class($stmt));
69 $stmt->execute($row);
72 unset($stmt);
76 $stmt = $db->query('SELECT * FROM test');
77 var_dump(get_class($stmt));
78 var_dump(get_class($stmt->dbh));
[all …]
/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_stmt_bind_result.phpt28 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
33 mysqli_stmt_close($stmt);
44 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
62 mysqli_stmt_close($stmt);
90 mysqli_stmt_close($stmt);
101 mysqli_stmt_close($stmt);
107 mysqli_stmt_close($stmt);
144 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
149 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_get_warnings.phpt40 if (!$stmt = mysqli_stmt_init($link))
43 if (NULL !== ($tmp = mysqli_stmt_get_warnings($stmt)))
46 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt))
47 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 if (false !== ($tmp = mysqli_stmt_get_warnings($stmt)))
52 …if (!mysqli_stmt_prepare($stmt, "CREATE TABLE test(id SMALLINT, label CHAR(1))") || !mysqli_stmt_e…
53 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
55 if (false !== ($tmp = mysqli_stmt_get_warnings($stmt)))
59 !mysqli_stmt_execute($stmt))
60 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_execute_stored_proc_out.phpt33 if (!$stmt = mysqli_prepare($link, 'CALL p(?, ?)'))
38 if (!mysqli_stmt_bind_param($stmt, 'ss', $ver_in, $ver_out))
39 …intf("[006] Cannot bind parameter, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
41 if (!mysqli_stmt_execute($stmt))
42 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 if (!mysqli_stmt_bind_result($stmt, $ver_out) || !mysqli_stmt_fetch($stmt))
48 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
53 if (!mysqli_stmt_close($stmt))
54 …ntf("[012] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
H A Dmysqli_stmt_error.phpt24 if (!$stmt = mysqli_stmt_init($link))
28 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
35 if ('' === ($tmp = mysqli_stmt_error($stmt)))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
39 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt));
42 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
47 if (true === ($tmp = mysqli_stmt_execute($stmt)))
51 if ('' === ($tmp = mysqli_stmt_error($stmt)))
54 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_errno.phpt24 if (!$stmt = mysqli_stmt_init($link))
28 if (0 !== ($tmp = mysqli_stmt_errno($stmt)))
31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
35 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
39 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (0 != ($tmp = mysqli_stmt_errno($stmt)))
47 if (true === ($tmp = mysqli_stmt_execute($stmt)))
51 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
54 mysqli_stmt_close($stmt);
[all …]
H A D022.phpt21 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
22 mysqli_stmt_bind_param($stmt, "ss", $a1, $a2);
27 mysqli_stmt_execute($stmt);
28 mysqli_stmt_close($stmt);
30 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
31 mysqli_stmt_bind_result($stmt, $c1, $c2);
32 mysqli_stmt_execute($stmt);
33 mysqli_stmt_fetch($stmt);
40 mysqli_stmt_close($stmt);
H A Dbug48909.phpt20 if (!$stmt = $link->prepare("INSERT INTO test(id, label) VALUES (?, ?)"))
23 if (!$stmt->bind_param("bb",$bvar, $bvar))
24 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
26 if (!$stmt->execute()) {
27 if ($stmt->errno != 1366) {
32 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error);
36 $stmt->close();
H A D021.phpt20 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
21 mysqli_stmt_bind_param($stmt, "ss", $q1, $q2);
24 mysqli_stmt_execute($stmt);
25 mysqli_stmt_close($stmt);
27 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
28 mysqli_stmt_bind_result($stmt, $c1, $c2);
29 mysqli_stmt_execute($stmt);
30 mysqli_stmt_fetch($stmt);
36 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_get_result_geom.phpt40 if (!$stmt = mysqli_stmt_init($link)) {
46 printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 mysqli_stmt_close($stmt);
51 if (!mysqli_stmt_execute($stmt)) {
52 printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
53 mysqli_stmt_close($stmt);
57 printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
58 mysqli_stmt_close($stmt);
115 $offset + 18, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
117 mysqli_stmt_close($stmt);
[all …]
/PHP-5.5/ext/pdo/
H A Dphp_pdo_int.h42 void pdo_dbstmt_free_storage(pdo_stmt_t *stmt TSRMLS_DC);
45 int pdo_stmt_describe_columns(pdo_stmt_t *stmt TSRMLS_DC);
46 int pdo_stmt_setup_fetch_mode(INTERNAL_FUNCTION_PARAMETERS, pdo_stmt_t *stmt, int skip_first_arg);
51 void pdo_row_free_storage(pdo_stmt_t *stmt TSRMLS_DC);
58 extern void pdo_handle_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt TSRMLS_DC);
67 #define PDO_STMT_CLEAR_ERR() strcpy(stmt->error_code, PDO_ERR_NONE)
69 #define PDO_HANDLE_STMT_ERR() if (strcmp(stmt->error_code, PDO_ERR_NONE)) { pdo_handle_error(stmt->…
/PHP-5.5/ext/oci8/tests/
H A Dbug43497.phpt24 $row = oci_fetch($stmt);
25 return oci_result($stmt, 1);
39 $row = oci_fetch($stmt);
40 $val = oci_result($stmt, 1);
41 oci_free_statement($stmt);
54 if (oci_execute($stmt)) {
69 if (oci_execute($stmt)) {
83 if (oci_execute($stmt)) {
95 oci_execute($stmt);
101 oci_execute($stmt);
[all …]
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-5.5/ext/mysqlnd/
H A Dmysqlnd_driver.c200 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local
211 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD()
212 if (!stmt) { in MYSQLND_METHOD()
215 stmt->persistent = conn->persistent; in MYSQLND_METHOD()
216 stmt->error_info = &(stmt->error_info_impl); in MYSQLND_METHOD()
217 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD()
218 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD()
219 stmt->execute_cmd_buffer.length = 4096; in MYSQLND_METHOD()
220 stmt->execute_cmd_buffer.buffer = mnd_pemalloc(stmt->execute_cmd_buffer.length, stmt->persistent); in MYSQLND_METHOD()
221 if (!stmt->execute_cmd_buffer.buffer) { in MYSQLND_METHOD()
[all …]
/PHP-5.5/ext/pdo_oci/tests/
H A Dbug57702.phpt19 $stmt = $db->prepare($query);
20 $stmt->execute();
23 $stmt = $db->prepare($query);
24 $stmt->execute();
30 $stmt->bindParam(':id', $id);
35 $stmt->execute();
53 $stmt->execute();
54 $row = $stmt->fetch(PDO::FETCH_ASSOC);
76 $rs = $stmt->execute();
128 $stmt = $db->prepare($query);
[all …]

Completed in 41 milliseconds

12345678910>>...16