Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-5.5/ext/pdo_mysql/tests/
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_column.phpt20 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1");
21 $stmt->execute(array(':param' => 'id'));
22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
25 $stmt->execute(array(':placeholder' => 'test'));
27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dbug46292.phpt45 $stmt = $pdoDb->prepare("SELECT * FROM testz");
47 var_dump($stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE | PDO::FETCH_GROUP));
48 $stmt->execute();
50 var_dump($stmt->fetch());
51 var_dump($stmt->fetch());
52 var_dump($stmt->fetchAll());
H A Dpdo_mysql_stmt_fetch_serialize.phpt90 $stmt = $db->prepare('INSERT INTO test(id, myobj) VALUES (?, ?)');
91 $stmt->bindValue(1, $id);
92 $stmt->bindValue(2, $myobj);
93 $stmt->execute();
99 $stmt = $db->prepare('SELECT myobj FROM test');
101 $stmt->execute();
102 var_dump($stmt->fetch());
105 $stmt = $db->prepare('SELECT myobj FROM test');
106 $stmt->setFetchMode(PDO::FETCH_CLASS, 'myclass', array('PDO shall call __construct()'));
107 $stmt->execute();
[all …]
H A Dpdo_mysql_begintransaction.phpt39 $row = $stmt->fetch(PDO::FETCH_ASSOC);
57 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
67 $new_row1 = $stmt->fetch(PDO::FETCH_ASSOC);
76 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC);
98 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC);
106 if (!($stmt = $db->query('SELECT @@autocommit as auto_commit')))
109 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
112 $tmp['auto_commit'], $stmt->errorCode(), $stmt->errorInfo());
120 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
123 $tmp['auto_commit'], $stmt->errorCode(), trim(implode(' ', $stmt->errorInfo())));
[all …]
H A Dpdo_mysql_stmt_multiquery.phpt15 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B…
16 var_dump($stmt->errorInfo());
17 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
18 var_dump($stmt->errorInfo());
24 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B…
26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
27 } while ($stmt->nextRowset());
H A Dpdo_mysql_stmt_errorcode.phpt23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
24 $stmt->execute();
25 var_dump($stmt->errorCode());
39 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
40 $stmt->execute();
41 var_dump($stmt->errorCode());
H A Dpdo_mysql_stmt_fetch_serialize_simple.phpt50 $stmt = $db->prepare('SELECT myobj FROM test');
51 $stmt->execute();
52 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO'));
55 $stmt->execute();
56 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass');
60 $stmt = $db->prepare('SELECT myobj FROM test');
61 $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO'));
62 $stmt->execute();
63 var_dump($stmt->fetch());
/PHP-5.5/ext/mysqli/tests/
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 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 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_stmt_attr_get.phpt41 $stmt = mysqli_stmt_init($link);
42 mysqli_stmt_prepare($stmt, 'SELECT * FROM test');
43 if (false !== ($tmp = @mysqli_stmt_attr_get($stmt, $invalid_attr)))
47 if (false === ($tmp = mysqli_stmt_attr_get($stmt, $attr))) {
53 $stmt->close();
56 if (!is_null($tmp = @mysqli_stmt_attr_get($stmt, $attr))) {
H A Dmysqli_stmt_prepare.phpt30 if (!$stmt = mysqli_stmt_init($link))
33 if (NULL !== ($tmp = @mysqli_stmt_prepare($stmt)))
36 if (false !== ($tmp = mysqli_stmt_prepare($stmt, '')))
39 if (true !== ($tmp = mysqli_stmt_prepare($stmt, 'SELECT id FROM test')))
42 mysqli_stmt_close($stmt);
44 if (NULL !== ($tmp = mysqli_stmt_prepare($stmt, "SELECT id FROM test")))
H A Dmysqli_fetch_array_large.phpt54 if (!$stmt = mysqli_prepare($link, "SELECT id, label FROM test")) {
60 if (!mysqli_stmt_execute($stmt)) {
61 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq…
66 if (!mysqli_stmt_bind_result($stmt, $id, $label)) {
67 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq…
71 while (mysqli_stmt_fetch($stmt)) {
74 $offset, $random_char, $label, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
79 mysqli_stmt_free_result($stmt);
80 mysqli_stmt_close($stmt);
H A D013.phpt31 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result");
34 $b_res= mysqli_stmt_bind_result($stmt, $c[0], $c[1], $c[2], $c[3], $c[4], $c[5], $c[6], $c[7]);
35 mysqli_stmt_execute($stmt);
36 mysqli_stmt_fetch($stmt);
37 mysqli_stmt_fetch($stmt);
38 mysqli_stmt_close($stmt);
/PHP-5.5/ext/sqlite3/tests/
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-5.5/ext/oci8/tests/
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)) {
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 Dbug37581.phpt33 $stmt = oci_parse($c,'begin ARRAYBINDPKG1.array_bind(:in_arr, :out_str); end;');
36 oci_bind_array_by_name($stmt,':in_arr',$strings,5,1,SQLT_AFC);
37 oci_bind_by_name($stmt,':out_str',$result,10);
39 oci_execute($stmt);
42 oci_execute($stmt);
H A Dselect_null.phpt12 $stmt = oci_parse($pc, "select NULL from dual");
13 oci_execute($stmt);
14 var_dump(oci_fetch_array($stmt, OCI_RETURN_NULLS));
/PHP-5.5/ext/pdo/tests/
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_007.phpt22 $stmt = $db->prepare('SELECT id, val from test');
24 $stmt->execute();
25 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE));
27 $stmt->execute();
28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE));
H A Dbug_38253.phpt21 $stmt = $pdo->prepare ("SELECT * FROM test");
22 $stmt->execute();
23 var_dump($stmt->fetchAll());
37 $stmt = $pdo->prepare ("SELECT * FROM test2");
38 $stmt->execute();
39 var_dump($stmt->fetchAll());
/PHP-5.5/ext/mysqli/
H A Dmysqli_priv.h67 extern void php_clear_stmt_bind(MY_STMT *stmt TSRMLS_DC);
144 #define MYSQLI_REPORT_STMT_ERROR(stmt) \ argument
145 if ((MyG(report_mode) & MYSQLI_REPORT_ERROR) && mysql_stmt_errno(stmt)) { \
146 …php_mysqli_report_error(mysql_stmt_sqlstate(stmt), mysql_stmt_errno(stmt), mysql_stmt_error(stmt) …
/PHP-5.5/ext/pdo_odbc/
H A Dphp_pdo_odbc_int.h148 PDO_ODBC_HSTMT stmt; member
170 void pdo_odbc_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, PDO_ODBC_HSTMT statement, char *what, const c…
172 #define pdo_odbc_stmt_error(what) pdo_odbc_error(stmt->dbh, stmt, SQL_NULL_HSTMT, what, __FILE__, _…
173 #define pdo_odbc_doer_error(what) pdo_odbc_error(dbh, NULL, stmt, what, __FILE__, __LINE__ TSRMLS_C…

Completed in 35 milliseconds

12345678910>>...16