Home
last modified time | relevance | path

Searched refs:stmt (Results 126 – 150 of 392) sorted by relevance

12345678910>>...16

/PHP-5.5/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_load_data.phpt11 $stmt = $db->query('SELECT USER() as _user');
12 $row = $stmt->fetch(PDO::FETCH_ASSOC);
63 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'");
80 if (!$stmt->execute()) {
81 printf("[004] [%d] %s\n", $stmt->errorCode(), var_export($stmt->errorInfo(), true));
85 $stmt = $db->query("SELECT 1 as 'one'");
86 if ($stmt->errorCode() != '0000') {
87 printf("[005] [%d] %s\n", $stmt->errorCode(), var_export($stmt->errorInfo(), true));
89 $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
91 printf("[006] [%d] %s\n", $stmt->errorCode(), var_export($stmt->errorInfo(), true));
[all …]
H A Dbug41125.phpt19 $stmt = $db->prepare($sql);
20 $stmt->execute();
22 print implode(' - ', $stmt->errorinfo()) ."\n";
34 $stmt = $db->prepare($query);
35 $stmt->execute(array(1));
44 $stmt = $db->prepare($sql);
47 $stmt->bindParam(':id', $id);
48 $stmt->execute();
75 $stmt = $db->prepare($query);
76 $stmt->bindParam(':id', $id);
[all …]
H A Dpdo_mysql_prepare_emulated_placeholder_everywhere.phpt27 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?');
28 $stmt->execute(array('test'));
29 if ('00000' !== $stmt->errorCode()) {
31 var_export($stmt->errorCode(), true),
32 var_export($stmt->errorInfo(), true));
34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
43 $stmt->execute(array('test'));
44 if ('00000' !== $stmt->errorCode())
46 var_export($stmt->errorCode(), true),
47 var_export($stmt->errorInfo(), true));
[all …]
H A Dpdo_mysql_errorcode.phpt38 $stmt = $db->query('SELECT id, label FROM test');
39 $stmt2 = &$stmt;
41 check_error(4, $stmt);
44 @$stmt->execute();
46 check_error(5, $stmt, '42S02');
50 @$stmt = $db->query('SELECT id, label FROM unknown');
54 $stmt = $db->query('SELECT id, label FROM test');
56 check_error(9, $stmt);
62 check_error(12, $stmt);
70 check_error(16, $stmt);
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 Dpdo_mysql_stmt_errorinfo.phpt23 var_dump($stmt->errorInfo());
24 $stmt->execute();
25 var_dump($stmt->errorInfo());
28 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
30 var_dump($stmt->execute());
31 var_dump($stmt->errorInfo());
46 var_dump($stmt);
49 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
50 var_dump($stmt->errorInfo());
52 $stmt->execute();
[all …]
/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_stmt_bind_param_type_juggling.phpt27 if (!$stmt = mysqli_stmt_init($link)) {
32 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(col1, col2) VALUES (?, ?)")) {
33 printf("[%03d + 4] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
37 if (!mysqli_stmt_bind_param($stmt, $bind_type1 . $bind_type2, $bind_value1, $bind_value1)) {
38 printf("[%03d + 5] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (!mysqli_stmt_execute($stmt)) {
43 printf("[%03d + 6] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
48 printf("[%03d + 7] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 if (!mysqli_stmt_execute($stmt)) {
52 printf("[%03d + 8] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A D067.phpt23 if (!is_object($stmt = $mysql->prepare($query))) {
28 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
29 return $stmt;
47 $stmt[$i] = open_cursor($mysql, "SELECT a FROM cursor$i");
48 $stmt[$i]->execute();
49 $stmt[$i]->bind_result($a[$i]);
54 while ($stmt[0]->fetch()) {
55 $stmt[1]->fetch();
56 $stmt[2]->fetch();
61 $stmt[$i]->close();
H A Dmysqli_explain_metadata.phpt66 $stmt = mysqli_stmt_init($link);
68 if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) {
69 if (!mysqli_stmt_store_result($stmt))
70 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
72 if (!$res_meta = mysqli_stmt_result_metadata($stmt))
73 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104 $stmt->execute()) {
105 if (!$res_stmt = mysqli_stmt_get_result($stmt)) {
107 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
113 if ((mysqli_stmt_num_rows($stmt)) !== 0) {
[all …]
H A D020.phpt39 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_result VALUES (?,?,?,?,?,?,?)");
40 mysqli_stmt_bind_param($stmt, "sssssss", $d1, $d2, $d3, $d4, $d5, $d6, $d7);
50 mysqli_stmt_execute($stmt);
51 mysqli_stmt_close($stmt);
53 $stmt = mysqli_prepare($link, "SELECT c1, c2, c3, c4, c5, c6, c7 FROM test_bind_result");
55 mysqli_stmt_bind_result($stmt,$c1, $c2, $c3, $c4, $c5, $c6, $c7);
57 mysqli_stmt_execute($stmt);
58 mysqli_stmt_fetch($stmt);
64 mysqli_stmt_close($stmt);
H A D025.phpt27 $stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES(?,?,?,?,?,?,?)");
28 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7);
38 mysqli_stmt_execute($stmt);
39 mysqli_stmt_close($stmt);
45 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
46 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7);
47 mysqli_stmt_execute($stmt);
48 mysqli_stmt_fetch($stmt);
54 mysqli_stmt_close($stmt);
H A D016.phpt18 if (!$stmt = mysqli_prepare($link, "SELECT @dummy"))
21 mysqli_stmt_bind_result($stmt, $dummy);
22 mysqli_stmt_execute($stmt);
23 mysqli_stmt_fetch($stmt);
27 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_get_result_types.phpt38 printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
44 printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
45 mysqli_stmt_close($stmt);
52 mysqli_stmt_close($stmt);
56 mysqli_stmt_close($stmt);
62 mysqli_stmt_close($stmt);
68 mysqli_stmt_close($stmt);
76 mysqli_stmt_close($stmt);
100 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
102 mysqli_stmt_close($stmt);
[all …]
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);
/PHP-5.5/ext/pdo/
H A Dpdo_sql_parser.re139 if (stmt->supports_placeholders == query_type && !stmt->named_rewrite_template) {
154 params = stmt->bound_params;
158 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "no parameters were bound" TSRMLS_CC);
198 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined" TSRMLS_CC);
211 if (!stmt->dbh->methods->quoter(stmt->dbh, buf, len, &plc->quoted, &plc->qlen,
215 strncpy(stmt->error_code, stmt->dbh->error_code, 6);
253 if (!stmt->dbh->methods->quoter(stmt->dbh, Z_STRVAL(tmp_param),
258 strncpy(stmt->error_code, stmt->dbh->error_code, 6);
308 const char *tmpl = stmt->named_rewrite_template ? stmt->named_rewrite_template : ":pdo%d";
453 if(stmt->dbh->methods->quoter(stmt->dbh, Z_STRVAL_P(param->parameter),
[all …]
H A Dphp_pdo_driver.h321 typedef int (*pdo_stmt_dtor_func)(pdo_stmt_t *stmt TSRMLS_DC);
324 typedef int (*pdo_stmt_execute_func)(pdo_stmt_t *stmt TSRMLS_DC);
329 typedef int (*pdo_stmt_fetch_func)(pdo_stmt_t *stmt,
334 typedef int (*pdo_stmt_describe_col_func)(pdo_stmt_t *stmt, int colno TSRMLS_DC);
397 typedef int (*pdo_stmt_next_rowset_func)(pdo_stmt_t *stmt TSRMLS_DC);
403 typedef int (*pdo_stmt_cursor_closer_func)(pdo_stmt_t *stmt TSRMLS_DC);
538 pdo_stmt_t *stmt; /* for convenience in dtor */ member
652 PDO_API int pdo_parse_params(pdo_stmt_t *stmt, char *inquery, int inquery_len,
655 PDO_API void pdo_raise_impl_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt,
661 PDO_API void php_pdo_stmt_addref(pdo_stmt_t *stmt TSRMLS_DC);
[all …]
/PHP-5.5/ext/oci8/tests/
H A Ddefine1.phpt22 $stmt = oci_parse($c, "select string from define1_tab");
27 var_dump(oci_define_by_name($stmt, "STRING", $string, 20));
28 var_dump(oci_define_by_name($stmt, "STRING", $string, 20));
29 var_dump(oci_define_by_name($stmt, "", $string, 20));
30 var_dump(oci_define_by_name($stmt, ""));
32 oci_execute($stmt);
34 while (oci_fetch($stmt)) {
/PHP-5.5/ext/sqlite3/tests/
H A Dbug63921-32bit.phpt14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
15 $stmt->bindValue(':id', 1, SQLITE3_INTEGER);
16 $stmt->bindValue(':num', $num, SQLITE3_INTEGER);
17 $stmt->execute();
19 $stmt = $conn->query('SELECT num FROM users');
20 $result = $stmt->fetchArray();
H A Dbug63921-64bit.phpt14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
15 $stmt->bindValue(':id', 1, SQLITE3_INTEGER);
16 $stmt->bindValue(':num', $num, SQLITE3_INTEGER);
17 $stmt->execute();
19 $stmt = $conn->query('SELECT num FROM users');
20 $result = $stmt->fetchArray();
/PHP-5.5/ext/pdo/tests/
H A Dpdo_012.phpt23 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
24 var_dump($stmt->fetchAll());
34 unset($stmt);
36 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test');
37 var_dump($stmt->fetchAll());
39 unset($stmt);
41 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
42 $stmt->setFetchMode(PDO::FETCH_CLASS, 'Test', array('Changed'));
43 var_dump($stmt->fetchAll());
H A Dpdo_032.phpt24 $stmt = $db->prepare('SELECT * from test');
25 $stmt->execute();
26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
27 $stmt->closeCursor();
31 $stmt = $db->prepare('SELECT * from test');
32 $stmt->execute();
33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
34 $stmt->closeCursor();
H A Dbug_39656.phpt24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?");
25 $stmt->bindValue(1, 1, PDO::PARAM_INT );
26 $stmt->execute();
27 $row = $stmt->fetch();
30 $stmt->execute();
31 $stmt->closeCursor();
32 $row = $stmt->fetch(); // this line will crash CLI
H A Dpdo_028.phpt18 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)');
23 $stmt->bindValue($i+1, $v);
25 $stmt->execute();
27 $stmt = $db->prepare('SELECT * from test');
28 $stmt->execute();
30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-5.5/ext/pdo_pgsql/tests/
H A Dbug46274_2.phpt24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)");
31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
32 $stmt->execute();
35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
36 $stmt->execute();
43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
44 $stmt->execute();
47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
48 $stmt->execute();

Completed in 31 milliseconds

12345678910>>...16