Home
last modified time | relevance | path

Searched refs:stmt (Results 251 – 275 of 434) sorted by relevance

1...<<1112131415161718

/php-src/ext/pdo/tests/
H A Dpdo_007.phpt23 $stmt = $db->prepare('SELECT id, val from test007');
25 $stmt->execute();
26 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE));
28 $stmt->execute();
29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE));
H A Dpdo_031.phpt27 $stmt = $db->prepare("INSERT INTO test031 VALUES(?, ?, ?)");
29 $stmt->execute($row);
32 unset($stmt);
36 $stmt = $db->query('SELECT * FROM test031');
38 foreach(new RecursiveTreeIterator(new RecursiveArrayIterator($stmt->fetchAll(PDO::FETCH_ASSOC)), Re…
H A Dbug_72368.phpt24 $stmt = $db->prepare($sql);
25 var_dump($stmt->execute($params));
33 $stmt = $db->prepare($sql);
34 var_dump($stmt->execute($params));
/php-src/ext/pdo_odbc/tests/
H A Dbug80783.phpt19 $stmt = $db->prepare("SELECT name FROM bug80783");
20 $stmt->bindColumn(1, $data, PDO::PARAM_LOB);
21 $stmt->execute();
22 $stmt->fetch(PDO::FETCH_BOUND);
/php-src/ext/sqlite3/tests/
H A Dbug76665.phpt9 $stmt = $db->prepare("INSERT INTO foo VALUES (:bar)");
10 $stmt->bindValue(':bar', 17, SQLITE3_FLOAT);
11 $stmt->execute();
H A Dbug71049.phpt12 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
14 $stmt->bindParam(1, $foo, SQLITE3_BLOB);
15 $results = $stmt->execute();
/php-src/ext/pdo_dblib/tests/
H A Dbug_71667.phpt16 $stmt = $db->prepare("SELECT 1, 2 AS named, 3");
17 $stmt->execute();
18 var_dump($stmt->fetchAll());
H A Dbug_68957.phpt17 $stmt = $db->query($query);
18 $stmt->nextRowset(); // Added line
19 $rows = $stmt->fetchAll();
H A Dstringify_uniqueidentifier.phpt34 $stmt = $db->query($sql);
35 $row = $stmt->fetch(PDO::FETCH_ASSOC);
44 $stmt = $db->query($sql);
45 $row = $stmt->fetch(PDO::FETCH_ASSOC);
58 $stmt = $db->query($sql);
59 $row = $stmt->fetch(PDO::FETCH_ASSOC);
/php-src/ext/pdo_sqlite/tests/
H A Dbug79664.phpt10 $stmt = $pdo->query('select 1 where 0');
11 if ($stmt->columnCount()) {
12 var_dump($stmt->getColumnMeta(0));
/php-src/ext/sqlite3/
H A Dsqlite3.c556 zval stmt; in PHP_METHOD() local
591 zval_ptr_dtor(&stmt); in PHP_METHOD()
677 sqlite3_stmt *stmt; in PHP_METHOD() local
707 return_code = sqlite3_step(stmt); in PHP_METHOD()
740 sqlite3_finalize(stmt); in PHP_METHOD()
1645 hash = stmt->bound_params; in register_bound_parameter_to_sqlite()
1650 stmt->bound_params = hash; in register_bound_parameter_to_sqlite()
1665 param->param_number = sqlite3_bind_parameter_index(stmt->stmt, ZSTR_VAL(param->name)); in register_bound_parameter_to_sqlite()
1778 sqlite3_reset(stmt_obj->stmt); in PHP_METHOD()
1793 sqlite3_reset(stmt_obj->stmt); in PHP_METHOD()
[all …]
/php-src/ext/mysqli/tests/
H A Dbug35517.phpt17 $stmt = $mysql->prepare("SELECT id FROM temp");
18 $stmt->execute();
19 $stmt->bind_result($id);
20 while ($stmt->fetch()) {
32 $stmt->close();
H A Dbug69899.phpt2 Bug #69899: Segfault on stmt close after free_result with mysqlnd.
23 $stmt = $mysqli->prepare('SELECT 1');
27 $stmt->free_result(),
28 $stmt->close()
H A Dmysqli_stmt_result_metadata.phpt13 if (!$stmt = mysqli_stmt_init($link))
17 mysqli_stmt_result_metadata($stmt);
22 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test"))
23 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
25 if (!is_object(($res = mysqli_stmt_result_metadata($stmt))))
75 mysqli_stmt_close($stmt);
78 mysqli_stmt_result_metadata($stmt);
H A Dmysqli_fetch_array_large.phpt58 if (!$stmt = mysqli_prepare($link, "SELECT id, label FROM test")) {
64 if (!mysqli_stmt_execute($stmt)) {
65 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq…
70 if (!mysqli_stmt_bind_result($stmt, $id, $label)) {
71 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq…
75 while (mysqli_stmt_fetch($stmt)) {
78 … $offset, $random_char, $label, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 mysqli_stmt_free_result($stmt);
84 mysqli_stmt_close($stmt);
H A Dbug32405.phpt23 if ($stmt = $link->prepare("SELECT SQL_NO_CACHE user_id, login FROM test_users")) {
24 $stmt->execute();
25 $stmt->bind_result($col1, $col2);
26 while ($stmt->fetch()) {
29 $stmt->close();
/php-src/ext/mysqli/tests/bind_fetch/
H A Dvaried_data_types.phpt33 $stmt = mysqli_prepare($link, "SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, …
34 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11, $c12);
35 mysqli_stmt_execute($stmt);
37 mysqli_stmt_fetch($stmt);
43 mysqli_stmt_close($stmt);
/php-src/ext/pdo_odbc/
H A Dphp_pdo_odbc_int.h140 PDO_ODBC_HSTMT stmt; member
163 void pdo_odbc_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, PDO_ODBC_HSTMT statement, char *what, const c…
165 #define pdo_odbc_stmt_error(what) pdo_odbc_error(stmt->dbh, stmt, SQL_NULL_HSTMT, what, __FILE__, _…
166 #define pdo_odbc_doer_error(what) pdo_odbc_error(dbh, NULL, stmt, what, __FILE__, __LINE__)
/php-src/ext/pdo_mysql/tests/
H A Dbug53551.phpt25 $stmt = $db->prepare($sql);
32 $stmt->execute($values);
33 var_dump($stmt->errorInfo());
36 $stmt->execute($values);
37 var_dump($stmt->errorInfo());
H A Dpdo_mysql_begintransaction.phpt41 $row = $stmt->fetch(PDO::FETCH_ASSOC);
59 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
69 $new_row1 = $stmt->fetch(PDO::FETCH_ASSOC);
78 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC);
100 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC);
108 if (!($stmt = $db->query('SELECT @@autocommit as auto_commit')))
111 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
114 $tmp['auto_commit'], $stmt->errorCode(), $stmt->errorInfo());
122 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
125 $tmp['auto_commit'], $stmt->errorCode(), trim(implode(' ', $stmt->errorInfo())));
[all …]
H A Dbug_39483.phpt16 $stmt = $db->prepare('SELECT UPPER(\'\0:D\0\'),?');
17 $stmt->execute([1]);
18 var_dump($stmt->fetchAll(PDO::FETCH_NUM));
H A Dbug_44454.phpt21 $stmt = $db->query('SELECT a, b FROM test_44454');
22 printf("... SELECT has returned %d row...\n", $stmt->rowCount());
23 while ($row = $stmt->fetch()) {
28 printf("... STMT - %s\n", var_export($stmt->errorCode(), true));
41 $stmt = $db->query('SELECT a, b FROM test_44454');
42 printf("... SELECT has returned %d row...\n", $stmt->rowCount());
43 foreach ($stmt as $row) {
48 printf("... STMT - %s\n", var_export($stmt->errorCode(), true));
H A Dpdo_mysql_stmt_errorcode.phpt23 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'…
24 $stmt->execute();
25 var_dump($stmt->errorCode());
39 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'…
40 $stmt->execute();
41 var_dump($stmt->errorCode());
/php-src/ext/pdo_pgsql/tests/
H A Dbug70313.phpt20 $stmt = $db->prepare(");");
22 $stmt->execute([1]);
29 $stmt = $db->prepare(");");
31 $stmt->execute([1]);
/php-src/ext/pdo/
H A Dpdo_dbh.c83 if (stmt) { in pdo_raise_impl_error()
141 if (stmt) { in pdo_handle_error()
550 pdo_stmt_t *stmt; in PHP_METHOD() local
619 stmt->dbh = dbh; in PHP_METHOD()
1152 pdo_stmt_t *stmt; in PHP_METHOD() local
1182 stmt->active_query_string = zend_string_copy(stmt->query_string); in PHP_METHOD()
1184 stmt->dbh = dbh; in PHP_METHOD()
1195 if (stmt->methods->executer(stmt)) { in PHP_METHOD()
1197 if (!stmt->executed) { in PHP_METHOD()
1201 stmt->executed = 1; in PHP_METHOD()
[all …]

Completed in 42 milliseconds

1...<<1112131415161718