Home
last modified time | relevance | path

Searched refs:stmt (Results 201 – 225 of 492) sorted by relevance

12345678910>>...20

/PHP-8.3/ext/pdo_oci/tests/
H A Dbug46274.phpt28 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl…
36 $stmt->bindparam(':id', $id);
37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
38 $stmt->execute();
46 $stmt->bindparam(':id', $id);
47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
48 $stmt->execute();
H A Dbug46274_2.phpt28 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl…
36 $stmt->bindparam(':id', $id);
37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
38 $stmt->execute();
46 $stmt->bindparam(':id', $id);
47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
48 $stmt->execute();
/PHP-8.3/ext/pdo_mysql/tests/
H A Dbug_41997.phpt30 $stmt = $db->query("CALL p()");
32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
33 } while ($stmt->nextRowset());
34 var_dump($stmt->errorInfo());
36 $stmt = $db->query('SELECT 2 AS "two"');
37 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
38 var_dump($stmt->errorInfo());
H A Dpdo_mysql_types_zerofill.phpt25 $stmt->bindValue(1, $offset);
26 $stmt->bindValue(2, $value);
28 if (!$stmt->execute()) {
39 $stmt = $db->query('SELECT id, label FROM test');
40 $row = $stmt->fetch(PDO::FETCH_ASSOC);
41 $stmt->closeCursor();
80 $row_string = $stmt->fetch(PDO::FETCH_ASSOC);
81 $stmt->closeCursor();
95 $stmt = $db->prepare('SELECT @@sql_mode AS _mode');
96 $stmt->execute();
[all …]
H A Dpdo_mysql_fetch_both.phpt19 $stmt = $db->query('SELECT 1');
20 $num = $stmt->fetch(PDO::FETCH_NUM);
22 $stmt = $db->query('SELECT 1');
23 $assoc = $stmt->fetch(PDO::FETCH_ASSOC);
25 $stmt = $db->query('SELECT 1');
26 $both = $stmt->fetch(PDO::FETCH_BOTH);
H A Dbug41125.phpt20 $stmt = $db->prepare($sql);
21 $stmt->execute();
23 print implode(' - ', $stmt->errorinfo()) ."\n";
35 $stmt = $db->prepare($query);
36 $stmt->execute(array(1));
45 $stmt = $db->prepare($sql);
48 $stmt->bindParam(':id', $id);
49 $stmt->execute();
76 $stmt = $db->prepare($query);
77 $stmt->bindParam(':id', $id);
[all …]
H A Dpdo_mysql_stmt_bindparam_types.phpt26 if ((!$stmt = @$db->prepare($sql)) || (!@$stmt->execute()))
31 if (!$stmt->bindParam(1, $value)) {
33 var_export($stmt->errorInfo(), true));
36 if (!$stmt->execute()) {
38 var_export($stmt->errorInfo(), true));
44 if (!$stmt->bindColumn(1, $id)) {
49 if (!$stmt->bindColumn(2, $label)) {
55 if (!$stmt->fetch(PDO::FETCH_BOUND)) {
60 $stmt->closeCursor();
69 $stmt->execute();
[all …]
H A Dpdo_mysql_stmt_getcolumnmeta.phpt12 $row = $stmt->fetch(PDO::FETCH_ASSOC);
33 $stmt->execute();
37 $stmt->getColumnMeta(-1);
50 $stmt->execute();
67 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) {
79 $stmt->execute();
85 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
138 $stmt->execute();
230 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
251 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
[all …]
H A Dpdo_mysql_stmt_nextrowset.phpt31 $stmt = $db->query('SELECT id FROM test');
38 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
40 while ($stmt->fetch()) ;
47 var_dump($stmt->nextRowSet());
55 $stmt = $db->query('CALL p()');
58 } while ($stmt->nextRowSet());
59 var_dump($stmt->nextRowSet());
62 unset($stmt);
63 $stmt = $db->query('CALL p()');
64 var_dump($stmt->nextRowSet());
[all …]
/PHP-8.3/ext/oci8/tests/
H A Dbug37220.phpt32 $stmt = oci_parse ($c, $query);
34 oci_bind_by_name($stmt, ':data', $clob, -1, OCI_B_CLOB);
36 $success = oci_execute($stmt, OCI_COMMIT_ON_SUCCESS);
37 oci_free_statement($stmt);
43 $stmt = oci_parse ($c, $query);
45 oci_execute($stmt);
47 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
H A Dbug71600.phpt33 $stmt = oci_parse($c, $sql);
36 oci_execute($stmt,OCI_DEFAULT);
39 oci_fetch_all($stmt, $result);
40 oci_free_statement($stmt);
54 $stmt = oci_parse($c, $sql);
57 oci_execute($stmt,OCI_DEFAULT);
60 oci_fetch_all($stmt, $result, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
61 oci_free_statement($stmt);
/PHP-8.3/ext/pdo/tests/
H A Dbug_65946.phpt38 $stmt = $db->prepare($sql);
39 $stmt->bindValue('limit', 1, PDO::PARAM_INT);
40 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
41 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
42 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-8.3/ext/pdo_pgsql/tests/
H A Dbug43925.phpt33 $stmt = $dbh->prepare('
43 $stmt->bindValue('left', 1, PDO::PARAM_INT);
44 $stmt->bindValue('rootId', 3, PDO::PARAM_INT);
45 $stmt->bindValue('x', 5, PDO::PARAM_INT);
46 $stmt->bindValue('y', 50, PDO::PARAM_INT);
48 $stmt->execute();
50 foreach ($stmt->fetchAll() as $row) {
H A Dbug71885.phpt24 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
25 $stmt->execute();
30 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
31 $stmt->execute();
33 var_dump($stmt->fetch());
H A Dis_in_transaction.phpt26 $stmt = $db->prepare("INSERT INTO test_is_in_transaction (a, b) values (?, ?)");
27 $stmt->bindValue(1, 1);
28 $stmt->bindValue(2, "test insert");
29 $stmt->execute();
39 $stmt = $db->prepare("INSERT INTO test_is_in_transaction (a, b) values (?, ?)");
40 $stmt->bindValue(1, "error");
41 $stmt->bindValue(2, "test insert");
42 $stmt->execute();
/PHP-8.3/ext/mysqli/tests/
H A Dbug45019.phpt27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
31 if (!$stmt->bind_result($column1) || !$stmt->execute())
32 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
35 while ($stmt->fetch()) {
42 $stmt->close();
H A D019.phpt29 …if (!$stmt = mysqli_prepare($link, "INSERT INTO insert_read(col1,col10, col11, col6) VALUES (?,?,?…
32 mysqli_stmt_bind_param($stmt, "issd", $c1, $c2, $c3, $c4);
39 mysqli_stmt_execute($stmt);
40 mysqli_stmt_close($stmt);
42 …if (!$stmt = mysqli_prepare($link, "SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, c…
45 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11);
46 mysqli_stmt_execute($stmt);
48 mysqli_stmt_fetch($stmt);
54 mysqli_stmt_close($stmt);
H A Dmysqli_report.phpt55 $stmt = mysqli_stmt_init($link);
110 mysqli_stmt_close($stmt);
121 mysqli_stmt_execute($stmt);
122 mysqli_stmt_close($stmt);
144 mysqli_stmt_close($stmt);
154 mysqli_stmt_execute($stmt);
155 mysqli_stmt_close($stmt);
273 printf("[026] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
276 printf("[027] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
278 mysqli_stmt_close($stmt);
[all …]
H A Dbug34785.phpt31 $stmt = new my_stmt($link, "SELECT 'foo' FROM DUAL");
33 $stmt->execute();
34 $stmt->bind_result($var);
35 $stmt->fetch();
37 $stmt->close();
H A Dmysqli_stmt_attr_get.phpt19 $stmt = mysqli_stmt_init($link);
20 mysqli_stmt_prepare($stmt, 'SELECT * FROM test');
23 mysqli_stmt_attr_get($stmt, -100);
30 if (false === ($tmp = mysqli_stmt_attr_get($stmt, $attr))) {
36 $stmt->close();
40 mysqli_stmt_attr_get($stmt, $attr);
H A Dmysqli_next_result_error.phpt34 $stmt = $mysqli->prepare("CALL p()");
35 $stmt->execute();
39 $stmt->bind_result($num);
40 while ($stmt->fetch()) {
43 } while ($stmt->more_results() && $stmt->next_result());
H A Dmysqli_stmt_attr_get_prefetch.phpt14 $stmt = mysqli_stmt_init($link);
15 mysqli_stmt_prepare($stmt, 'SELECT * FROM test');
16 if (1 !== ($tmp = mysqli_stmt_attr_get($stmt, MYSQLI_STMT_ATTR_PREFETCH_ROWS))) {
20 $stmt->close();
H A Dbug_mysql_49406.phpt31 if (!$stmt = $link->prepare($query))
34 if (!$stmt->execute() || !$stmt->store_result())
35 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error);
65 $meta_res = $stmt->result_metadata();
82 if (!$stmt->bind_result($row_stmt) || !$stmt->fetch())
83 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error);
91 $stmt->close();
/PHP-8.3/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_tostring_exception.phpt17 $stmt = $db->prepare('INSERT INTO t VALUES(:i, :v)');
19 $stmt->bindValue('i', $param1);
21 $stmt->bindParam('v', $param2);
26 $stmt->execute();
32 $stmt->execute();
/PHP-8.3/ext/pdo_dblib/tests/
H A Dpdo_dblib_param_str_natl.phpt13 $stmt = $db->prepare('SELECT :value');
14 $stmt->bindValue(':value', 'foo', PDO::PARAM_STR | PDO::PARAM_STR_NATL);
15 $stmt->execute();
17 var_dump($stmt->debugDumpParams());

Completed in 54 milliseconds

12345678910>>...20