Home
last modified time | relevance | path

Searched refs:stmt (Results 126 – 150 of 467) sorted by relevance

12345678910>>...19

/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_fetch_bit.phpt33 if (!$stmt = mysqli_stmt_init($link))
41 if (!mysqli_stmt_prepare($stmt, $sql) ||
42 !mysqli_stmt_execute($stmt))
43 … printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 if (!mysqli_stmt_prepare($stmt, $sql) ||
48 !mysqli_stmt_execute($stmt) ||
49 !mysqli_stmt_bind_result($stmt, $id, $_label0, $label))
50 … printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
52 if (!mysqli_stmt_fetch($stmt))
53 … printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dbug35103.phpt26 $stmt = $mysql->prepare("SELECT a FROM test_bint ORDER BY a");
27 $stmt->bind_result($v);
28 $stmt->execute();
32 $stmt->fetch();
35 $stmt->close();
39 $stmt = $mysql->prepare("SELECT a FROM test_buint ORDER BY a");
40 $stmt->bind_result($v2);
41 $stmt->execute();
45 $stmt->fetch();
48 $stmt->close();
H A Dmysqli_stmt_bind_result_format.phpt67 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
74 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
81 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
91 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
98 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
116 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
138 mysqli_stmt_close($stmt);
284 mysqli_stmt_close($stmt);
297 if (!$stmt->execute()) {
323 $stmt->free_result();
[all …]
H A D023.phpt27 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)");
28 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7);
37 mysqli_stmt_execute($stmt);
38 mysqli_stmt_close($stmt);
40 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
41 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7);
42 mysqli_stmt_execute($stmt);
43 mysqli_stmt_fetch($stmt);
49 mysqli_stmt_close($stmt);
H A D024.phpt27 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)");
28 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7);
38 mysqli_stmt_execute($stmt);
39 mysqli_stmt_close($stmt);
41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7);
43 mysqli_stmt_execute($stmt);
44 mysqli_stmt_fetch($stmt);
50 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_bind_limits.phpt38 …$stmt_bind_param = 'return mysqli_stmt_bind_param($stmt, "' . $stmt_types . '", ' . $stmt_params .…
48 if (!$stmt = $link->prepare($insert)) {
52 if ($stmt->param_count != $num_params * $rows) {
56 printf("... statement with %d parameters prepared\n", $stmt->param_count);
60 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error);
69 if (!call_user_func_array(array($stmt, 'bind_param'), $param_ref)) {
70 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error);
74 if ($stmt->param_count != $num_params * $rows) {
79 if (!$stmt->execute()) {
80 printf("[%03d + 04] [%d] %s\n", $offset, $stmt->errno, $stmt->error);
[all …]
H A Dmysqli_stmt_bind_param_type_juggling.phpt27 if (!$stmt = mysqli_stmt_init($link)) {
32 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(col1, col2) VALUES (?, ?)")) {
33 … printf("[%03d + 4] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
37 if (!mysqli_stmt_bind_param($stmt, $bind_type1 . $bind_type2, $bind_value1, $bind_value1)) {
38 … printf("[%03d + 5] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_execute($stmt)) {
43 … printf("[%03d + 6] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
48 … printf("[%03d + 7] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 if (!mysqli_stmt_execute($stmt)) {
52 … printf("[%03d + 8] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
/PHP-7.4/ext/pdo_oci/tests/
H A Dpdo_oci_attr_action.phpt18 $stmt = $dbh->query($query);
19 $row = $stmt->fetch();
25 $stmt = $dbh->query($query);
26 $row = $stmt->fetch();
32 $stmt = $dbh->query($query);
33 $row = $stmt->fetch();
39 $stmt = $dbh->query($query);
40 $row = $stmt->fetch();
H A Dpdo_oci_attr_client_info.phpt18 $stmt = $dbh->query($query);
19 $row = $stmt->fetch();
25 $stmt = $dbh->query($query);
26 $row = $stmt->fetch();
32 $stmt = $dbh->query($query);
33 $row = $stmt->fetch();
39 $stmt = $dbh->query($query);
40 $row = $stmt->fetch();
H A Dpdo_oci_attr_client_identifier.phpt18 $stmt = $dbh->query($query);
19 $row = $stmt->fetch();
25 $stmt = $dbh->query($query);
26 $row = $stmt->fetch();
32 $stmt = $dbh->query($query);
33 $row = $stmt->fetch();
39 $stmt = $dbh->query($query);
40 $row = $stmt->fetch();
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_emulated.phpt20 $stmt = @$db->prepare($query);
22 $stmt = $db->prepare($query);
48 $ret = @$stmt->execute($input_params);
50 $ret = $stmt->execute($input_params);
57 $tmp = $stmt->errorInfo();
83 return $stmt;
96 $stmt = prepex(4, $db, 'SELECT 1 as "one"');
97 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
293 $stmt = prepex(79, $db, $sql, array(-1));
300 $stmt = prepex(81, $db, $sql, array(1));
[all …]
H A Dbug_pecl_12925.phpt21 $stmt = $db->prepare("UPDATE test SET id = 'b'");
22 $stmt->execute();
23 $stmt = $db->prepare("UPDATE test SET id = 'c'");
24 $stmt->execute();
25 $stmt = $db->prepare('SELECT id FROM test');
26 $stmt->execute();
27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
28 $stmt->closeCursor();
H A Dpdo_mysql_stmt_columncount.phpt25 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test");
26 $stmt->execute();
27 var_dump($stmt->columnCount());
29 $stmt = $db->query('SELECT * FROM test');
30 var_dump($stmt->columnCount());
43 $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test");
44 $stmt->execute();
45 var_dump($stmt->columnCount());
47 $stmt = $db->query('SELECT * FROM test');
48 var_dump($stmt->columnCount());
H A Dpdo_mysql_prepare_native_placeholder_everywhere.phpt23 $stmt = $db->prepare('SELECT ?, id, label FROM test WHERE ? = ? ORDER BY id ASC');
24 $stmt->execute(array('id', 'label', 'label'));
25 if ('00000' !== $stmt->errorCode())
27 var_export($stmt->errorCode(), true),
28 var_export($stmt->errorInfo(), true));
29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
38 $stmt->execute(array('id', 'label', 'label'));
39 if ('00000' !== $stmt->errorCode())
41 var_export($stmt->errorCode(), true),
42 var_export($stmt->errorInfo(), true));
[all …]
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dbug_63916.phpt14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
15 $stmt->bindValue(':id', 1, PDO::PARAM_INT);
16 $stmt->bindValue(':num', $num, PDO::PARAM_INT);
17 $stmt->execute();
19 $stmt = $conn->query('SELECT num FROM users');
20 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
H A Dbug_63916-2.phpt14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
15 $stmt->bindValue(':id', 1, PDO::PARAM_INT);
16 $stmt->bindValue(':num', $num, PDO::PARAM_INT);
17 $stmt->execute();
19 $stmt = $conn->query('SELECT num FROM users');
20 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
/PHP-7.4/ext/pdo/tests/
H A Dpdo_038.phpt16 function fetchColumn($stmt, $index) {
17 $stmt->execute();
18 return $stmt->fetchColumn($index);
33 $stmt = $conn->prepare($query);
35 var_dump(fetchColumn($stmt, -1));
36 var_dump(fetchColumn($stmt, 0));
37 var_dump(fetchColumn($stmt, 1));
H A Dpdo_012.phpt23 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
24 var_dump($stmt->fetchAll());
34 unset($stmt);
36 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test');
37 var_dump($stmt->fetchAll());
39 unset($stmt);
41 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
42 $stmt->setFetchMode(PDO::FETCH_CLASS, 'Test', array('Changed'));
43 var_dump($stmt->fetchAll());
H A Ddebug_emulated_prepares.phpt23 $stmt = $db->query('SELECT 1');
26 var_dump($stmt->debugDumpParams());
28 $stmt = $db->prepare('SELECT :bool, :int, :string, :null');
29 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL);
30 $stmt->bindValue(':int', 123, PDO::PARAM_INT);
31 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR);
32 $stmt->bindValue(':null', null, PDO::PARAM_NULL);
33 $stmt->execute();
36 var_dump($stmt->debugDumpParams());
/PHP-7.4/ext/oci8/tests/
H A Ddefine1.phpt22 $stmt = oci_parse($c, "select string from define1_tab");
27 var_dump(oci_define_by_name($stmt, "STRING", $string, 20));
28 var_dump(oci_define_by_name($stmt, "STRING", $string, 20));
29 var_dump(oci_define_by_name($stmt, "", $string, 20));
30 var_dump(oci_define_by_name($stmt, ""));
32 oci_execute($stmt);
34 while (oci_fetch($stmt)) {
/PHP-7.4/ext/pdo/
H A Dpdo_sql_parser.re155 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "mixed named and positional parameters");
160 if (stmt->supports_placeholders == query_type && !stmt->named_rewrite_template) {
180 params = stmt->bound_params;
226 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined");
229 if (stmt->dbh->methods->quoter) {
247 … if (!stmt->dbh->methods->quoter(stmt->dbh, ZSTR_VAL(buf), ZSTR_LEN(buf), &plc->quoted, &plc->qlen,
251 strncpy(stmt->error_code, stmt->dbh->error_code, 6);
261 pdo_raise_impl_error(stmt->dbh, stmt, "HY105", "Expected a stream resource");
299 !stmt->dbh->methods->quoter(stmt->dbh, ZSTR_VAL(buf),
304 strncpy(stmt->error_code, stmt->dbh->error_code, 6);
[all …]
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug46274.phpt24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)");
31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
32 $stmt->execute();
35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
36 $stmt->execute();
43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
44 $stmt->execute();
47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
48 $stmt->execute();
H A Ddebug_emulated_prepares.phpt16 $stmt = $db->prepare('SELECT :bool, :int, :string, :null');
17 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL);
18 $stmt->bindValue(':int', 123, PDO::PARAM_INT);
19 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR);
20 $stmt->bindValue(':null', null, PDO::PARAM_NULL);
21 $stmt->execute();
23 var_dump($stmt->debugDumpParams());
/PHP-7.4/ext/sqlite3/tests/
H A Dbug63921-64bit.phpt14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
15 $stmt->bindValue(':id', 1, SQLITE3_INTEGER);
16 $stmt->bindValue(':num', $num, SQLITE3_INTEGER);
17 $stmt->execute();
19 $stmt = $conn->query('SELECT num FROM users');
20 $result = $stmt->fetchArray();
H A Dsqlite3stmt_getsql.phpt12 $stmt = $db->prepare('SELECT :a, :b, ?;');
14 $stmt->bindValue(':a', 42);
15 $stmt->bindValue(':b', 'php');
16 $stmt->bindValue(3, 43);
19 var_dump($stmt->getSQL(false));
22 var_dump($res = $stmt->execute());

Completed in 58 milliseconds

12345678910>>...19