Home
last modified time | relevance | path

Searched refs:stmt (Results 176 – 200 of 467) sorted by relevance

12345678910>>...19

/PHP-7.4/ext/pdo_mysql/tests/
H A Dbug_45120.phpt18 $stmt = $db->prepare("SELECT 1 AS 'one'");
19 if (true !== $stmt->execute())
20 printf("[001] Execute has failed: %s\n", var_export($stmt->errorInfo(), true));
22 $res = $stmt->fetch(PDO::FETCH_ASSOC);
26 if (true !== $stmt->execute())
27 printf("[003] Execute has failed: %s\n", var_export($stmt->errorInfo(), true));
29 $res = $stmt->fetch(PDO::FETCH_ASSOC);
H A Dbug_39858.phpt42 $stmt = $db->prepare("CALL p()");
43 $stmt->execute();
45 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
46 } while ($stmt->nextRowset());
48 $stmt = $db->prepare("CALL p()");
49 $stmt->execute();
51 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
52 } while ($stmt->nextRowset());
53 $stmt->closeCursor();
H A Dpdo_mysql_attr_oracle_nulls.phpt28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
35 $stmt = $db->query('SELECT VERSION() as _version');
36 $row = $stmt->fetch(PDO::FETCH_ASSOC);
48 $stmt = $db->prepare('CALL p()');
49 $stmt->execute();
61 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
66 } while ($stmt->nextRowset());
68 $stmt->execute();
70 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
[all …]
H A Dpdo_mysql_stmt_getcolumnmeta.phpt11 $row = $stmt->fetch(PDO::FETCH_ASSOC);
32 $stmt->execute();
57 $stmt->execute();
74 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) {
86 $stmt->execute();
87 $meta = $stmt->getColumnMeta(1);
92 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
145 $stmt->execute();
238 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
259 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
[all …]
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());
/PHP-7.4/ext/mysqli/tests/
H A Dbug35759.phpt35 $stmt = $mysql->prepare("SELECT * FROM test");
36 if ($stmt) {
38 $stmt->execute();
39 $stmt->store_result();
43 call_user_func_array(array($stmt, "bind_result"), $params);
44 $stmt->fetch();
46 $stmt->close();
H A Dmysqli_stmt_bind_result_zerofill.phpt29 if (!($stmt = mysqli_prepare($link, 'SELECT zero FROM test LIMIT 1'))) {
36 if (!mysqli_stmt_bind_result($stmt, $result)) {
38 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_fetch($stmt)) {
44 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
48 $res = mysqli_stmt_result_metadata($stmt);
50 mysqli_stmt_free_result($stmt);
H A Dbug66124.phpt34 $stmt = $link->prepare($table_insert);
35 if (!$stmt) {
41 $stmt->bind_param('i', $id);
43 if ($stmt->execute()){
44 echo "insert id:{$id}=>{$stmt->insert_id}\n";
62 $stmt->close();
68 $stmt = $link->prepare($table_insert);
69 $stmt->bind_param('s', $id);
73 if ($stmt->execute()){
H A Dmysqli_stmt_get_result_types.phpt36 … printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 … printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 mysqli_stmt_close($stmt);
54 mysqli_stmt_close($stmt);
59 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 mysqli_stmt_close($stmt);
65 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 mysqli_stmt_close($stmt);
73 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
98 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
[all …]
H A Dbug76386.phpt39 $stmt = $link->prepare('SELECT * FROM ts_test;'); // must be statement
40 if ($stmt) {
41 $stmt->execute();
44 $stmt->fetch();
46 $stmt->free_result();
67 $stmt = $link->prepare('SELECT * FROM t_test;');
68 if ($stmt) {
69 $stmt->execute();
71 $stmt->bind_result($tid, $t, $t2, $t4, $t6);
72 while ($stmt->fetch()) {
[all …]
H A Dmysqli_stmt_get_result_metadata_fetch_field.phpt23 if (!($stmt = mysqli_stmt_init($link)) ||
24 …!mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') ___label FROM te…
25 !mysqli_stmt_execute($stmt))
26 printf("[001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
28 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
30 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
33 if (!is_object($res_meta = mysqli_stmt_result_metadata($stmt)) ||
36 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 mysqli_stmt_close($stmt);
H A Dmysqli_change_user_prepared_statements.phpt16 if (!$stmt = mysqli_prepare($link, "SELECT 'prepared statements should be released'"))
22 if ($stmt->execute() && $stmt->bind_result($wrong) && $stmt->fetch()) {
25 if ($stmt->errno == 0)
/PHP-7.4/ext/pdo_firebird/tests/
H A Dbug_64037.phpt22 $stmt = $dbh->prepare($query);
23 $stmt->execute();
24 $rows = $stmt->fetchAll();
30 $stmt = $dbh->prepare('DELETE FROM price');
31 $stmt->execute();
37 unset($stmt);
/PHP-7.4/ext/mysqlnd/
H A Dmysqlnd_driver.c193 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local
203 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD()
204 if (!stmt) { in MYSQLND_METHOD()
211 stmt->error_info = &stmt->error_info_impl; in MYSQLND_METHOD()
214 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD()
215 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD()
216 stmt->execute_cmd_buffer.length = 4096; in MYSQLND_METHOD()
217 stmt->execute_cmd_buffer.buffer = mnd_emalloc(stmt->execute_cmd_buffer.length); in MYSQLND_METHOD()
218 if (!stmt->execute_cmd_buffer.buffer) { in MYSQLND_METHOD()
222 stmt->prefetch_rows = MYSQLND_DEFAULT_PREFETCH_ROWS; in MYSQLND_METHOD()
[all …]
/PHP-7.4/ext/sqlite3/tests/
H A Dexception_from_toString.phpt17 $stmt = $db->prepare('INSERT INTO t VALUES(:i, :v)');
18 $stmt->bindValue('i', 1234);
19 $stmt->bindValue('v', new throws);
22 $stmt->execute();
28 $stmt->execute();
/PHP-7.4/ext/oci8/tests/
H A Derror_bind.phpt22 $stmt = oci_parse($c, "insert into bind_test values (:name)");
23 oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR);
24 var_dump(oci_execute($stmt));
28 var_dump(oci_execute($stmt));
31 oci_bind_by_name($stmt, ":name", $c);
32 var_dump(oci_execute($stmt));
37 $stmt = oci_parse($c, "update bind_test set name='xyz' returning rowid into :r_id");
38 oci_bind_by_name($stmt, ":r_id", $c);
39 var_dump(oci_execute($stmt));
H A Dbug37220.phpt29 $stmt = oci_parse ($c, $query);
31 oci_bind_by_name($stmt, ':data', $clob, -1, OCI_B_CLOB);
33 $success = oci_execute($stmt, OCI_COMMIT_ON_SUCCESS);
34 oci_free_statement($stmt);
40 $stmt = oci_parse ($c, $query);
42 oci_execute($stmt);
44 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
/PHP-7.4/ext/pdo/tests/
H A Dpdo_025.phpt30 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
32 $stmt->execute($row);
39 $stmt = $db->prepare('SELECT * FROM test');
40 $stmt->setFetchMode(PDO::FETCH_INTO, new Test);
41 $stmt->execute();
43 foreach($stmt as $obj) {
54 $stmt->setFetchMode(PDO::FETCH_INTO, new Fail);
55 $stmt->execute();
57 foreach($stmt as $obj) {
H A Dpdo_013.phpt23 $stmt = $db->prepare($SELECT);
25 $stmt->execute();
26 $stmt->setFetchMode(PDO::FETCH_NUM);
27 foreach ($stmt as $data)
40 unset($stmt);
47 unset($stmt);
49 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test', array('WOW'));
51 foreach($stmt as $data)
H A Dbug_65946.phpt37 $stmt = $db->prepare($sql);
38 $stmt->bindValue('limit', 1, PDO::PARAM_INT);
39 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
40 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
41 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-7.4/ext/pdo_oci/tests/
H A Dpdo_oci_attr_module.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();
H A Dbug46274.phpt27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl…
35 $stmt->bindparam(':id', $id);
36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
37 $stmt->execute();
45 $stmt->bindparam(':id', $id);
46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
47 $stmt->execute();
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dis_in_transaction.phpt24 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)");
25 $stmt->bindValue(1, 1);
26 $stmt->bindValue(2, "test insert");
27 $stmt->execute();
37 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)");
38 $stmt->bindValue(1, "error");
39 $stmt->bindValue(2, "test insert");
40 $stmt->execute();
H A Dbug43925.phpt31 $stmt = $dbh->prepare('
41 $stmt->bindValue('left', 1, PDO::PARAM_INT);
42 $stmt->bindValue('rootId', 3, PDO::PARAM_INT);
43 $stmt->bindValue('x', 5, PDO::PARAM_INT);
44 $stmt->bindValue('y', 50, PDO::PARAM_INT);
46 $stmt->execute();
48 foreach ($stmt->fetchAll() as $row) {
/PHP-7.4/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();

Completed in 31 milliseconds

12345678910>>...19