Home
last modified time | relevance | path

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

1...<<111213141516171819

/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug70313.phpt18 $stmt = $db->prepare(");");
20 $stmt->execute([1]);
27 $stmt = $db->prepare(");");
29 $stmt->execute([1]);
/PHP-7.4/ext/pdo_mysql/tests/
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_column.phpt20 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1");
21 $stmt->execute(array(':param' => 'id'));
22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
25 $stmt->execute(array(':placeholder' => 'test'));
27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dbug46292.phpt43 $stmt = $pdoDb->prepare("SELECT * FROM testz");
45 var_dump($stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE | PDO::FETCH_GROUP));
46 $stmt->execute();
48 var_dump($stmt->fetch());
49 var_dump($stmt->fetch());
50 var_dump($stmt->fetchAll());
H A Dpdo_mysql_stmt_fetch_serialize.phpt88 $stmt = $db->prepare('INSERT INTO test(id, myobj) VALUES (?, ?)');
89 $stmt->bindValue(1, $id);
90 $stmt->bindValue(2, $myobj);
91 $stmt->execute();
97 $stmt = $db->prepare('SELECT myobj FROM test');
99 $stmt->execute();
100 var_dump($stmt->fetch());
103 $stmt = $db->prepare('SELECT myobj FROM test');
104 $stmt->setFetchMode(PDO::FETCH_CLASS, 'myclass', array('PDO shall call __construct()'));
105 $stmt->execute();
[all …]
H A Dpdo_mysql_begintransaction.phpt39 $row = $stmt->fetch(PDO::FETCH_ASSOC);
57 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
67 $new_row1 = $stmt->fetch(PDO::FETCH_ASSOC);
76 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC);
98 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC);
106 if (!($stmt = $db->query('SELECT @@autocommit as auto_commit')))
109 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
112 $tmp['auto_commit'], $stmt->errorCode(), $stmt->errorInfo());
120 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
123 $tmp['auto_commit'], $stmt->errorCode(), trim(implode(' ', $stmt->errorInfo())));
[all …]
H A Dpdo_mysql_stmt_fetch_serialize_simple.phpt48 $stmt = $db->prepare('SELECT myobj FROM test');
49 $stmt->execute();
50 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO'));
53 $stmt->execute();
54 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass');
58 $stmt = $db->prepare('SELECT myobj FROM test');
59 $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO'));
60 $stmt->execute();
61 var_dump($stmt->fetch());
H A Dpdo_mysql_stmt_nextrowset.phpt32 $stmt = $db->query('SELECT id FROM test');
33 if (false !== ($tmp = $stmt->nextRowSet()))
37 if (false !== ($tmp = $stmt->nextRowSet(1)))
43 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
45 while ($stmt->fetch()) ;
51 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
52 var_dump($stmt->nextRowSet());
60 $stmt = $db->query('CALL p()');
62 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
63 } while ($stmt->nextRowSet());
[all …]
/PHP-7.4/ext/pdo/tests/
H A Dpdo_007.phpt22 $stmt = $db->prepare('SELECT id, val from test');
24 $stmt->execute();
25 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE));
27 $stmt->execute();
28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE));
H A Dpdo_031.phpt26 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
28 $stmt->execute($row);
31 unset($stmt);
35 $stmt = $db->query('SELECT * FROM test');
37 foreach(new RecursiveTreeIterator(new RecursiveArrayIterator($stmt->fetchAll(PDO::FETCH_ASSOC)), Re…
/PHP-7.4/ext/mysqli/
H A Dmysqli_priv.h65 extern void php_clear_stmt_bind(MY_STMT *stmt);
137 #define MYSQLI_REPORT_STMT_ERROR(stmt) \ argument
138 if ((MyG(report_mode) & MYSQLI_REPORT_ERROR) && mysql_stmt_errno(stmt)) { \
139 …php_mysqli_report_error(mysql_stmt_sqlstate(stmt), mysql_stmt_errno(stmt), mysql_stmt_error(stmt))…
/PHP-7.4/ext/oci8/tests/
H A Dselect_null.phpt12 $stmt = oci_parse($pc, "select NULL from dual");
13 oci_execute($stmt);
14 var_dump(oci_fetch_array($stmt, OCI_RETURN_NULLS));
H A Dbug37581.phpt33 $stmt = oci_parse($c,'begin bug37581_pkg.array_bind(:in_arr, :out_str); end;');
36 oci_bind_array_by_name($stmt,':in_arr',$strings,5,1,SQLT_AFC);
37 oci_bind_by_name($stmt,':out_str',$result,10);
39 oci_execute($stmt);
42 oci_execute($stmt);
/PHP-7.4/ext/pdo_dblib/tests/
H A Dbug_71667.phpt12 $stmt = $db->prepare("SELECT 1, 2 AS named, 3");
13 $stmt->execute();
14 var_dump($stmt->fetchAll());
H A Dbug_68957.phpt13 $stmt = $db->query($query);
14 $stmt->nextRowset(); // Added line
15 $rows = $stmt->fetchAll();
H A Dstringify_uniqueidentifier.phpt31 $stmt = $db->query($sql);
32 $row = $stmt->fetch(PDO::FETCH_ASSOC);
41 $stmt = $db->query($sql);
42 $row = $stmt->fetch(PDO::FETCH_ASSOC);
55 $stmt = $db->query($sql);
56 $row = $stmt->fetch(PDO::FETCH_ASSOC);
/PHP-7.4/ext/mysqli/tests/
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 Dbug35517.phpt16 $stmt = $mysql->prepare("SELECT id FROM temp");
17 $stmt->execute();
18 $stmt->bind_result($id);
19 while ($stmt->fetch()) {
31 $stmt->close();
H A Dmysqli_stmt_prepare.phpt30 if (!$stmt = mysqli_stmt_init($link))
33 if (NULL !== ($tmp = @mysqli_stmt_prepare($stmt)))
36 if (false !== ($tmp = mysqli_stmt_prepare($stmt, '')))
39 if (true !== ($tmp = mysqli_stmt_prepare($stmt, 'SELECT id FROM test')))
42 mysqli_stmt_close($stmt);
44 if (false !== ($tmp = mysqli_stmt_prepare($stmt, "SELECT id FROM test")))
H A Dmysqli_stmt_attr_get.phpt41 $stmt = mysqli_stmt_init($link);
42 mysqli_stmt_prepare($stmt, 'SELECT * FROM test');
43 if (false !== ($tmp = @mysqli_stmt_attr_get($stmt, $invalid_attr)))
47 if (false === ($tmp = mysqli_stmt_attr_get($stmt, $attr))) {
53 $stmt->close();
56 if (false !== ($tmp = @mysqli_stmt_attr_get($stmt, $attr))) {
/PHP-7.4/ext/sqlite3/tests/
H A Dbug76665.phpt11 $stmt = $db->prepare("INSERT INTO foo VALUES (:bar)");
12 $stmt->bindValue(':bar', 17, SQLITE3_FLOAT);
13 $stmt->execute();
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dbug79664.phpt12 $stmt = $pdo->query('select 1 where 0');
13 if ($stmt->columnCount()) {
14 var_dump($stmt->getColumnMeta(0));
/PHP-7.4/ext/pdo_odbc/tests/
H A Dbug80783.phpt18 $stmt = $db->prepare("SELECT name FROM bug80783");
19 $stmt->bindColumn(1, $data, PDO::PARAM_LOB);
20 $stmt->execute();
21 $stmt->fetch(PDO::FETCH_BOUND);
/PHP-7.4/ext/pdo_odbc/
H A Dphp_pdo_odbc_int.h146 PDO_ODBC_HSTMT stmt; member
169 void pdo_odbc_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, PDO_ODBC_HSTMT statement, char *what, const c…
171 #define pdo_odbc_stmt_error(what) pdo_odbc_error(stmt->dbh, stmt, SQL_NULL_HSTMT, what, __FILE__, _…
172 #define pdo_odbc_doer_error(what) pdo_odbc_error(dbh, NULL, stmt, what, __FILE__, __LINE__)
/PHP-7.4/ext/pdo_oci/
H A Doci_driver.c41 if (stmt) { in pdo_oci_fetch_error_func()
67 if (stmt) { in _oci_error()
68 S = (pdo_oci_stmt*)stmt->driver_data; in _oci_error()
70 pdo_err = &stmt->error_code; in _oci_error()
168 if (stmt) { in _oci_error()
306 stmt->driver_data = S; in oci_handle_preparer()
307 stmt->methods = &oci_stmt_methods; in oci_handle_preparer()
320 OCIStmt *stmt; in oci_handle_doer() local
330 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer()
338 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer()
[all …]

Completed in 42 milliseconds

1...<<111213141516171819