Home
last modified time | relevance | path

Searched refs:stmt (Results 101 – 125 of 492) sorted by relevance

12345678910>>...20

/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_stmt_send_long_data.phpt14 if (!$stmt = mysqli_stmt_init($link))
24 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
28 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label))
29 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
67 $tmp = mysqli_stmt_send_long_data($stmt, -1, $blob);
74 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
76 if (true !== ($tmp = mysqli_stmt_send_long_data($stmt, 1, $blob)))
78 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
81 if (true !== mysqli_stmt_execute($stmt))
82 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_execute_stored_proc_out.phpt28 if (!$stmt = mysqli_prepare($link, 'CALL p(?, ?)'))
33 if (!mysqli_stmt_bind_param($stmt, 'ss', $ver_in, $ver_out))
34 …intf("[006] Cannot bind parameter, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 if (!mysqli_stmt_execute($stmt))
37 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 if (!mysqli_stmt_bind_result($stmt, $ver_out) || !mysqli_stmt_fetch($stmt))
44 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
52 if (!mysqli_stmt_close($stmt))
53 …ntf("[012] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
H A D021.phpt21 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
22 mysqli_stmt_bind_param($stmt, "ss", $q1, $q2);
25 mysqli_stmt_execute($stmt);
26 mysqli_stmt_close($stmt);
28 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
29 mysqli_stmt_bind_result($stmt, $c1, $c2);
30 mysqli_stmt_execute($stmt);
31 mysqli_stmt_fetch($stmt);
37 mysqli_stmt_close($stmt);
H A Dbug48909.phpt21 if (!$stmt = $link->prepare("INSERT INTO test(id, label) VALUES (?, ?)"))
24 if (!$stmt->bind_param("bb",$bvar, $bvar))
25 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
27 if (!$stmt->execute()) {
28 if ($stmt->errno != 1366) {
33 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error);
37 $stmt->close();
H A D022.phpt22 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
23 mysqli_stmt_bind_param($stmt, "ss", $a1, $a2);
28 mysqli_stmt_execute($stmt);
29 mysqli_stmt_close($stmt);
31 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
32 mysqli_stmt_bind_result($stmt, $c1, $c2);
33 mysqli_stmt_execute($stmt);
34 mysqli_stmt_fetch($stmt);
41 mysqli_stmt_close($stmt);
H A D059.phpt23 $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?||?)");
25 mysqli_stmt_bind_param($stmt, "ss", $a, $b);
30 mysqli_stmt_execute($stmt);
32 mysqli_stmt_close($stmt);
34 $stmt = mysqli_prepare($link, "SELECT * FROM mbind");
35 mysqli_stmt_execute($stmt);
37 mysqli_stmt_bind_result($stmt, $e);
38 mysqli_stmt_fetch($stmt);
H A D064.phpt15 $stmt = new mysqli_stmt($mysql, "SELECT NULL FROM DUAL");
16 $stmt->execute();
17 $stmt->bind_result($foo);
18 $stmt->fetch();
19 $stmt->close();
H A Dmysqli_stmt_get_result_geom.phpt40 if (!$stmt = mysqli_stmt_init($link)) {
46 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 mysqli_stmt_close($stmt);
51 if (!mysqli_stmt_execute($stmt)) {
52 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
53 mysqli_stmt_close($stmt);
57 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
58 mysqli_stmt_close($stmt);
115 $offset + 18, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
117 mysqli_stmt_close($stmt);
[all …]
/PHP-8.3/ext/oci8/tests/
H A Dbug36096.phpt15 $stmt = oci_parse($c, $sql);
17 if(oci_execute($stmt, OCI_COMMIT_ON_SUCCESS)){
18 var_dump(oci_fetch($stmt));
19 var_dump(oci_result($stmt, 1));
20 var_dump(oci_field_name($stmt, 1));
21 var_dump(oci_field_type($stmt, 1));
H A Dbug43497.phpt21 $stmt = oci_parse($c, $query);
24 $row = oci_fetch($stmt);
36 $stmt = oci_parse($c, $query);
39 $row = oci_fetch($stmt);
41 oci_free_statement($stmt);
54 if (oci_execute($stmt)) {
69 if (oci_execute($stmt)) {
83 if (oci_execute($stmt)) {
95 oci_execute($stmt);
101 oci_execute($stmt);
[all …]
H A Dbug72524.phpt29 $stmt = oci_parse($c, $sql);
33 oci_bind_by_name($stmt, ':clob_col', $clob);
34 oci_bind_by_name($stmt, ':varchar2_col', $varchar2);
36 var_dump(oci_execute($stmt));
42 oci_bind_by_name($stmt, ':clob_col', $clob);
43 oci_bind_by_name($stmt, ':varchar2_col', $varchar2);
45 var_dump(oci_execute($stmt));
50 oci_bind_by_name($stmt, ':clob_col', $clob, 0);
53 var_dump(oci_execute($stmt));
61 var_dump(oci_execute($stmt));
[all …]
/PHP-8.3/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_blobs.phpt33 $stmt->bindValue(1, 1);
34 $stmt->bindValue(2, $value);
35 if (!$stmt->execute()) {
37 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
41 $stmt = $db->query('SELECT id, label FROM test');
43 $stmt->bindColumn(1, $id, PDO::PARAM_INT);
44 $stmt->bindColumn(2, $label, PDO::PARAM_LOB);
46 if (!$stmt->fetch(PDO::FETCH_BOUND)) {
48 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
70 $stmt = $db->query('SELECT id, label FROM test');
[all …]
H A Dpdo_mysql_prepare_native_named_placeholder.phpt32 $stmt->execute(array(':placeholder' => 'row1'));
33 if ('00000' !== $stmt->errorCode())
35 var_export($stmt->errorCode(), true),
36 var_export($stmt->errorInfo(), true));
40 $stmt->execute();
41 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
53 if ('00000' !== $stmt->errorCode())
55 var_export($stmt->errorCode(), true),
56 var_export($stmt->errorInfo(), true));
60 $stmt->execute();
[all …]
H A Dpdo_mysql_prepare_match_against.phpt21 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
22 $stmt->execute(array(':placeholder' => 'row'));
23 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
25 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
26 $stmt->execute(array('placeholder' => 'row'));
27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
29 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
30 $stmt->execute(array('row'));
31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dbug44327.phpt17 $stmt = $db->prepare("SELECT 1 AS \"one\"");
18 $stmt->execute();
19 $row = $stmt->fetch(PDO::FETCH_LAZY);
30 $stmt = $db->prepare("SELECT id FROM test");
31 $stmt->execute();
32 $row = $stmt->fetch(PDO::FETCH_LAZY);
39 $stmt = $db->prepare('foo');
40 @$stmt->execute();
41 $row = $stmt->fetch();
H A Dpdo_mysql_connect_attr.phpt13 $stmt = $pdo->query("select count(*) from information_schema.tables where table_schema='performance…
14 if (!$stmt || !$stmt->fetchColumn()) {
18 $stmt = $pdo->query("show variables like 'performance_schema'");
19 if (!$stmt || $stmt->fetchColumn(1) !== 'ON') {
36 …$stmt = $pdo->query("select * from performance_schema.session_connect_attrs where ATTR_NAME='_serv…
38 $row = $stmt->fetch(PDO::FETCH_ASSOC);
47 $stmt = $pdo->query("select * from performance_schema.session_connect_attrs where ATTR_NAME='_clien…
49 $row = $stmt->fetch(PDO::FETCH_ASSOC);
H A Dpdo_mysql_prepare_emulated.phpt22 $stmt = @$db->prepare($query);
24 $stmt = $db->prepare($query);
50 $ret = @$stmt->execute($input_params);
52 $ret = $stmt->execute($input_params);
59 $tmp = $stmt->errorInfo();
85 return $stmt;
100 $stmt = prepex(4, $db, 'SELECT 1 as "one"');
101 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
297 $stmt = prepex(79, $db, $sql, array(-1));
304 $stmt = prepex(81, $db, $sql, array(1));
[all …]
/PHP-8.3/ext/pdo_dblib/tests/
H A Dtimeout.phpt20 $stmt = $db->prepare($sql);
21 if (!$stmt->execute()) {
25 if ($stmt->errorCode() != '00000') {
34 $stmt = $db->prepare($sql);
35 if (!$stmt->execute()) {
39 if ($stmt->errorCode() != '00000') {
46 $stmt = $db->prepare($sql);
47 if (!$stmt->execute()) {
51 if ($stmt->errorCode() != '00000') {
58 $stmt = $db->prepare($sql);
[all …]
H A Dbug_69757.phpt19 $stmt = $db->query($sql);
20 $resultset1 = $stmt->fetchAll(PDO::FETCH_ASSOC);
21 if (true !== $stmt->nextRowset()) {
24 $resultset2 = $stmt->fetchAll(PDO::FETCH_ASSOC);
25 if (false !== $stmt->nextRowset()) {
28 $stmt->closeCursor();
/PHP-8.3/ext/pdo/tests/
H A Dpdo_029.phpt56 $stmt->setFetchMode(PDO::FETCH_ASSOC);
57 $stmt->execute();
58 return $stmt;
67 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
68 var_dump(get_class($stmt));
70 $stmt->execute($row);
73 unset($stmt);
77 $stmt = $db->query('SELECT * FROM test');
78 var_dump(get_class($stmt));
79 var_dump(get_class($stmt->dbh));
[all …]
/PHP-8.3/ext/pdo_pgsql/tests/
H A Dlarge_objects.phpt28 $stmt->bindValue(1, 1);
33 $stmt->bindParam(2, $stm, PDO::PARAM_LOB);
34 $stmt->execute();
39 $stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
40 $stmt->execute();
42 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
50 $stmt->execute();
51 $stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
53 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
61 $stmt->execute();
[all …]
/PHP-8.3/ext/pdo/
H A Dphp_pdo_error.h22 PDO_API void pdo_handle_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt);
31 #define PDO_STMT_CLEAR_ERR() strcpy(stmt->error_code, PDO_ERR_NONE)
33 #define PDO_HANDLE_STMT_ERR() if (strcmp(stmt->error_code, PDO_ERR_NONE)) { pdo_handle_error(stmt…
/PHP-8.3/ext/pdo_sqlite/tests/
H A Dbug78192.phpt11 $stmt = $connection->prepare('INSERT INTO user (id, name) VALUES(:id, :name)');
12 $stmt->execute([
17 $stmt = $connection->prepare('SELECT * FROM user WHERE id = :id');
18 $stmt->execute(['id' => 10]);
19 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
22 $stmt->execute(['id' => 10]);
23 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
/PHP-8.3/ext/pdo_oci/
H A Doci_statement.c69 if (S->stmt) { in oci_stmt_dtor()
76 S->stmt = NULL; in oci_stmt_dtor()
121 stmt->driver_data = NULL; in oci_stmt_dtor()
137 if (stmt->executed) { in oci_stmt_execute()
147 if (stmt->dbh->auto_commit && !stmt->dbh->in_txn) { in oci_stmt_execute()
157 if (!stmt->executed) { in oci_stmt_execute()
614 pdo_stmt_t *stmt; member
678 pdo_stmt_t *stmt = self->stmt; in oci_blob_close() local
733 self->stmt = stmt; in oci_create_lob_stream()
745 obj = &stmt->std; in oci_create_lob_stream()
[all …]
/PHP-8.3/ext/pdo_oci/tests/
H A Dpdo_oci_attr_action.phpt20 $stmt = $dbh->query($query);
21 $row = $stmt->fetch();
27 $stmt = $dbh->query($query);
28 $row = $stmt->fetch();
34 $stmt = $dbh->query($query);
35 $row = $stmt->fetch();
41 $stmt = $dbh->query($query);
42 $row = $stmt->fetch();

Completed in 36 milliseconds

12345678910>>...20