Home
last modified time | relevance | path

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

12345678910>>...20

/PHP-8.1/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();
H A Dpdo_oci_attr_client_identifier.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();
H A Dpdo_oci_attr_client_info.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();
/PHP-8.1/ext/pdo_mysql/tests/
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 …]
H A Dpdo_mysql_attr_fetch_table_names.phpt17 $stmt = $db->query('SELECT label FROM test LIMIT 1');
18 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
19 $stmt->closeCursor();
22 $stmt = $db->query('SELECT label FROM test LIMIT 1');
23 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
24 $stmt->closeCursor();
H A Dbug_pecl_12925.phpt22 $stmt = $db->prepare("UPDATE test SET id = 'b'");
23 $stmt->execute();
24 $stmt = $db->prepare("UPDATE test SET id = 'c'");
25 $stmt->execute();
26 $stmt = $db->prepare('SELECT id FROM test');
27 $stmt->execute();
28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
29 $stmt->closeCursor();
H A Dpdo_mysql_prepare_native_placeholder_everywhere.phpt26 $stmt = $db->prepare('SELECT ?, id, label FROM test WHERE ? = ? ORDER BY id ASC');
27 $stmt->execute(array('id', 'label', 'label'));
28 if ('00000' !== $stmt->errorCode())
30 var_export($stmt->errorCode(), true),
31 var_export($stmt->errorInfo(), true));
32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
41 $stmt->execute(array('id', 'label', 'label'));
42 if ('00000' !== $stmt->errorCode())
44 var_export($stmt->errorCode(), true),
45 var_export($stmt->errorInfo(), true));
[all …]
/PHP-8.1/ext/mysqli/tests/
H A Dmysqli_stmt_execute_stored_proc_out.phpt34 if (!$stmt = mysqli_prepare($link, 'CALL p(?, ?)'))
39 if (!mysqli_stmt_bind_param($stmt, 'ss', $ver_in, $ver_out))
40 …intf("[006] Cannot bind parameter, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_execute($stmt))
43 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 if (!mysqli_stmt_bind_result($stmt, $ver_out) || !mysqli_stmt_fetch($stmt))
50 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
58 if (!mysqli_stmt_close($stmt))
59 …ntf("[012] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
H A Dbug35103.phpt27 $stmt = $mysql->prepare("SELECT a FROM test_bint ORDER BY a");
28 $stmt->bind_result($v);
29 $stmt->execute();
33 $stmt->fetch();
36 $stmt->close();
40 $stmt = $mysql->prepare("SELECT a FROM test_buint ORDER BY a");
41 $stmt->bind_result($v2);
42 $stmt->execute();
46 $stmt->fetch();
49 $stmt->close();
H A D063.phpt15 $stmt = new mysqli_stmt($mysql, "SELECT 'foo' FROM DUAL");
16 $stmt->execute();
17 $stmt->bind_result($foo);
18 $stmt->fetch();
19 $stmt->close();
25 $stmt = new mysqli_stmt($mysql, "SELECT invalid FROM DUAL");
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 Dmysqli_stmt_bind_param.phpt26 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
118 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
120 mysqli_stmt_close($stmt);
340 printf("[2000] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
345 printf("[2001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
350 printf("[2002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
365 $stmt->errno, $stmt->error);
368 if (!$stmt->execute())
369 printf("[2006] [%d] %s\n", $stmt->errno, $stmt->error);
390 $values['id'], mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A D023.phpt28 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)");
29 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 D024.phpt28 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)");
29 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7);
39 mysqli_stmt_execute($stmt);
40 mysqli_stmt_close($stmt);
42 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
43 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7);
44 mysqli_stmt_execute($stmt);
45 mysqli_stmt_fetch($stmt);
51 mysqli_stmt_close($stmt);
/PHP-8.1/ext/oci8/tests/
H A Dstatement_cache.phpt19 $stmt = oci_parse($pc, "select 1+3 from dual");
20 oci_execute($stmt);
21 var_dump(oci_fetch_array($stmt));
23 $stmt = oci_parse($pc, "select 1+3 from dual");
24 oci_execute($stmt);
25 var_dump(oci_fetch_array($stmt));
/PHP-8.1/ext/mysqlnd/
H A Dmysqlnd_ps_codec.c551 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_prepare_param_types()
651 if (Z_ISREF(stmt->param_bind[j].zv) && Z_REFVAL(stmt->param_bind[j].zv) == the_var) { in mysqlnd_stmt_execute_calculate_param_values_size()
664 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_calculate_param_values_size()
802 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_store_params() local
815 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params()
839 if (stmt->send_types_to_server) { in mysqlnd_stmt_execute_store_params()
841 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params()
857 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params()
878 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_generate_request() local
886 int4store(p, stmt->stmt_id); in mysqlnd_stmt_execute_generate_request()
[all …]
/PHP-8.1/ext/pdo/tests/
H A Dpdo_038.phpt17 function fetchColumn($stmt, $index) {
18 $stmt->execute();
19 return $stmt->fetchColumn($index);
34 $stmt = $conn->prepare($query);
37 var_dump(fetchColumn($stmt, -1));
41 var_dump(fetchColumn($stmt, 0));
43 var_dump(fetchColumn($stmt, 1));
H A Dpdo_032.phpt25 $stmt = $db->prepare('SELECT * from test');
26 $stmt->execute();
27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
28 $stmt->closeCursor();
32 $stmt = $db->prepare('SELECT * from test');
33 $stmt->execute();
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
35 $stmt->closeCursor();
H A Dgh8626.phpt27 $stmt = $db->prepare('INSERT INTO test VALUES(?)');
30 var_dump($stmt->execute([null]), $stmt->errorCode());
31 $errorInfo = $stmt->errorInfo();
34 $stmt->closeCursor(); // sqlite
37 var_dump($stmt->execute([1]), $stmt->errorCode());
38 $errorInfo = $stmt->errorInfo();
H A Ddebug_emulated_prepares.phpt24 $stmt = $db->query('SELECT 1');
27 var_dump($stmt->debugDumpParams());
29 $stmt = $db->prepare('SELECT :bool, :int, :string, :null');
30 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL);
31 $stmt->bindValue(':int', 123, PDO::PARAM_INT);
32 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR);
33 $stmt->bindValue(':null', null, PDO::PARAM_NULL);
34 $stmt->execute();
37 var_dump($stmt->debugDumpParams());
/PHP-8.1/ext/pdo/
H A Dpdo_sql_parser.re142 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "mixed named and positional parameters");
147 params = stmt->bound_params;
172 if (stmt->supports_placeholders == query_type && !stmt->named_rewrite_template) {
218 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined");
221 if (stmt->dbh->methods->quoter) {
240 plc->quoted = stmt->dbh->methods->quoter(stmt->dbh, buf, param->param_type);
248 strncpy(stmt->error_code, stmt->dbh->error_code, 6);
253 pdo_raise_impl_error(stmt->dbh, stmt, "HY105", "Expected a stream resource");
285 strncpy(stmt->error_code, stmt->dbh->error_code, 6);
289 plc->quoted = stmt->dbh->methods->quoter(stmt->dbh, buf, param_type);
[all …]
/PHP-8.1/ext/sqlite3/tests/
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());
/PHP-8.1/ext/pdo_sqlite/tests/
H A Dbug_63916-2.phpt15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
16 $stmt->bindValue(':id', 1, PDO::PARAM_INT);
17 $stmt->bindValue(':num', $num, PDO::PARAM_INT);
18 $stmt->execute();
20 $stmt = $conn->query('SELECT num FROM users');
21 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
H A Dbug_63916.phpt15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
16 $stmt->bindValue(':id', 1, PDO::PARAM_INT);
17 $stmt->bindValue(':num', $num, PDO::PARAM_INT);
18 $stmt->execute();
20 $stmt = $conn->query('SELECT num FROM users');
21 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
/PHP-8.1/ext/pdo_pgsql/tests/
H A Dbug46274.phpt26 $stmt = $db->prepare("INSERT INTO test_one_blob (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();

Completed in 34 milliseconds

12345678910>>...20