Home
last modified time | relevance | path

Searched refs:stmt (Results 151 – 175 of 492) sorted by relevance

12345678910>>...20

/PHP-8.3/ext/pdo/tests/
H A Dbug_44173.phpt24 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, []);
25 var_dump($stmt);
33 $stmt = $db->query("SELECT * FROM test", 'abc');
40 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0);
41 var_dump($stmt);
49 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
50 var_dump($stmt);
58 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN);
59 var_dump($stmt);
67 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
[all …]
H A Dbug_39656.phpt25 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?");
26 $stmt->bindValue(1, 1, PDO::PARAM_INT );
27 $stmt->execute();
28 $row = $stmt->fetch();
31 $stmt->execute();
32 $stmt->closeCursor();
33 $row = $stmt->fetch(); // this line will crash CLI
H A Dpdo_028.phpt19 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)');
24 $stmt->bindValue($i+1, $v);
26 $stmt->execute();
28 $stmt = $db->prepare('SELECT * from test');
29 $stmt->execute();
31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-8.3/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_emulated_placeholder_everywhere.phpt28 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?');
29 $stmt->execute(array('test'));
30 if ('00000' !== $stmt->errorCode()) {
32 var_export($stmt->errorCode(), true),
33 var_export($stmt->errorInfo(), true));
35 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
44 $stmt->execute(array('test'));
45 if ('00000' !== $stmt->errorCode())
47 var_export($stmt->errorCode(), true),
48 var_export($stmt->errorInfo(), true));
[all …]
H A Dpdo_mysql_attr_multi_statements.phpt29 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table));
30 $stmt->closeCursor();
33 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
36 $stmt = $db->query('SELECT 1 AS value;');
37 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
44 var_dump($stmt);
48 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
49 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
51 $stmt = $db->query('SELECT 1 AS value;');
[all …]
H A Dpdo_mysql_attr_oracle_nulls.phpt34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
38 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
41 $stmt = $db->query('SELECT VERSION() as _version');
42 $row = $stmt->fetch(PDO::FETCH_ASSOC);
54 $stmt = $db->prepare('CALL p()');
55 $stmt->execute();
57 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
58 } while ($stmt->nextRowset());
60 $stmt->execute();
62 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
[all …]
H A Dbug80458.phpt26 $stmt->execute();
27 var_dump($stmt->fetchAll());
43 $stmt->execute();
44 var_dump($stmt->fetchAll());
67 $stmt->execute();
68 var_dump($stmt->fetchAll());
84 $stmt->execute();
85 var_dump($stmt->fetchAll());
107 $stmt->execute();
108 var_dump($stmt->fetchAll());
[all …]
H A Dpdo_mysql_errorcode.phpt39 $stmt = $db->query('SELECT id, label FROM test');
40 $stmt2 = &$stmt;
42 check_error(4, $stmt);
45 @$stmt->execute();
47 check_error(5, $stmt, '42S02');
51 @$stmt = $db->query('SELECT id, label FROM unknown');
55 $stmt = $db->query('SELECT id, label FROM test');
57 check_error(9, $stmt);
63 check_error(12, $stmt);
71 check_error(16, $stmt);
H A Dchange_column_count.phpt22 $stmt = $db->prepare('INSERT INTO test (id, name) VALUES(:id, :name)');
23 $stmt->execute([
28 $stmt = $db->prepare('SELECT * FROM test WHERE id = :id');
29 $stmt->execute(['id' => 10]);
30 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
33 $stmt->execute(['id' => 10]);
34 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
H A Dpdo_mysql_stmt_errorinfo.phpt24 var_dump($stmt->errorInfo());
25 $stmt->execute();
26 var_dump($stmt->errorInfo());
29 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
31 var_dump($stmt->execute());
32 var_dump($stmt->errorInfo());
47 var_dump($stmt);
50 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
51 var_dump($stmt->errorInfo());
53 $stmt->execute();
[all …]
H A Dbug_45120.phpt20 $stmt = $db->prepare("SELECT 1 AS 'one'");
21 if (true !== $stmt->execute())
22 printf("[001] Execute has failed: %s\n", var_export($stmt->errorInfo(), true));
24 $res = $stmt->fetch(PDO::FETCH_ASSOC);
28 if (true !== $stmt->execute())
29 printf("[003] Execute has failed: %s\n", var_export($stmt->errorInfo(), true));
31 $res = $stmt->fetch(PDO::FETCH_ASSOC);
/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_stmt_bind_limits.phpt41 …$stmt_bind_param = 'return mysqli_stmt_bind_param($stmt, "' . $stmt_types . '", ' . $stmt_params .…
51 if (!$stmt = $link->prepare($insert)) {
55 if ($stmt->param_count != $num_params * $rows) {
59 printf("... statement with %d parameters prepared\n", $stmt->param_count);
63 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error);
72 if (!call_user_func_array(array($stmt, 'bind_param'), $param_ref)) {
73 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error);
77 if ($stmt->param_count != $num_params * $rows) {
82 if (!$stmt->execute()) {
83 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 …]
H A Dmysqli_explain_metadata.phpt62 $stmt = mysqli_stmt_init($link);
64 … if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) {
65 if (!mysqli_stmt_store_result($stmt))
66 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
68 if (!$res_meta = mysqli_stmt_result_metadata($stmt))
69 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
100 $stmt->execute()) {
101 if (!$res_stmt = mysqli_stmt_get_result($stmt)) {
103 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
109 if ((mysqli_stmt_num_rows($stmt)) !== 0) {
[all …]
H A D067.phpt22 if (!is_object($stmt = $mysql->prepare($query))) {
27 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
28 return $stmt;
45 $stmt[$i] = open_cursor($mysql, "SELECT a FROM cursor$i");
46 $stmt[$i]->execute();
47 $stmt[$i]->bind_result($a[$i]);
52 while ($stmt[0]->fetch()) {
53 $stmt[1]->fetch();
54 $stmt[2]->fetch();
59 $stmt[$i]->close();
H A D020.phpt40 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_result VALUES (?,?,?,?,?,?,?)");
41 mysqli_stmt_bind_param($stmt, "sssssss", $d1, $d2, $d3, $d4, $d5, $d6, $d7);
51 mysqli_stmt_execute($stmt);
52 mysqli_stmt_close($stmt);
54 $stmt = mysqli_prepare($link, "SELECT c1, c2, c3, c4, c5, c6, c7 FROM test_bind_result");
56 mysqli_stmt_bind_result($stmt,$c1, $c2, $c3, $c4, $c5, $c6, $c7);
58 mysqli_stmt_execute($stmt);
59 mysqli_stmt_fetch($stmt);
65 mysqli_stmt_close($stmt);
H A D025.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);
46 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
47 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7);
48 mysqli_stmt_execute($stmt);
49 mysqli_stmt_fetch($stmt);
55 mysqli_stmt_close($stmt);
H A Dbug70949.phpt20 if ($stmt = $mysql->prepare($sql))
22 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
24 if ($stmt->bind_result($name)) {
26 if ($stmt->execute())
28 while ($stmt->fetch())
35 $stmt->free_result();
36 $stmt->close();
H A D016.phpt19 if (!$stmt = mysqli_prepare($link, "SELECT @dummy"))
22 mysqli_stmt_bind_result($stmt, $dummy);
23 mysqli_stmt_execute($stmt);
24 mysqli_stmt_fetch($stmt);
28 mysqli_stmt_close($stmt);
/PHP-8.3/ext/pdo_oci/tests/
H A Dbug57702.phpt21 $stmt = $db->prepare($query);
22 $stmt->execute();
25 $stmt = $db->prepare($query);
26 $stmt->execute();
32 $stmt->bindParam(':id', $id);
37 $stmt->execute();
55 $stmt->execute();
56 $row = $stmt->fetch(PDO::FETCH_ASSOC);
78 $rs = $stmt->execute();
145 $stmt = $db->prepare($query);
[all …]
/PHP-8.3/ext/sqlite3/tests/
H A Dbug63921-32bit.phpt15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
16 $stmt->bindValue(':id', 1, SQLITE3_INTEGER);
17 $stmt->bindValue(':num', $num, SQLITE3_INTEGER);
18 $stmt->execute();
20 $stmt = $conn->query('SELECT num FROM users');
21 $result = $stmt->fetchArray();
H A Dbug63921-64bit.phpt15 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
16 $stmt->bindValue(':id', 1, SQLITE3_INTEGER);
17 $stmt->bindValue(':num', $num, SQLITE3_INTEGER);
18 $stmt->execute();
20 $stmt = $conn->query('SELECT num FROM users');
21 $result = $stmt->fetchArray();
/PHP-8.3/ext/pdo_pgsql/tests/
H A Ddebug_emulated_prepares.phpt18 $stmt = $db->prepare('SELECT :bool, :int, :string, :null');
19 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL);
20 $stmt->bindValue(':int', 123, PDO::PARAM_INT);
21 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR);
22 $stmt->bindValue(':null', null, PDO::PARAM_NULL);
23 $stmt->execute();
25 var_dump($stmt->debugDumpParams());
H A Dbug46274.phpt26 $stmt = $db->prepare("INSERT INTO test_one_blob_46274_1 (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();
/PHP-8.3/ext/oci8/tests/
H A Ddefine1.phpt26 $stmt = oci_parse($c, "select string from define1_tab");
31 var_dump(oci_define_by_name($stmt, "STRING", $string, 20));
32 var_dump(oci_define_by_name($stmt, "STRING", $string, 20));
34 var_dump(oci_define_by_name($stmt, "", $string, 20));
39 oci_execute($stmt);
41 while (oci_fetch($stmt)) {

Completed in 41 milliseconds

12345678910>>...20