Home
last modified time | relevance | path

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

12345678910>>...18

/PHP-8.2/ext/pdo_mysql/tests/
H A Dpdo_mysql_bit.phpt25 $stmt = $db->prepare('INSERT INTO test_mysql_bit(id, label) VALUES (?, ?)');
26 $stmt->bindValue(1, $offset);
27 $stmt->bindValue(2, $value);
28 if (!$stmt->execute()) {
29 printf("[%03d + 1] INSERT failed, %s\n", $offset, var_export($stmt->errorInfo(), true));
32 $stmt = $db->query('SELECT id, label FROM test_mysql_bit');
33 $row = $stmt->fetch(PDO::FETCH_ASSOC);
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_mysql_types_zerofill');
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_prepare_emulated_myisam.phpt19 $stmt = @$db->prepare($query);
21 $stmt = $db->prepare($query);
47 $ret = @$stmt->execute($input_params);
49 $ret = $stmt->execute($input_params);
56 $tmp = $stmt->errorInfo();
81 return $stmt;
126 $stmt = prepex(14, $db, $sql, array('placeholder' => -1));
127 if (count(($tmp = $stmt->fetchAll(PDO::FETCH_ASSOC))) != 0)
133 $stmt = prepex(15, $db, $sql, array('placeholder' => 1));
134 if (count(($tmp = $stmt->fetchAll(PDO::FETCH_ASSOC))) != 2)
[all …]
H A Dpdo_mysql_stmt_getcolumnmeta.phpt28 $stmt->execute();
32 $stmt->getColumnMeta(-1);
45 $stmt->execute();
46 $native = $stmt->getColumnMeta(0);
62 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) {
74 $stmt->execute();
80 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
133 $stmt->execute();
225 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
246 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
[all …]
H A Dbug46292.phpt32 $stmt = $pdoDb->prepare("SELECT * FROM test_46292");
34 var_dump($stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE | PDO::FETCH_GROUP));
35 $stmt->execute();
37 var_dump($stmt->fetch());
38 var_dump($stmt->fetch());
39 var_dump($stmt->fetchAll());
H A Dpdo_mysql_pconnect.phpt25 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
29 $stmt = $db1->query('SELECT CONNECTION_ID() AS _con1');
30 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
33 $stmt = $db2->query('SELECT CONNECTION_ID() AS _con2');
34 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
43 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1');
44 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
67 $stmt = $db1->query('SELECT CONNECTION_ID() AS _con1');
68 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
73 $stmt = $db2->query('SELECT CONNECTION_ID() AS _con2');
[all …]
H A Dpdo_mysql_prepare_native_myisam.phpt18 $stmt = @$db->prepare($query);
20 $stmt = $db->prepare($query);
42 if (!is_object($stmt))
50 $ret = @$stmt->execute($input_params);
52 $ret = $stmt->execute($input_params);
58 $tmp = $stmt->errorInfo();
90 return $stmt;
113 if (is_object($stmt)) {
135 $stmt = prepex(10, $db, $sql, array('placeholder' => -1));
136 if (count(($tmp = $stmt->fetchAll(PDO::FETCH_ASSOC))) != 0)
[all …]
H A Dpdo_mysql_errorinfo.phpt49 $stmt = $db->query("SELECT id, label FROM {$table}");
50 $stmt2 = &$stmt;
52 check_error($offset + 4, $stmt);
55 @$stmt->execute();
57 check_error($offset + 6, $stmt, '42S02');
60 @$stmt = $db->query('SELECT id, label FROM unknown');
64 $stmt = $db->query("SELECT id, label FROM {$table}");
66 check_error($offset + 10, $stmt);
73 check_error($offset + 13, $stmt);
81 check_error($offset + 17, $stmt);
/PHP-8.2/ext/pdo_firebird/tests/
H A Dbug_64037.phpt23 $stmt = $dbh->prepare($query);
24 $stmt->execute();
25 $rows = $stmt->fetchAll();
31 $stmt = $dbh->prepare('DELETE FROM test64037');
32 $stmt->execute();
34 unset($stmt);
/PHP-8.2/ext/pdo_dblib/tests/
H A Dpdo_dblib_param_str_natl.phpt16 $stmt = $db->prepare('SELECT :value');
17 $stmt->bindValue(':value', 'foo', PDO::PARAM_STR | PDO::PARAM_STR_NATL);
18 $stmt->execute();
20 var_dump($stmt->debugDumpParams());
H A Dbug_45876.phpt17 $stmt = $db->prepare("select top 1 ic1.* from information_schema.columns ic1");
18 $stmt->execute();
19 var_dump($stmt->getColumnMeta(0));
20 $stmt = null;
H A Dbug_50755.phpt20 $stmt = $db->prepare("select *
25 $x = $stmt->execute();
27 while (($r = $stmt->fetch())) {
30 $stmt = null;
/PHP-8.2/ext/mysqli/tests/
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 Dbug44897.phpt29 if (!$stmt = $link->prepare('CALL p(?, ?)'))
32 if (!$stmt->bind_param('is', $new_id, $new_label) || !$stmt->execute())
33 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
36 if (!$stmt->bind_result($out_new_label) || !$stmt->fetch())
37 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error);
43 $stmt->close();
H A Dmysqli_stmt_get_result_bit.phpt54 if (!$stmt = mysqli_stmt_init($link))
84 if (!mysqli_stmt_prepare($stmt, $sql) ||
85 !mysqli_stmt_execute($stmt))
86 … printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
89 if (!mysqli_stmt_prepare($stmt, $sql) ||
90 !mysqli_stmt_execute($stmt))
91 … printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 if (!$res = mysqli_stmt_get_result($stmt))
94 … printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
121 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_get_result_seek.phpt16 if (!$stmt = mysqli_stmt_init($link))
19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3"))
20 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
22 if (!mysqli_stmt_execute($stmt))
23 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
25 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
27 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 $i, mysqli_stmt_errno($stmt), $stmt->error);
92 mysqli_stmt_close($stmt);
H A Dbug45289.phpt21 if (!($stmt = $link->prepare('SELECT id, label FROM test WHERE id=? LIMIT 1')))
24 if (!$stmt->bind_param('i', $id) || !$stmt->execute())
25 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
/PHP-8.2/ext/pdo_odbc/tests/
H A Dbug44643.phpt15 $stmt = $db->prepare($sql);
17 $stmt->bindParam(':id1', $id1, PDO::PARAM_INT);
19 $stmt->bindParam(':id2', $id2, PDO::PARAM_INT);
20 var_dump($stmt->execute());
H A Dbug80783a.phpt24 $stmt = $db->prepare("SELECT name FROM bug80783a");
25 $stmt->setAttribute(PDO::ODBC_ATTR_ASSUME_UTF8, true);
26 $stmt->bindColumn(1, $data, PDO::PARAM_STR);
27 $stmt->execute();
28 $stmt->fetch(PDO::FETCH_BOUND);
/PHP-8.2/ext/sqlite3/tests/
H A Dsqlite3_35_stmt_readonly.phpt26 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
27 var_dump($stmt->readOnly());
30 $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?");
31 var_dump($stmt->readOnly());
34 $stmt = $db->prepare("DELETE FROM test");
35 var_dump($stmt->readOnly());
H A Dbug72571.phpt9 $stmt = $db->prepare("select 1 = ?");
13 $stmt->bindParam(0, $i);
15 var_dump($stmt->execute());
/PHP-8.2/ext/mysqlnd/
H A Dmysqlnd_result.h22 …ult_unbuffered_init(MYSQLND_RES * result, const unsigned int field_count, MYSQLND_STMT_DATA *stmt);
23 …esult_buffered_init(MYSQLND_RES * result, const unsigned int field_count, MYSQLND_STMT_DATA *stmt);
25 enum_func_status mysqlnd_query_read_result_set_header(MYSQLND_CONN_DATA * conn, MYSQLND_STMT * stmt…
/PHP-8.2/ext/odbc/
H A Dphp_odbc.c117 SQLFreeStmt(res->stmt,SQL_DROP); in ZEND_GET_MODULE()
1028 rc = SQLExecute(result->stmt); in PHP_FUNCTION()
1326 rc = SQLFetch(result->stmt); in php_odbc_fetch_hash()
1491 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1592 rc = SQLFetchPrev(result->stmt); in PHP_FUNCTION()
1642 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1731 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1902 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
2004 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
2779 rc = SQLTables(result->stmt, in PHP_FUNCTION()
[all …]
/PHP-8.2/ext/pdo/tests/
H A Dpdo_uninitialized.phpt22 $stmt = new MyPDOStatement;
24 $stmt->fetch();
28 $stmt = new MyPDOStatement;
30 foreach ($stmt as $row) {}
/PHP-8.2/ext/pdo_pgsql/tests/
H A Ddisable_prepares.phpt19 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
28 $stmt->execute();
29 $first = $stmt->fetchAll();
38 $stmt->execute();
39 $second = $stmt->fetchAll();

Completed in 42 milliseconds

12345678910>>...18