Home
last modified time | relevance | path

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

12345678910>>...19

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_native.phpt20 $stmt = @$db->prepare($query);
22 $stmt = $db->prepare($query);
44 if (!is_object($stmt))
52 $ret = @$stmt->execute($input_params);
54 $ret = $stmt->execute($input_params);
60 $tmp = $stmt->errorInfo();
94 return $stmt;
115 $row = $stmt->fetch(PDO::FETCH_ASSOC);
168 if (is_object($stmt)) {
237 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
[all …]
H A Dbug41125.phpt19 $stmt = $db->prepare($sql);
20 $stmt->execute();
22 print implode(' - ', $stmt->errorinfo()) ."\n";
34 $stmt = $db->prepare($query);
35 $stmt->execute(array(1));
44 $stmt = $db->prepare($sql);
47 $stmt->bindParam(':id', $id);
48 $stmt->execute();
75 $stmt = $db->prepare($query);
76 $stmt->bindParam(':id', $id);
[all …]
H A Dbug80458.phpt24 $stmt->execute();
25 var_dump($stmt->fetchAll());
41 $stmt->execute();
42 var_dump($stmt->fetchAll());
65 $stmt->execute();
66 var_dump($stmt->fetchAll());
82 $stmt->execute();
83 var_dump($stmt->fetchAll());
105 $stmt->execute();
106 var_dump($stmt->fetchAll());
[all …]
H A Dpdo_mysql_errorcode.phpt38 $stmt = $db->query('SELECT id, label FROM test');
39 $stmt2 = &$stmt;
41 check_error(4, $stmt);
44 @$stmt->execute();
46 check_error(5, $stmt, '42S02');
50 @$stmt = $db->query('SELECT id, label FROM unknown');
54 $stmt = $db->query('SELECT id, label FROM test');
56 check_error(9, $stmt);
62 check_error(12, $stmt);
70 check_error(16, $stmt);
H A Dpdo_mysql_stmt_errorinfo.phpt23 var_dump($stmt->errorInfo());
24 $stmt->execute();
25 var_dump($stmt->errorInfo());
28 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
30 var_dump($stmt->execute());
31 var_dump($stmt->errorInfo());
46 var_dump($stmt);
49 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
50 var_dump($stmt->errorInfo());
52 $stmt->execute();
[all …]
H A Dpdo_mysql_prepare_emulated_placeholder_everywhere.phpt27 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?');
28 $stmt->execute(array('test'));
29 if ('00000' !== $stmt->errorCode()) {
31 var_export($stmt->errorCode(), true),
32 var_export($stmt->errorInfo(), true));
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
43 $stmt->execute(array('test'));
44 if ('00000' !== $stmt->errorCode())
46 var_export($stmt->errorCode(), true),
47 var_export($stmt->errorInfo(), true));
[all …]
/PHP-7.4/ext/pdo_oci/tests/
H A Dbug57702.phpt19 $stmt = $db->prepare($query);
20 $stmt->execute();
23 $stmt = $db->prepare($query);
24 $stmt->execute();
30 $stmt->bindParam(':id', $id);
35 $stmt->execute();
53 $stmt->execute();
54 $row = $stmt->fetch(PDO::FETCH_ASSOC);
76 $rs = $stmt->execute();
143 $stmt = $db->prepare($query);
[all …]
/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_bind_param.phpt38 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
90 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
92 mysqli_stmt_close($stmt);
312 printf("[2000] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
317 printf("[2001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
322 printf("[2002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
337 $stmt->errno, $stmt->error);
340 if (!$stmt->execute())
341 printf("[2006] [%d] %s\n", $stmt->errno, $stmt->error);
362 $values['id'], mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A D016.phpt18 if (!$stmt = mysqli_prepare($link, "SELECT @dummy"))
21 mysqli_stmt_bind_result($stmt, $dummy);
22 mysqli_stmt_execute($stmt);
23 mysqli_stmt_fetch($stmt);
27 mysqli_stmt_close($stmt);
H A D020.phpt39 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_result VALUES (?,?,?,?,?,?,?)");
40 mysqli_stmt_bind_param($stmt, "sssssss", $d1, $d2, $d3, $d4, $d5, $d6, $d7);
50 mysqli_stmt_execute($stmt);
51 mysqli_stmt_close($stmt);
53 $stmt = mysqli_prepare($link, "SELECT c1, c2, c3, c4, c5, c6, c7 FROM test_bind_result");
55 mysqli_stmt_bind_result($stmt,$c1, $c2, $c3, $c4, $c5, $c6, $c7);
57 mysqli_stmt_execute($stmt);
58 mysqli_stmt_fetch($stmt);
64 mysqli_stmt_close($stmt);
H A D025.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);
45 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
46 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7);
47 mysqli_stmt_execute($stmt);
48 mysqli_stmt_fetch($stmt);
54 mysqli_stmt_close($stmt);
H A D067.phpt23 if (!is_object($stmt = $mysql->prepare($query))) {
28 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
29 return $stmt;
47 $stmt[$i] = open_cursor($mysql, "SELECT a FROM cursor$i");
48 $stmt[$i]->execute();
49 $stmt[$i]->bind_result($a[$i]);
54 while ($stmt[0]->fetch()) {
55 $stmt[1]->fetch();
56 $stmt[2]->fetch();
61 $stmt[$i]->close();
H A Dmysqli_explain_metadata.phpt66 $stmt = mysqli_stmt_init($link);
68 … if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) {
69 if (!mysqli_stmt_store_result($stmt))
70 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
72 if (!$res_meta = mysqli_stmt_result_metadata($stmt))
73 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104 $stmt->execute()) {
105 if (!$res_stmt = mysqli_stmt_get_result($stmt)) {
107 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
113 if ((mysqli_stmt_num_rows($stmt)) !== 0) {
[all …]
H A Dbug70949.phpt23 if ($stmt = $mysql->prepare($sql))
25 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
27 if ($stmt->bind_result($name)) {
29 if ($stmt->execute())
31 while ($stmt->fetch())
38 $stmt->free_result();
39 $stmt->close();
H A Dbug33263.phpt23 $stmt = $mysql->prepare("SELECT DATABASE()");
24 $stmt->execute();
25 $stmt->bind_result($database);
26 $stmt->fetch();
27 $stmt->close();
H A D017.phpt16 if (!$stmt = mysqli_prepare($link, "SELECT md5('bar'), database(), 'foo'"))
19 mysqli_stmt_bind_result($stmt, $c0, $c1, $c2);
20 mysqli_stmt_execute($stmt);
22 mysqli_stmt_fetch($stmt);
23 mysqli_stmt_close($stmt);
/PHP-7.4/ext/sqlite3/tests/
H A Dbug63921-32bit.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 Dsqlite3_28_clear_bindings.phpt19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
22 var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT));
24 $results = $stmt->execute();
28 $stmt->reset();
29 $stmt->clear();
30 var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT));
31 $results = $stmt->execute();
/PHP-7.4/ext/mysqlnd/
H A Dmysqlnd_ps_codec.c620 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_prepare_param_types()
720 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()
733 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_calculate_param_values_size()
871 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_store_params() local
884 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params()
908 if (stmt->send_types_to_server) { in mysqlnd_stmt_execute_store_params()
910 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params()
926 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params()
947 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_generate_request() local
955 int4store(p, stmt->stmt_id); in mysqlnd_stmt_execute_generate_request()
[all …]
/PHP-7.4/ext/pdo/tests/
H A Dpdo_032.phpt24 $stmt = $db->prepare('SELECT * from test');
25 $stmt->execute();
26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
27 $stmt->closeCursor();
31 $stmt = $db->prepare('SELECT * from test');
32 $stmt->execute();
33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
34 $stmt->closeCursor();
H A Dbug_39656.phpt24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?");
25 $stmt->bindValue(1, 1, PDO::PARAM_INT );
26 $stmt->execute();
27 $row = $stmt->fetch();
30 $stmt->execute();
31 $stmt->closeCursor();
32 $row = $stmt->fetch(); // this line will crash CLI
H A Dpdo_028.phpt18 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)');
23 $stmt->bindValue($i+1, $v);
25 $stmt->execute();
27 $stmt = $db->prepare('SELECT * from test');
28 $stmt->execute();
30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_019.phpt26 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
28 $stmt->execute();
29 $cont = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE);
34 $stmt->bindColumn('idx', $idx);
35 $stmt->bindColumn('txt', $txt);
36 $stmt->execute();
38 while($stmt->fetch(PDO::FETCH_BOUND)) {
/PHP-7.4/ext/oci8/tests/
H A Dbug42841.phpt50 $stmt = oci_parse($c, $sql);
52 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR);
54 oci_execute($stmt, OCI_DEFAULT);
61 oci_free_statement($stmt);
68 $stmt = oci_parse($c, $sql);
70 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR);
72 oci_execute($stmt, OCI_DEFAULT);
79 oci_free_statement($stmt);
96 oci_bind_by_name($stmt, ':cur', $cur, -1, OCI_B_CURSOR);
97 oci_execute($stmt, OCI_DEFAULT);
[all …]
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug46274_2.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();

Completed in 38 milliseconds

12345678910>>...19