Home
last modified time | relevance | path

Searched refs:stmt (Results 176 – 200 of 392) sorted by relevance

12345678910>>...16

/PHP-5.5/ext/pdo_pgsql/tests/
H A Dbug43925.phpt31 $stmt = $dbh->prepare('
41 $stmt->bindValue('left', 1, PDO::PARAM_INT);
42 $stmt->bindValue('rootId', 3, PDO::PARAM_INT);
43 $stmt->bindValue('x', 5, PDO::PARAM_INT);
44 $stmt->bindValue('y', 50, PDO::PARAM_INT);
46 $stmt->execute();
48 foreach ($stmt->fetchAll() as $row) {
/PHP-5.5/ext/pdo_mysql/tests/
H A Dpdo_mysql_types_zerofill.phpt24 $stmt->bindValue(1, $offset);
25 $stmt->bindValue(2, $value);
27 if (!$stmt->execute()) {
38 $stmt = $db->query('SELECT id, label FROM test');
39 $row = $stmt->fetch(PDO::FETCH_ASSOC);
40 $stmt->closeCursor();
78 $stmt = $db->query('SELECT id, label FROM test');
79 $row_string = $stmt->fetch(PDO::FETCH_ASSOC);
80 $stmt->closeCursor();
95 $stmt->execute();
[all …]
H A Dpdo_mysql_errorinfo.phpt48 $stmt = $db->query('SELECT id, label FROM test');
49 $stmt2 = &$stmt;
51 check_error($offset + 4, $stmt);
54 @$stmt->execute();
56 check_error($offset + 6, $stmt, '42S02');
59 @$stmt = $db->query('SELECT id, label FROM unknown');
63 $stmt = $db->query('SELECT id, label FROM test');
65 check_error($offset + 10, $stmt);
72 check_error($offset + 13, $stmt);
80 check_error($offset + 17, $stmt);
H A Dpdo_mysql_stmt_fetch_non_select.phpt27 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
39 if (!is_object($stmt = $db->query('SHOW ENGINES')))
44 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
61 while ($row = $stmt->fetch(PDO::FETCH_ASSOC))
85 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
119 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
151 while ($row = $stmt->fetch(PDO::FETCH_ASSOC))
164 $stmt->execute();
172 $stmt->execute();
173 $stmt->execute();
[all …]
H A Dpdo_mysql_prepare_native_mixed_style.phpt20 $stmt = $db->query('DELETE FROM test');
21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)');
22 $stmt->execute(array('a', 'b'));
23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label…
24 $stmt->execute(array(1, 1));
25 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_mysql_fetch_both.phpt18 $stmt = $db->query('SELECT 1');
19 $num = $stmt->fetch(PDO::FETCH_NUM);
21 $stmt = $db->query('SELECT 1');
22 $assoc = $stmt->fetch(PDO::FETCH_ASSOC);
24 $stmt = $db->query('SELECT 1');
25 $both = $stmt->fetch(PDO::FETCH_BOTH);
/PHP-5.5/ext/mysqli/tests/
H A Dbug34785.phpt30 $stmt = new my_stmt($link, "SELECT 'foo' FROM DUAL");
32 $stmt->execute();
33 $stmt->bind_result($var);
34 $stmt->fetch();
36 $stmt->close();
H A Dbug44897.phpt33 if (!$stmt = $link->prepare('CALL p(?, ?)'))
36 if (!$stmt->bind_param('is', $new_id, $new_label) || !$stmt->execute())
37 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
40 if (!$stmt->bind_result($out_new_label) || !$stmt->fetch())
41 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error);
47 $stmt->close();
H A Dmysqli_stmt_get_result_bit.phpt54 if (!$stmt = mysqli_stmt_init($link))
84 if (!mysqli_stmt_prepare($stmt, $sql) ||
85 !mysqli_stmt_execute($stmt))
86 printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
89 if (!mysqli_stmt_prepare($stmt, $sql) ||
90 !mysqli_stmt_execute($stmt))
91 printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 if (!$res = mysqli_stmt_get_result($stmt))
94 printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
121 mysqli_stmt_close($stmt);
H A D018.phpt18 if (!$stmt = mysqli_prepare($link, "SELECT @@autocommit"))
21 mysqli_stmt_bind_result($stmt, $c0);
22 mysqli_stmt_execute($stmt);
24 mysqli_stmt_fetch($stmt);
H A Dmysqli_stmt_attr_get_prefetch.phpt14 $stmt = mysqli_stmt_init($link);
15 mysqli_stmt_prepare($stmt, 'SELECT * FROM test');
16 if (1 !== ($tmp = mysqli_stmt_attr_get($stmt, MYSQLI_STMT_ATTR_PREFETCH_ROWS))) {
20 $stmt->close();
H A Dmysqli_report.phpt76 $stmt = mysqli_stmt_init($link);
84 mysqli_stmt_close($stmt);
95 mysqli_stmt_execute($stmt);
96 mysqli_stmt_close($stmt);
118 mysqli_stmt_close($stmt);
128 mysqli_stmt_execute($stmt);
129 mysqli_stmt_close($stmt);
247 printf("[026] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
250 printf("[027] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
252 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_get_result_seek.phpt16 if (!$stmt = mysqli_stmt_init($link))
19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3"))
20 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
22 if (!mysqli_stmt_execute($stmt))
23 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
25 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
27 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 $i, mysqli_stmt_errno($stmt), $stmt->error);
90 mysqli_stmt_close($stmt);
H A D009.phpt41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8);
43 mysqli_stmt_execute($stmt);
44 $rc = mysqli_stmt_fetch($stmt);
57 mysqli_stmt_close($stmt);
68 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch_uint");
69 mysqli_stmt_bind_result($stmt, $c1, $c2);
70 mysqli_stmt_execute($stmt);
71 $rc = mysqli_stmt_fetch($stmt);
75 mysqli_stmt_close($stmt);
H A D005.phpt25 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
26 mysqli_stmt_bind_result($stmt, $c1, $c2);
27 mysqli_stmt_execute($stmt);
28 mysqli_stmt_fetch($stmt);
36 mysqli_stmt_fetch($stmt);
38 mysqli_stmt_close($stmt);
H A Dbug45019.phpt27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
31 if (!$stmt->bind_result($column1) || !$stmt->execute())
32 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
35 while ($stmt->fetch()) {
48 $stmt->close();
/PHP-5.5/ext/pdo_dblib/tests/
H A Dbug_45876.phpt12 $stmt = $db->prepare("select ic1.* from information_schema.columns ic1");
13 $stmt->execute();
14 var_dump($stmt->getColumnMeta(0));
15 $stmt = null;
H A Dbug_50755.phpt13 $stmt = $db->prepare("select *
18 $x = $stmt->execute();
20 while (($r = $stmt->fetch())) {
23 $stmt = null;
/PHP-5.5/ext/sqlite3/tests/
H A Dsqlite3_35_stmt_readonly.phpt24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
25 var_dump($stmt->readOnly());
28 $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?");
29 var_dump($stmt->readOnly());
32 $stmt = $db->prepare("DELETE FROM test");
33 var_dump($stmt->readOnly());
/PHP-5.5/ext/pdo_oci/tests/
H A Dbug46274_2.phpt27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl…
35 $stmt->bindparam(':id', $id);
36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
37 $stmt->execute();
45 $stmt->bindparam(':id', $id);
46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
47 $stmt->execute();
/PHP-5.5/ext/pdo/tests/
H A Dpdo_030.phpt64 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
65 var_dump(get_class($stmt));
67 $stmt->execute($row);
70 unset($stmt);
77 $stmt = $db->query('SELECT * FROM test');
78 var_dump(get_class($stmt));
79 var_dump(get_class($stmt->dbh));
83 foreach($stmt as $obj) {
H A Dpdo_023.phpt53 $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx')));
54 $stmt->execute();
55 return $stmt;
68 $stmt = $db->query('SELECT val, id FROM test');
69 var_dump($stmt);
70 var_dump($stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE));
72 $stmt = NULL;
/PHP-5.5/ext/pdo_oci/
H A Doci_driver.c43 if (stmt) { in pdo_oci_fetch_error_func()
69 if (stmt) { in _oci_error()
70 S = (pdo_oci_stmt*)stmt->driver_data; in _oci_error()
72 pdo_err = &stmt->error_code; in _oci_error()
176 if (stmt) { in _oci_error()
316 stmt->driver_data = S; in oci_handle_preparer()
317 stmt->methods = &oci_stmt_methods; in oci_handle_preparer()
330 OCIStmt *stmt; in oci_handle_doer() local
340 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer()
348 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer()
[all …]
/PHP-5.5/ext/pdo_sqlite/
H A Dphp_pdo_sqlite_int.h66 sqlite3_stmt *stmt; member
73 extern int _pdo_sqlite_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, const char *file, int line TSRMLS_DC…
75 #define pdo_sqlite_error_stmt(s) _pdo_sqlite_error(stmt->dbh, stmt, __FILE__, __LINE__ TSRMLS_CC)
/PHP-5.5/ext/mysqli/
H A Dmysqli_prop.c354 ZVAL_LONG(*retval, mysqli_stmt_get_id(p->stmt)); in MYSQLI_MAP_PROPERTY_FUNC_LONG()
374 rc = mysql_stmt_affected_rows(p->stmt); in stmt_affected_rows_read()
396 MY_STMT * stmt; in stmt_error_list_read() local
403 if (stmt && stmt->stmt) { in stmt_error_list_read()
405 if (stmt->stmt->data && stmt->stmt->data->error_info->error_list) { in stmt_error_list_read()
408 …for (message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_first_ex(stmt->stmt->data->error_info… in stmt_error_list_read()
410 …message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_next_ex(stmt->stmt->data->error_info->erro… in stmt_error_list_read()
422 if (mysql_stmt_errno(stmt->stmt)) { in stmt_error_list_read()
426 add_assoc_long_ex(single_error, "errno", sizeof("errno"), mysql_stmt_errno(stmt->stmt)); in stmt_error_list_read()
427 …add_assoc_string_ex(single_error, "sqlstate", sizeof("sqlstate"), mysql_stmt_sqlstate(stmt->stmt),… in stmt_error_list_read()
[all …]

Completed in 43 milliseconds

12345678910>>...16