Home
last modified time | relevance | path

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

12345678910>>...20

/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_stmt_bind_result_zerofill.phpt29 if (!($stmt = mysqli_prepare($link, 'SELECT zero FROM test LIMIT 1'))) {
36 if (!mysqli_stmt_bind_result($stmt, $result)) {
38 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_fetch($stmt)) {
44 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
48 $res = mysqli_stmt_result_metadata($stmt);
50 mysqli_stmt_free_result($stmt);
H A D017.phpt16 if (!$stmt = mysqli_prepare($link, "SELECT md5('bar'), database(), 'foo'"))
19 mysqli_stmt_bind_result($stmt, $c0, $c1, $c2);
20 mysqli_stmt_execute($stmt);
22 mysqli_stmt_fetch($stmt);
23 mysqli_stmt_close($stmt);
H A Dbug33263.phpt23 $stmt = $mysql->prepare("SELECT DATABASE()");
24 $stmt->execute();
25 $stmt->bind_result($database);
26 $stmt->fetch();
27 $stmt->close();
H A Dbug35759.phpt36 $stmt = $mysql->prepare("SELECT * FROM test");
37 if ($stmt) {
39 $stmt->execute();
40 $stmt->store_result();
44 call_user_func_array(array($stmt, "bind_result"), $params);
45 $stmt->fetch();
47 $stmt->close();
H A Dgh12107.phpt24 $stmt = $mysqli->prepare("call `gh12107`()");
25 $stmt->execute();
26 $stmt->bind_result($output);
27 var_dump($stmt->fetch());
33 $stmt->execute();
34 $stmt->bind_result($output);
35 var_dump($stmt->fetch());
H A Dmysqli_stmt_get_result_types.phpt36 … printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 … printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 mysqli_stmt_close($stmt);
54 mysqli_stmt_close($stmt);
59 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 mysqli_stmt_close($stmt);
65 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 mysqli_stmt_close($stmt);
73 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
98 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
[all …]
H A Dbug66124.phpt34 $stmt = $link->prepare($table_insert);
35 if (!$stmt) {
41 $stmt->bind_param('i', $id);
43 if ($stmt->execute()){
44 echo "insert id:{$id}=>{$stmt->insert_id}\n";
62 $stmt->close();
68 $stmt = $link->prepare($table_insert);
69 $stmt->bind_param('s', $id);
73 if ($stmt->execute()){
H A Dmysqli_stmt_get_result_metadata_fetch_field.phpt23 if (!($stmt = mysqli_stmt_init($link)) ||
24 …!mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') ___label FROM te…
25 !mysqli_stmt_execute($stmt))
26 printf("[001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
28 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
30 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
33 if (!is_object($res_meta = mysqli_stmt_result_metadata($stmt)) ||
36 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 mysqli_stmt_close($stmt);
H A Dbug76386.phpt39 $stmt = $link->prepare('SELECT * FROM ts_test;'); // must be statement
40 if ($stmt) {
41 $stmt->execute();
44 $stmt->fetch();
46 $stmt->free_result();
67 $stmt = $link->prepare('SELECT * FROM t_test;');
68 if ($stmt) {
69 $stmt->execute();
71 $stmt->bind_result($tid, $t, $t2, $t4, $t6);
72 while ($stmt->fetch()) {
[all …]
H A Dmysqli_change_user_prepared_statements.phpt16 if (!$stmt = mysqli_prepare($link, "SELECT 'prepared statements should be released'"))
22 if ($stmt->execute() && $stmt->bind_result($wrong) && $stmt->fetch()) {
25 if ($stmt->errno == 0)
/PHP-8.3/ext/pdo_mysql/tests/
H A Dbug_39858.phpt41 $stmt = $db->prepare("CALL p()");
42 $stmt->execute();
44 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
45 } while ($stmt->nextRowset());
47 $stmt = $db->prepare("CALL p()");
48 $stmt->execute();
50 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
51 } while ($stmt->nextRowset());
52 $stmt->closeCursor();
/PHP-8.3/ext/pdo/tests/
H A Dbug_73234.phpt36 $stmt = $db->prepare('INSERT INTO test VALUES(:value)');
38 $stmt->bindValue(':value', 0, PDO::PARAM_NULL);
39 $stmt->execute();
41 $stmt->bindValue(':value', null, PDO::PARAM_NULL);
42 $stmt->execute();
44 $stmt = $db->query('SELECT * FROM test');
45 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_019.phpt27 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
29 $stmt->execute();
30 $cont = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE);
35 $stmt->bindColumn('idx', $idx);
36 $stmt->bindColumn('txt', $txt);
37 $stmt->execute();
39 while($stmt->fetch(PDO::FETCH_BOUND)) {
H A Dpdo_025.phpt31 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
33 $stmt->execute($row);
40 $stmt = $db->prepare('SELECT * FROM test');
41 $stmt->setFetchMode(PDO::FETCH_INTO, new Test);
42 $stmt->execute();
44 foreach($stmt as $obj) {
55 $stmt->setFetchMode(PDO::FETCH_INTO, new Fail);
56 $stmt->execute();
58 foreach($stmt as $obj) {
H A Dpdo_013.phpt24 $stmt = $db->prepare($SELECT);
26 $stmt->execute();
27 $stmt->setFetchMode(PDO::FETCH_NUM);
28 foreach ($stmt as $data)
44 unset($stmt);
51 unset($stmt);
53 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test', array('WOW'));
55 foreach($stmt as $data)
/PHP-8.3/ext/sqlite3/tests/
H A Dsqlite3_28_clear_bindings.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();
28 $stmt->reset();
29 $stmt->clear();
30 var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT));
31 $results = $stmt->execute();
H A Dexception_from_toString.phpt17 $stmt = $db->prepare('INSERT INTO t VALUES(:i, :v)');
18 $stmt->bindValue('i', 1234);
19 $stmt->bindValue('v', new throws);
22 $stmt->execute();
28 $stmt->execute();
/PHP-8.3/ext/mysqlnd/
H A Dmysqlnd_driver.c188 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local
193 stmt = ret->data = mnd_ecalloc(1, sizeof(MYSQLND_STMT_DATA)); in MYSQLND_METHOD()
194 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD()
196 mysqlnd_error_info_init(&stmt->error_info_impl, 0); in MYSQLND_METHOD()
197 stmt->error_info = &stmt->error_info_impl; in MYSQLND_METHOD()
199 mysqlnd_upsert_status_init(&stmt->upsert_status_impl); in MYSQLND_METHOD()
200 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD()
201 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD()
203 stmt->execute_cmd_buffer.buffer = mnd_emalloc(stmt->execute_cmd_buffer.length); in MYSQLND_METHOD()
204 stmt->prefetch_rows = MYSQLND_DEFAULT_PREFETCH_ROWS; in MYSQLND_METHOD()
[all …]
/PHP-8.3/ext/pdo_oci/tests/
H A Dpdo_oci_attr_module.phpt22 $stmt = $dbh->query($query);
23 $row = $stmt->fetch();
29 $stmt = $dbh->query($query);
30 $row = $stmt->fetch();
36 $stmt = $dbh->query($query);
37 $row = $stmt->fetch();
/PHP-8.3/ext/pdo_pgsql/tests/
H A Dbug71885_2.phpt31 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?");
32 $stmt->execute(['b']);
33 var_dump($stmt->fetch());
35 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???");
36 $stmt->execute(['a']);
37 var_dump($stmt->fetch());
H A Dbug46274_2.phpt26 $stmt = $db->prepare("INSERT INTO test_one_blob_46274_2 (blob1) VALUES (:foo)");
33 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
34 $stmt->execute();
37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
38 $stmt->execute();
45 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
46 $stmt->execute();
49 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
50 $stmt->execute();
/PHP-8.3/ext/oci8/tests/
H A Derror_bind.phpt26 $stmt = oci_parse($c, "insert into bind_test values (:name)");
27 oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR);
28 var_dump(oci_execute($stmt));
32 var_dump(oci_execute($stmt));
35 oci_bind_by_name($stmt, ":name", $c);
36 var_dump(oci_execute($stmt));
41 $stmt = oci_parse($c, "update bind_test set name='xyz' returning rowid into :r_id");
42 oci_bind_by_name($stmt, ":r_id", $c);
43 var_dump(oci_execute($stmt));
H A Dbug42841.phpt53 $stmt = oci_parse($c, $sql);
55 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR);
57 oci_execute($stmt, OCI_DEFAULT);
64 oci_free_statement($stmt);
71 $stmt = oci_parse($c, $sql);
73 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR);
75 oci_execute($stmt, OCI_DEFAULT);
82 oci_free_statement($stmt);
99 oci_bind_by_name($stmt, ':cur', $cur, -1, OCI_B_CURSOR);
100 oci_execute($stmt, OCI_DEFAULT);
[all …]
/PHP-8.3/ext/pdo/
H A Dphp_pdo_driver.h317 typedef int (*pdo_stmt_dtor_func)(pdo_stmt_t *stmt);
320 typedef int (*pdo_stmt_execute_func)(pdo_stmt_t *stmt);
325 typedef int (*pdo_stmt_fetch_func)(pdo_stmt_t *stmt,
330 typedef int (*pdo_stmt_describe_col_func)(pdo_stmt_t *stmt, int colno);
338 pdo_stmt_t *stmt, int colno, zval *result, enum pdo_param_type *type);
393 typedef int (*pdo_stmt_next_rowset_func)(pdo_stmt_t *stmt);
399 typedef int (*pdo_stmt_cursor_closer_func)(pdo_stmt_t *stmt);
545 pdo_stmt_t *stmt; /* for convenience in dtor */ member
647 pdo_stmt_t *stmt; member
674 PDO_API void pdo_raise_impl_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt,
[all …]
/PHP-8.3/ext/pdo_firebird/tests/
H A Dbug_64037.phpt24 $stmt = $dbh->prepare($query);
25 $stmt->execute();
26 $rows = $stmt->fetchAll();
32 $stmt = $dbh->prepare('DELETE FROM price');
33 $stmt->execute();
39 unset($stmt);

Completed in 32 milliseconds

12345678910>>...20