Home
last modified time | relevance | path

Searched refs:stmt (Results 76 – 100 of 492) sorted by relevance

12345678910>>...20

/PHP-8.3/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_closecursor_empty.phpt28 if (!$stmt->bindParam(1, $in))
30 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
32 $stmt->execute();
35 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
37 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
39 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
41 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
43 while ($stmt->fetch(PDO::FETCH_BOUND))
49 $stmt->closeCursor();
50 $stmt->execute();
[all …]
H A Dpdo_mysql_stmt_fetchobject_ctor_args.phpt13 $stmt = $db->prepare($query);
14 $ok = @$stmt->execute();
29 $stmt = $db->prepare($query);
44 $stmt->execute();
46 $obj = $stmt->fetchObject(Foo::class);
51 $stmt->execute();
58 $stmt->execute();
62 $stmt->execute();
63 $obj = $stmt->fetchObject(Bar::class);
66 $stmt->execute();
[all …]
H A Dbug67004.phpt19 $stmt = $dbh->prepare("SELECT ?");
21 $stmt->execute(["foo"]);
22 var_dump($stmt->fetchColumn(0));
24 $stmt->execute(["bar"]);
25 var_dump($stmt->fetchColumn(0));
27 $stmt = $dbh->prepare("SELECT ?");
28 $stmt->execute(["baz"]);
29 var_dump($stmt->fetchColumn(0));
H A Dpdo_mysql_prepare_emulated_anonymous.phpt26 $stmt->execute(array('first row'));
27 if ('00000' !== $stmt->errorCode())
29 var_export($stmt->errorCode(), true),
30 var_export($stmt->errorInfo(), true));
33 $stmt->execute();
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
45 $stmt->execute(array('first row'));
46 if ('00000' !== $stmt->errorCode())
48 var_export($stmt->errorCode(), true),
52 $stmt->execute();
[all …]
H A Dbug_44707.phpt13 $stmt = $db->query('SELECT VERSION() as _version');
14 $row = $stmt->fetch(PDO::FETCH_ASSOC);
40 $stmt->bindParam(1, $id);
44 $stmt->execute();
47 $stmt = $db->query('SELECT * FROM test');
48 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
51 $stmt->bindParam(1, $id);
53 $stmt->bindParam(2, $mybool, PDO::PARAM_INT);
54 $stmt->execute();
56 $stmt = $db->query('SELECT * FROM test');
[all …]
H A Dpdo_mysql_stmt_bindcolumn.phpt23 $stmt->execute();
26 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
28 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
32 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
35 while ($stmt->fetch(PDO::FETCH_BOUND)) {
44 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
63 $stmt->execute();
66 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
68 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
72 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
[all …]
/PHP-8.3/ext/pdo_pgsql/
H A Dpgsql_statement.c127 stmt->driver_data = NULL; in pgsql_stmt_dtor()
137 bool in_trans = stmt->dbh->methods->in_transaction(stmt->dbh); in pgsql_stmt_execute()
183 stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, in pgsql_stmt_execute()
218 stmt->bound_params ? in pgsql_stmt_execute()
228 stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, in pgsql_stmt_execute()
257 if (in_trans && !stmt->dbh->methods->in_transaction(stmt->dbh)) { in pgsql_stmt_execute()
258 pdo_pgsql_close_lob_streams(stmt->dbh); in pgsql_stmt_execute()
286 if (stmt->bound_param_map && (namevar = zend_hash_find_ptr(stmt->bound_param_map, in pgsql_stmt_param_hook()
299 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook()
314 if (!stmt->bound_param_map) { in pgsql_stmt_param_hook()
[all …]
/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_get_client_stats_ps.phpt25 if (!$stmt = mysqli_stmt_init($link))
30 !mysqli_stmt_execute($stmt) ||
31 !mysqli_stmt_store_result($stmt) ||
33 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 while (mysqli_stmt_fetch($stmt))
39 mysqli_stmt_free_result($stmt);
61 !mysqli_stmt_execute($stmt) ||
63 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 while (mysqli_stmt_fetch($stmt))
81 mysqli_stmt_free_result($stmt);
[all …]
H A Dmysqli_stmt_bind_result.phpt13 $stmt = mysqli_stmt_init($link);
15 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
17 mysqli_stmt_close($stmt);
18 $stmt = mysqli_stmt_init($link);
31 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
55 mysqli_stmt_close($stmt);
94 mysqli_stmt_close($stmt);
137 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
291 printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_errno.phpt13 if (!$stmt = mysqli_stmt_init($link))
17 if (0 !== ($tmp = mysqli_stmt_errno($stmt)))
20 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
24 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
27 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
28 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
31 if (0 != ($tmp = mysqli_stmt_errno($stmt)))
36 if (true === ($tmp = mysqli_stmt_execute($stmt)))
40 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
43 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_error.phpt13 if (!$stmt = mysqli_stmt_init($link))
17 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
20 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
24 if ('' === ($tmp = mysqli_stmt_error($stmt)))
27 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
28 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt));
31 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
36 if (true === ($tmp = mysqli_stmt_execute($stmt)))
40 if ('' === ($tmp = mysqli_stmt_error($stmt)))
43 mysqli_stmt_close($stmt);
[all …]
H A D026.phpt22 $stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES (?,?)");
23 mysqli_stmt_bind_param($stmt, "sb", $c1, $c2);
27 mysqli_stmt_send_long_data($stmt, 1, "This is the first sentence.");
28 mysqli_stmt_send_long_data($stmt, 1, " And this is the second sentence.");
31 mysqli_stmt_execute($stmt);
32 mysqli_stmt_close($stmt);
34 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
35 mysqli_stmt_bind_result($stmt, $d1, $d2);
36 mysqli_stmt_execute($stmt);
37 mysqli_stmt_fetch($stmt);
[all …]
H A Dmysqli_stmt_send_long_data_packet_size_mysqlnd.phpt13 if (!$stmt = mysqli_stmt_init($link))
23 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
27 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label))
28 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
54 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
57 if (true !== mysqli_stmt_execute($stmt))
58 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
82 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
85 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
87 … gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dbug42378.phpt69 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
73 if (!mysqli_stmt_execute($stmt)) {
76 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
97 if (!mysqli_stmt_fetch($stmt)) {
100 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
126 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
148 mysqli_stmt_free_result($stmt);
[all …]
/PHP-8.3/ext/pdo_sqlite/tests/
H A Dbug46139.phpt19 $stmt = $db->query("SELECT 'foo' test, 1");
20 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
21 $r1 = $stmt->fetch();
24 $stmt = $db->query("SELECT 'foo' test, 1");
25 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
26 $r1 = $stmt->fetchAll();
29 $stmt = $db->query("SELECT 'foo' test, 1");
30 $stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Person');
31 $r1 = $stmt->fetch(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE);
H A Dbug33841.phpt12 $stmt = $db->prepare("INSERT INTO test_33841 VALUES ( :text )");
13 $stmt->bindParam(':text', $name);
15 var_dump($stmt->execute(), $stmt->rowCount());
17 $stmt = $db->prepare("UPDATE test_33841 SET text = :text ");
18 $stmt->bindParam(':text', $name);
20 var_dump($stmt->execute(), $stmt->rowCount());
/PHP-8.3/ext/oci8/tests/
H A Dbind_empty.phpt26 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name");
27 oci_bind_by_name($stmt, ":name", $name);
29 var_dump(oci_execute($stmt));
35 oci_bind_by_name($stmt, ":name", $name);
37 var_dump(oci_execute($stmt));
42 $res = oci_execute($stmt);
45 $res = oci_execute($stmt);
49 oci_bind_by_name($stmt, ":name", $name);
51 var_dump(oci_execute($stmt));
62 oci_bind_by_name($stmt, ":name", $name);
[all …]
H A Dbug71422.phpt22 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1');
23 oci_execute($stmt);
24 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
28 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes…
30 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_INT);
31 oci_execute($stmt);
32 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
36 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test…
38 oci_bind_by_name($stmt, ':test_id', $value, -1, SQLT_CHR);
39 oci_execute($stmt);
[all …]
H A Ddefine4.phpt26 $stmt = oci_parse($c, "select value, string from define4_tab");
30 var_dump(oci_define_by_name($stmt, "STRING", $string));
32 oci_execute($stmt);
36 while (oci_fetch($stmt)) {
37 var_dump(oci_result($stmt, 'VALUE'));
39 var_dump(oci_result($stmt, 'STRING'));
41 var_dump(oci_result($stmt, 'VALUE'));
42 var_dump(oci_result($stmt, 'STRING'));
46 var_dump(oci_free_statement($stmt));
50 var_dump(oci_result($stmt, 'STRING'));
/PHP-8.3/ext/pdo_dblib/tests/
H A Dbug_67130.phpt13 $stmt = $db->query('SELECT 1; SELECT 2; SELECT 3;');
14 var_dump($stmt->fetch());
15 var_dump($stmt->fetch());
16 var_dump($stmt->nextRowset());
17 var_dump($stmt->nextRowset());
18 var_dump($stmt->fetch());
19 var_dump($stmt->nextRowset());
H A Dbatch_stmt_ins_exec.phpt26 $stmt = $db->query(
33 var_dump($stmt->rowCount());
34 var_dump($stmt->nextRowset());
37 var_dump($stmt->rowCount());
38 var_dump($stmt->nextRowset());
41 var_dump($stmt->rowCount());
42 var_dump($stmt->nextRowset());
45 var_dump($stmt->rowCount());
46 var_dump($stmt->nextRowset());
49 var_dump($stmt->rowCount());
[all …]
/PHP-8.3/ext/pdo_firebird/tests/
H A Dbug_48877.phpt26 $stmt = $dbh->prepare($query);
27 $stmt->bindParam(':paramno', $value, PDO::PARAM_STR);
28 $stmt->execute();
29 $rows = $stmt->fetch();
30 var_dump($stmt->fetch());
31 var_dump($stmt->rowCount());
34 $stmt = $dbh->prepare('DELETE FROM testz');
35 $stmt->execute();
41 unset($stmt);
/PHP-8.3/ext/sqlite3/tests/
H A Dbug77051.phpt11 $stmt = $db->prepare('SELECT :a, :b, ?;');
14 $stmt->bindParam(':a', $a, SQLITE3_INTEGER);
15 $stmt->bindValue(':b', 'php');
16 $stmt->bindValue(':b', 'PHP');
17 $stmt->bindValue(3, 424242);
20 var_dump($res = $stmt->execute());
29 var_dump($res = $stmt->execute());
36 $stmt->bindValue(':b', 'TEST');
37 $stmt->bindValue(3, '!!!');
40 var_dump($res = $stmt->execute());
/PHP-8.3/ext/odbc/tests/
H A Dbug46050.phpt11 $stmt = odbc_prepare($conn, "SELECT 1");
12 var_dump(odbc_execute($stmt));
13 var_dump(odbc_fetch_array($stmt));
14 var_dump(odbc_next_result($stmt));
15 var_dump(odbc_execute($stmt));
16 var_dump(odbc_fetch_array($stmt));
/PHP-8.3/ext/pdo/tests/
H A Dpdo_026.phpt50 $stmt->setFetchMode(PDO::FETCH_ASSOC);
51 $stmt->execute();
52 return $stmt;
61 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
62 var_dump(get_class($stmt));
64 $stmt->execute($row);
67 unset($stmt);
69 $stmt = $db->query('SELECT * FROM test');
70 var_dump(get_class($stmt));
71 var_dump(get_class($stmt->dbh));
[all …]

Completed in 36 milliseconds

12345678910>>...20