Home
last modified time | relevance | path

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

12345678910>>...19

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_blobs.phpt32 $stmt->bindValue(1, 1);
33 $stmt->bindValue(2, $value);
34 if (!$stmt->execute()) {
36 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
40 $stmt = $db->query('SELECT id, label FROM test');
42 $stmt->bindColumn(1, $id, PDO::PARAM_INT);
43 $stmt->bindColumn(2, $label, PDO::PARAM_LOB);
45 if (!$stmt->fetch(PDO::FETCH_BOUND)) {
47 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
63 $stmt = $db->query('SELECT id, label FROM test');
[all …]
H A Dbug44327.phpt15 $stmt = $db->prepare("SELECT 1 AS \"one\"");
16 $stmt->execute();
17 $row = $stmt->fetch(PDO::FETCH_LAZY);
28 $stmt = $db->prepare("SELECT id FROM test");
29 $stmt->execute();
30 $row = $stmt->fetch(PDO::FETCH_LAZY);
37 $stmt = $db->prepare('foo');
38 @$stmt->execute();
39 $row = $stmt->fetch();
H A Dpdo_mysql_attr_multi_statements.phpt26 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table));
27 $stmt->closeCursor();
30 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
33 $stmt = $db->query('SELECT 1 AS value;');
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
39 var_dump($stmt);
43 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
44 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
46 $stmt = $db->query('SELECT 1 AS value;');
[all …]
H A Dpdo_mysql_connect_attr.phpt12 $stmt = $pdo->query("select count(*) from information_schema.tables where table_schema='performance…
13 if (!$stmt || !$stmt->fetchColumn()) {
17 $stmt = $pdo->query("show variables like 'performance_schema'");
18 if (!$stmt || $stmt->fetchColumn(1) !== 'ON') {
35 …$stmt = $pdo->query("select * from performance_schema.session_connect_attrs where ATTR_NAME='_serv…
37 $row = $stmt->fetch(PDO::FETCH_ASSOC);
46 $stmt = $pdo->query("select * from performance_schema.session_connect_attrs where ATTR_NAME='_clien…
48 $row = $stmt->fetch(PDO::FETCH_ASSOC);
H A Dpdo_mysql_attr_fetch_table_names.phpt16 $stmt = $db->query('SELECT label FROM test LIMIT 1');
17 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
18 $stmt->closeCursor();
21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
23 $stmt->closeCursor();
H A Dpdo_mysql_prepare_match_against.phpt20 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
21 $stmt->execute(array(':placeholder' => 'row'));
22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
24 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
25 $stmt->execute(array('placeholder' => 'row'));
26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
28 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
29 $stmt->execute(array('row'));
30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_execute_stored_proc_out.phpt33 if (!$stmt = mysqli_prepare($link, 'CALL p(?, ?)'))
38 if (!mysqli_stmt_bind_param($stmt, 'ss', $ver_in, $ver_out))
39 …intf("[006] Cannot bind parameter, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
41 if (!mysqli_stmt_execute($stmt))
42 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 if (!mysqli_stmt_bind_result($stmt, $ver_out) || !mysqli_stmt_fetch($stmt))
48 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
53 if (!mysqli_stmt_close($stmt))
54 …ntf("[012] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
H A Dmysqli_stmt_bind_result.phpt24 $stmt = mysqli_stmt_init($link);
26 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
31 mysqli_stmt_close($stmt);
32 $stmt = mysqli_stmt_init($link);
42 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
54 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 mysqli_stmt_close($stmt);
99 mysqli_stmt_close($stmt);
142 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
305 printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dbug48909.phpt20 if (!$stmt = $link->prepare("INSERT INTO test(id, label) VALUES (?, ?)"))
23 if (!$stmt->bind_param("bb",$bvar, $bvar))
24 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
26 if (!$stmt->execute()) {
27 if ($stmt->errno != 1366) {
32 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error);
36 $stmt->close();
H A D021.phpt20 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
21 mysqli_stmt_bind_param($stmt, "ss", $q1, $q2);
24 mysqli_stmt_execute($stmt);
25 mysqli_stmt_close($stmt);
27 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
28 mysqli_stmt_bind_result($stmt, $c1, $c2);
29 mysqli_stmt_execute($stmt);
30 mysqli_stmt_fetch($stmt);
36 mysqli_stmt_close($stmt);
H A D022.phpt21 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
22 mysqli_stmt_bind_param($stmt, "ss", $a1, $a2);
27 mysqli_stmt_execute($stmt);
28 mysqli_stmt_close($stmt);
30 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
31 mysqli_stmt_bind_result($stmt, $c1, $c2);
32 mysqli_stmt_execute($stmt);
33 mysqli_stmt_fetch($stmt);
40 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_errno.phpt24 if (!$stmt = mysqli_stmt_init($link))
28 if (0 !== ($tmp = mysqli_stmt_errno($stmt)))
31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
35 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
39 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (0 != ($tmp = mysqli_stmt_errno($stmt)))
47 if (true === ($tmp = mysqli_stmt_execute($stmt)))
51 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
54 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_error.phpt24 if (!$stmt = mysqli_stmt_init($link))
28 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
35 if ('' === ($tmp = mysqli_stmt_error($stmt)))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
39 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt));
42 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
47 if (true === ($tmp = mysqli_stmt_execute($stmt)))
51 if ('' === ($tmp = mysqli_stmt_error($stmt)))
54 mysqli_stmt_close($stmt);
[all …]
H A D059.phpt22 $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?||?)");
24 mysqli_stmt_bind_param($stmt, "ss", $a, $b);
29 mysqli_stmt_execute($stmt);
31 mysqli_stmt_close($stmt);
33 $stmt = mysqli_prepare($link, "SELECT * FROM mbind");
34 mysqli_stmt_execute($stmt);
36 mysqli_stmt_bind_result($stmt, $e);
37 mysqli_stmt_fetch($stmt);
H A D064.phpt14 $stmt = new mysqli_stmt($mysql, "SELECT NULL FROM DUAL");
15 $stmt->execute();
16 $stmt->bind_result($foo);
17 $stmt->fetch();
18 $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 …]
H A D063.phpt14 $stmt = new mysqli_stmt($mysql, "SELECT 'foo' FROM DUAL");
15 $stmt->execute();
16 $stmt->bind_result($foo);
17 $stmt->fetch();
18 $stmt->close();
24 $stmt = new mysqli_stmt($mysql, "SELECT invalid FROM DUAL");
/PHP-7.4/ext/oci8/tests/
H A Dbug43497.phpt21 $row = oci_fetch($stmt);
22 return oci_result($stmt, 1);
36 $row = oci_fetch($stmt);
37 $val = oci_result($stmt, 1);
38 oci_free_statement($stmt);
51 if (oci_execute($stmt)) {
66 if (oci_execute($stmt)) {
80 if (oci_execute($stmt)) {
92 oci_execute($stmt);
98 oci_execute($stmt);
[all …]
H A Dbug72524.phpt26 $stmt = oci_parse($c, $sql);
30 oci_bind_by_name($stmt, ':clob_col', $clob);
31 oci_bind_by_name($stmt, ':varchar2_col', $varchar2);
33 var_dump(oci_execute($stmt));
39 oci_bind_by_name($stmt, ':clob_col', $clob);
40 oci_bind_by_name($stmt, ':varchar2_col', $varchar2);
42 var_dump(oci_execute($stmt));
47 oci_bind_by_name($stmt, ':clob_col', $clob, 0);
50 var_dump(oci_execute($stmt));
58 var_dump(oci_execute($stmt));
[all …]
H A Dstatement_cache.phpt17 $stmt = oci_parse($pc, "select 1+3 from dual");
18 oci_execute($stmt);
19 var_dump(oci_fetch_array($stmt));
21 $stmt = oci_parse($pc, "select 1+3 from dual");
22 oci_execute($stmt);
23 var_dump(oci_fetch_array($stmt));
/PHP-7.4/ext/pdo/tests/
H A Dpdo_029.phpt55 $stmt->setFetchMode(PDO::FETCH_ASSOC);
56 $stmt->execute();
57 return $stmt;
66 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
67 var_dump(get_class($stmt));
69 $stmt->execute($row);
72 unset($stmt);
76 $stmt = $db->query('SELECT * FROM test');
77 var_dump(get_class($stmt));
78 var_dump(get_class($stmt->dbh));
[all …]
H A Dbug_73234.phpt20 $stmt = $db->prepare('INSERT INTO test VALUES(:value)');
22 $stmt->bindValue(':value', 0, PDO::PARAM_NULL);
23 $stmt->execute();
25 $stmt->bindValue(':value', null, PDO::PARAM_NULL);
26 $stmt->execute();
28 $stmt = $db->query('SELECT * FROM test');
29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-7.4/ext/pdo_dblib/tests/
H A Dbug_69757.phpt18 $stmt = $db->query($sql);
19 $resultset1 = $stmt->fetchAll(PDO::FETCH_ASSOC);
20 if (true !== $stmt->nextRowset()) {
23 $resultset2 = $stmt->fetchAll(PDO::FETCH_ASSOC);
24 if (false !== $stmt->nextRowset()) {
27 $stmt->closeCursor();
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dbug78192.phpt13 $stmt = $connection->prepare('INSERT INTO user (id, name) VALUES(:id, :name)');
14 $stmt->execute([
19 $stmt = $connection->prepare('SELECT * FROM user WHERE id = :id');
20 $stmt->execute(['id' => 10]);
21 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
24 $stmt->execute(['id' => 10]);
25 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
/PHP-7.4/ext/pdo_oci/
H A Doci_statement.c71 if (S->stmt) { in oci_stmt_dtor()
78 S->stmt = NULL; in oci_stmt_dtor()
123 stmt->driver_data = NULL; in oci_stmt_dtor()
139 if (stmt->executed) { in oci_stmt_execute()
149 if (stmt->dbh->auto_commit && !stmt->dbh->in_txn) { in oci_stmt_execute()
159 if (!stmt->executed) { in oci_stmt_execute()
630 pdo_stmt_t *stmt; member
682 pdo_stmt_t *stmt = self->stmt; in oci_blob_close() local
737 self->stmt = stmt; in oci_create_lob_stream()
747 obj = &stmt->std; in oci_create_lob_stream()
[all …]

Completed in 30 milliseconds

12345678910>>...19