Home
last modified time | relevance | path

Searched refs:stmt (Results 376 – 400 of 467) sorted by relevance

1...<<111213141516171819

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_case.phpt29 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label FROM test ORDER BY id ASC LI…
33 var_dump($stmt->fetchAll(PDO::FETCH_BOTH));
51 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label, MiXeD, MYUPPER FROM test OR…
55 var_dump($stmt->fetchAll(PDO::FETCH_BOTH));
65 …if (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, MYUPPER AS 'lower' FROM test …
69 var_dump($stmt->fetchAll(PDO::FETCH_BOTH));
79 …if (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, id AS 'ID' FROM test ORDER BY…
83 var_dump($stmt->fetchAll(PDO::FETCH_BOTH));
H A Dbug_61411.phpt37 $stmt = $db->prepare("SELECT 1");
38 $stmt->execute();
40 foreach ($stmt as $line) {
H A Dpdo_mysql_last_insert_id.phpt32 $stmt = $db->query('SELECT id FROM test LIMIT 1');
62 $stmt = $db->query('SELECT LAST_INSERT_ID() as _last_id');
63 $row = $stmt->fetch(PDO::FETCH_ASSOC);
83 $stmt = $db->query('SELECT @@auto_increment_increment AS inc');
84 $row = $stmt->fetch(PDO::FETCH_ASSOC);
90 $stmt = $db->query('SELECT LAST_INSERT_ID() as _last_id');
91 $row = $stmt->fetch(PDO::FETCH_ASSOC);
H A Dpdo_mysql_multi_stmt_nextrowset.phpt34 $stmt = $db->query('CALL p()');
36 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
37 } while ($stmt->nextRowSet());
38 var_dump($stmt->nextRowSet());
68 $stmt = $db->query("SELECT * FROM test; INSERT INTO test (id, label) VALUES (99, 'x')");
69 if ($stmt !== false) {
70 $stmt->closeCursor();
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug70861.phpt35 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)", array(PDO::ATTR_CURSOR => P…
37 $stmt->bindparam(':foo', $f, PDO::PARAM_LOB);
38 $stmt->execute();
H A Dbug69752.phpt28 $stmt = $pdo->prepare("insert into foo (field1, field2, field3, field4) values (:field1, :field2, :…
39 $stmt->execute($data);
40 $stmt->closeCursor();
H A Dbug75402.phpt64 $stmt = $db->prepare($sql,
73 $stmt->execute();
75 while ($entry = $stmt->fetchObject()) {
78 $stmt->closeCursor();
79 $stmt = null;
H A Dbug72570.phpt18 $stmt = $db->prepare("SELECT 1");
21 var_dump($stmt->execute([1]));
/PHP-7.4/ext/sqlite3/tests/
H A Dsqlite3_06_prepared_stmt.phpt19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
22 var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT));
24 $results = $stmt->execute();
H A Dsqlite3_07_prepared_stmt.phpt19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
22 var_dump($stmt->bindValue(1, $foo, SQLITE3_TEXT));
23 $results = $stmt->execute();
H A Dsqlite3_bound_value_at_name.phpt19 $stmt = $db->prepare("SELECT * FROM test WHERE id = @id ORDER BY id ASC");
22 var_dump($stmt->bindValue('@id', $foo, SQLITE3_TEXT));
23 $results = $stmt->execute();
H A Dsqlite3_27_reset_prepared_stmt_result.phpt19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
22 var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT));
24 $results = $stmt->execute();
H A Dbug66550.phpt14 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id');
18 $stmt->reset();
H A Dsqlite3_prepare_faultystmt.phpt14 $stmt = $db->prepare('SELECT foo FROM bar');
16 var_dump($stmt);
/PHP-7.4/ext/pdo/tests/
H A Dbug_43130.phpt31 $stmt = $db->prepare("SELECT a FROM test WHERE b=:id-value");
32 $stmt->bindParam(':id-value', $id);
34 $stmt->execute();
35 var_dump($stmt->fetch(PDO::FETCH_COLUMN));
H A Dpdo_020.phpt24 $stmt = $db->query($sql);
25 $res = $stmt->columnCount();
27 $stmt = null;
H A Dpdo_024.phpt29 $stmt = $db->prepare('insert into test (id, name) values(0, :name)');
32 $stmt->bindParam(':name', $name, PDO::PARAM_NULL);
38 var_dump($stmt->execute());
/PHP-7.4/ext/pdo_firebird/
H A Dfirebird_driver.c40 pdo_error_type *const error_code = stmt ? &stmt->error_code : &dbh->error_code; in _firebird_error()
87 pdo_stmt_t *stmt, zval *driver_options) in firebird_handle_preparer() argument
113 S->stmt = s; in firebird_handle_preparer()
116 S->out_sqlda.sqln = stmt->column_count = num_sqlda.sqld; in firebird_handle_preparer()
147 stmt->driver_data = S; in firebird_handle_preparer()
148 stmt->methods = &firebird_stmt_methods; in firebird_handle_preparer()
149 stmt->supports_placeholders = PDO_PLACEHOLDER_POSITIONAL; in firebird_handle_preparer()
175 isc_stmt_handle stmt = PDO_FIREBIRD_HANDLE_INITIALIZER; in firebird_handle_doer() local
187 if (!firebird_alloc_prepare_stmt(dbh, sql, sql_len, &out_sqlda, &stmt, 0)) { in firebird_handle_doer()
199 if (isc_dsql_sql_info(H->isc_status, &stmt, sizeof(info_count), const_cast(info_count), in firebird_handle_doer()
[all …]
/PHP-7.4/ext/oci8/tests/
H A Dcursors_old.phpt28 $stmt = ociparse($c, $sql);
30 ociexecute($stmt);
32 while ($result = ocifetchinto($stmt, $data, OCI_ASSOC)) {
H A Dcursors.phpt31 $stmt = oci_parse($c, $sql);
33 oci_execute($stmt);
35 while ($data = oci_fetch_assoc($stmt)) {
/PHP-7.4/ext/pdo_dblib/tests/
H A Dbug_73396.phpt16 $stmt = $db->query('SELECT CAST(1 AS bigint)');
17 var_dump($stmt->fetchColumn() === $expected);
/PHP-7.4/ext/odbc/tests/
H A Dbug80152.phpt11 $stmt = odbc_prepare($conn,"INSERT INTO bug80152 (id, name) VALUES (?, ?)");
14 odbc_execute($stmt, $params);
/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_get_client_stats.phpt328 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
336 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
365 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
370 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
374 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
406 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
411 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
415 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
454 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
459 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
/PHP-7.4/ext/pdo/
H A Dphp_pdo_int.h45 int pdo_stmt_describe_columns(pdo_stmt_t *stmt);
46 int pdo_stmt_setup_fetch_mode(INTERNAL_FUNCTION_PARAMETERS, pdo_stmt_t *stmt, int skip_first_arg);
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dbug48773.phpt26 $stmt = $db->query('SELECT 1');
27 var_dump($stmt);

Completed in 39 milliseconds

1...<<111213141516171819