Home
last modified time | relevance | path

Searched refs:stmt (Results 226 – 250 of 467) sorted by relevance

12345678910>>...19

/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_get_result_metadata.phpt16 if (!$stmt = mysqli_stmt_init($link))
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));
27 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
33 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
41 mysqli_stmt_close($stmt);
47 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
57 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dbug44897.phpt33 if (!$stmt = $link->prepare('CALL p(?, ?)'))
36 if (!$stmt->bind_param('is', $new_id, $new_label) || !$stmt->execute())
37 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
40 if (!$stmt->bind_result($out_new_label) || !$stmt->fetch())
41 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error);
47 $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 D005.phpt25 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
26 mysqli_stmt_bind_result($stmt, $c1, $c2);
27 mysqli_stmt_execute($stmt);
28 mysqli_stmt_fetch($stmt);
36 mysqli_stmt_fetch($stmt);
38 mysqli_stmt_close($stmt);
H A Dbug45289.phpt20 if (!($stmt = $link->prepare('SELECT id, label FROM test WHERE id=? LIMIT 1')))
23 if (!$stmt->bind_param('i', $id) || !$stmt->execute())
24 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
H A D046.phpt22 $stmt = mysqli_prepare($link, "DELETE FROM test_affected WHERE foo=?");
23 mysqli_stmt_bind_param($stmt, "i", $c1);
27 mysqli_stmt_execute($stmt);
28 $x = mysqli_stmt_affected_rows($stmt);
30 mysqli_stmt_close($stmt);
H A D009.phpt41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8);
43 mysqli_stmt_execute($stmt);
44 $rc = mysqli_stmt_fetch($stmt);
57 mysqli_stmt_close($stmt);
68 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch_uint");
69 mysqli_stmt_bind_result($stmt, $c1, $c2);
70 mysqli_stmt_execute($stmt);
71 $rc = mysqli_stmt_fetch($stmt);
75 mysqli_stmt_close($stmt);
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()) {
48 $stmt->close();
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_types_zerofill.phpt24 $stmt->bindValue(1, $offset);
25 $stmt->bindValue(2, $value);
27 if (!$stmt->execute()) {
38 $stmt = $db->query('SELECT id, label FROM test');
39 $row = $stmt->fetch(PDO::FETCH_ASSOC);
40 $stmt->closeCursor();
78 $stmt = $db->query('SELECT id, label FROM test');
79 $row_string = $stmt->fetch(PDO::FETCH_ASSOC);
80 $stmt->closeCursor();
95 $stmt->execute();
[all …]
H A Dpdo_mysql_bit.phpt26 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)');
27 $stmt->bindValue(1, $offset);
28 $stmt->bindValue(2, $value);
29 if (!$stmt->execute()) {
30 printf("[%03d + 1] INSERT failed, %s\n", $offset, var_export($stmt->errorInfo(), true));
33 $stmt = $db->query('SELECT id, label FROM test');
34 $row = $stmt->fetch(PDO::FETCH_ASSOC);
H A Dpdo_mysql_prepare_native_mixed_style.phpt20 $stmt = $db->query('DELETE FROM test');
21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)');
22 $stmt->execute(array('a', 'b'));
23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label…
24 $stmt->execute(array(1, 1));
25 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_mysql_errorinfo.phpt48 $stmt = $db->query('SELECT id, label FROM test');
49 $stmt2 = &$stmt;
51 check_error($offset + 4, $stmt);
54 @$stmt->execute();
56 check_error($offset + 6, $stmt, '42S02');
59 @$stmt = $db->query('SELECT id, label FROM unknown');
63 $stmt = $db->query('SELECT id, label FROM test');
65 check_error($offset + 10, $stmt);
72 check_error($offset + 13, $stmt);
80 check_error($offset + 17, $stmt);
/PHP-7.4/ext/pdo_sqlite/
H A Dphp_pdo_sqlite_int.h64 sqlite3_stmt *stmt; member
71 extern int _pdo_sqlite_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, const char *file, int line);
73 #define pdo_sqlite_error_stmt(s) _pdo_sqlite_error(stmt->dbh, stmt, __FILE__, __LINE__)
/PHP-7.4/ext/pdo_odbc/tests/
H A Dbug44643.phpt14 $stmt = $db->prepare($sql);
16 $stmt->bindParam(':id1', $id1, PDO::PARAM_INT);
18 $stmt->bindParam(':id2', $id2, PDO::PARAM_INT);
19 var_dump($stmt->execute());
/PHP-7.4/ext/pdo_oci/tests/
H A Dbug46274_2.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/oci8/tests/
H A Ddefine.phpt22 $stmt = oci_parse($c, "select string from define_tab");
27 oci_define_by_name($stmt, "STRING", $string, 20);
29 oci_execute($stmt);
31 while (oci_fetch($stmt)) {
H A Ddefine_old.phpt22 $stmt = ociparse($c, "select string from define_old_tab");
27 ocidefinebyname($stmt, "STRING", $string, 20);
29 ociexecute($stmt);
31 while (ocifetch($stmt)) {
/PHP-7.4/ext/sqlite3/tests/
H A Dbug72571.phpt10 $stmt = $db->prepare("select 1 = ?");
14 $stmt->bindParam(0, $i);
16 var_dump($stmt->execute());
H A Dsqlite3_33_reset.phpt16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id');
17 $stmt->bindValue(':id', 1, SQLITE3_INTEGER);
18 $stmt->reset("dummy");
19 $stmt->reset();
/PHP-7.4/ext/pdo/tests/
H A Dpdo_030.phpt64 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
65 var_dump(get_class($stmt));
67 $stmt->execute($row);
70 unset($stmt);
77 $stmt = $db->query('SELECT * FROM test');
78 var_dump(get_class($stmt));
79 var_dump(get_class($stmt->dbh));
83 foreach($stmt as $obj) {
H A Dpdo_006.phpt22 $stmt = $db->prepare('SELECT val, id from test');
24 $stmt->execute();
25 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_GROUP));
27 $stmt->execute();
28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_GROUP));
H A Dpdo_023.phpt53 $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx')));
54 $stmt->execute();
55 return $stmt;
68 $stmt = $db->query('SELECT val, id FROM test');
69 var_dump($stmt);
70 var_dump($stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE));
72 $stmt = NULL;
/PHP-7.4/ext/pdo_dblib/tests/
H A Ddatetime_convert.phpt16 $stmt = $db->query($sql);
17 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
22 $stmt = $db->query($sql);
23 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
H A Ddatetime2.phpt17 $stmt = $db->query($sql);
18 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
22 $stmt = $db->query($sql);
23 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
/PHP-7.4/ext/pdo_pgsql/tests/
H A Ddisable_prepares.phpt17 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
26 $stmt->execute();
27 $first = $stmt->fetchAll();
36 $stmt->execute();
37 $second = $stmt->fetchAll();

Completed in 35 milliseconds

12345678910>>...19