Home
last modified time | relevance | path

Searched refs:stmt (Results 151 – 175 of 434) sorted by relevance

12345678910>>...18

/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_errorinfo.phpt25 var_dump($stmt->errorInfo());
26 $stmt->execute();
27 var_dump($stmt->errorInfo());
30 $stmt = $db->prepare("SELECT label FROM {$table} ORDER BY id ASC LIMIT 1");
32 var_dump($stmt->execute());
33 var_dump($stmt->errorInfo());
48 var_dump($stmt);
51 $stmt = $db->prepare("SELECT label FROM {$table} ORDER BY id ASC LIMIT 1");
52 var_dump($stmt->errorInfo());
54 $stmt->execute();
[all …]
H A Dpdo_mysql_attr_oracle_nulls.phpt35 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
39 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
42 $stmt = $db->query('SELECT VERSION() as _version');
43 $row = $stmt->fetch(PDO::FETCH_ASSOC);
55 $stmt = $db->prepare("CALL {$procedure}()");
56 $stmt->execute();
58 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
59 } while ($stmt->nextRowset());
61 $stmt->execute();
63 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
[all …]
H A Dpdo_mysql_errorcode.phpt37 $stmt = $db->query("SELECT id, label FROM {$table}");
38 $stmt2 = &$stmt;
40 check_error(4, $stmt);
43 @$stmt->execute();
45 check_error(5, $stmt, '42S02');
49 @$stmt = $db->query('SELECT id, label FROM pdo_mysql_errorcode_unknown');
53 $stmt = $db->query("SELECT id, label FROM {$table}");
55 check_error(9, $stmt);
61 check_error(12, $stmt);
69 check_error(16, $stmt);
H A Dpdo_mysql_attr_fetch_table_names.phpt20 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1");
21 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
22 $stmt->closeCursor();
26 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1");
27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
28 $stmt->closeCursor();
H A Dpdo_mysql_prepare_emulated_myisam_index.phpt21 $stmt = @$db->prepare($query);
23 $stmt = $db->prepare($query);
49 $ret = @$stmt->execute($input_params);
51 $ret = $stmt->execute($input_params);
58 $tmp = $stmt->errorInfo();
84 return $stmt;
133 $stmt = prepex(14, $db, $sql, array(-1));
134 if (count(($tmp = $stmt->fetchAll(PDO::FETCH_ASSOC))) != 0)
140 $stmt = prepex(15, $db, $sql, array(1));
145 $stmt = prepex(16, $db, $sql, array(1, 1));
[all …]
H A Dpdo_mysql_prepare_native_anonymous_placeholder.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;
138 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
200 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
217 $stmt = prepex(30, $db, $sql, array(-1));
[all …]
H A Dpdo_mysql_prepare_native.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;
105 $stmt = prepex(4, $db, 'SELECT 1 as "one"');
113 $row = $stmt->fetch(PDO::FETCH_ASSOC);
121 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
[all …]
/php-src/ext/pdo/tests/
H A Dbug_39656.phpt24 $stmt = $db->prepare("SELECT * FROM test39656 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.phpt19 $stmt = $db->prepare('INSERT INTO test028 values (1, ?, ?, ?)');
24 $stmt->bindValue($i+1, $v);
26 $stmt->execute();
28 $stmt = $db->prepare('SELECT * from test028');
29 $stmt->execute();
31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/php-src/ext/mysqli/tests/
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 Dbug33263.phpt23 $stmt = $mysql->prepare("SELECT DATABASE()");
24 $stmt->execute();
25 $stmt->bind_result($database);
26 $stmt->fetch();
27 $stmt->close();
H A Dbug35759.phpt36 $stmt = $mysql->prepare("SELECT * FROM test");
37 if ($stmt) {
39 $stmt->execute();
40 $stmt->store_result();
44 call_user_func_array(array($stmt, "bind_result"), $params);
45 $stmt->fetch();
47 $stmt->close();
H A Dgh12107.phpt24 $stmt = $mysqli->prepare("call `gh12107`()");
25 $stmt->execute();
26 $stmt->bind_result($output);
27 var_dump($stmt->fetch());
33 $stmt->execute();
34 $stmt->bind_result($output);
35 var_dump($stmt->fetch());
H A Dmysqli_stmt_get_result_types.phpt33 … printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
39 … printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 mysqli_stmt_close($stmt);
51 mysqli_stmt_close($stmt);
56 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
57 mysqli_stmt_close($stmt);
62 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
63 mysqli_stmt_close($stmt);
70 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
95 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
[all …]
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 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.phpt20 if (!($stmt = mysqli_stmt_init($link)) ||
21 …!mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') ___label FROM te…
22 !mysqli_stmt_execute($stmt))
23 printf("[001] [%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));
30 if (!is_object($res_meta = mysqli_stmt_result_metadata($stmt)) ||
33 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
57 mysqli_stmt_close($stmt);
/php-src/ext/sqlite3/tests/
H A Dsqlite3_28_clear_bindings.phpt19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
22 var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT));
24 $results = $stmt->execute();
28 $stmt->reset();
29 $stmt->clear();
30 var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT));
31 $results = $stmt->execute();
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-src/ext/pdo_pgsql/tests/
H A Dbug43925.phpt29 $stmt = $dbh->prepare('
39 $stmt->bindValue('left', 1, PDO::PARAM_INT);
40 $stmt->bindValue('rootId', 3, PDO::PARAM_INT);
41 $stmt->bindValue('x', 5, PDO::PARAM_INT);
42 $stmt->bindValue('y', 50, PDO::PARAM_INT);
44 $stmt->execute();
46 foreach ($stmt->fetchAll() as $row) {
H A Dbug71885_2.phpt31 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?");
32 $stmt->execute(['b']);
33 var_dump($stmt->fetch());
35 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???");
36 $stmt->execute(['a']);
37 var_dump($stmt->fetch());
H A Dbug46274_2.phpt26 $stmt = $db->prepare("INSERT INTO test_one_blob_46274_2 (blob1) VALUES (:foo)");
33 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
34 $stmt->execute();
37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
38 $stmt->execute();
45 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
46 $stmt->execute();
49 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
50 $stmt->execute();
/php-src/ext/mysqlnd/
H A Dmysqlnd_driver.c193 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local
198 stmt = ret->data = mnd_ecalloc(1, sizeof(MYSQLND_STMT_DATA)); in MYSQLND_METHOD()
199 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD()
201 mysqlnd_error_info_init(&stmt->error_info_impl, 0); in MYSQLND_METHOD()
202 stmt->error_info = &stmt->error_info_impl; in MYSQLND_METHOD()
204 mysqlnd_upsert_status_init(&stmt->upsert_status_impl); in MYSQLND_METHOD()
205 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD()
206 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD()
208 stmt->execute_cmd_buffer.buffer = mnd_emalloc(stmt->execute_cmd_buffer.length); in MYSQLND_METHOD()
209 stmt->prefetch_rows = MYSQLND_DEFAULT_PREFETCH_ROWS; in MYSQLND_METHOD()
[all …]
/php-src/ext/pdo/
H A Dphp_pdo_driver.h317 typedef int (*pdo_stmt_dtor_func)(pdo_stmt_t *stmt);
320 typedef int (*pdo_stmt_execute_func)(pdo_stmt_t *stmt);
325 typedef int (*pdo_stmt_fetch_func)(pdo_stmt_t *stmt,
330 typedef int (*pdo_stmt_describe_col_func)(pdo_stmt_t *stmt, int colno);
338 pdo_stmt_t *stmt, int colno, zval *result, enum pdo_param_type *type);
393 typedef int (*pdo_stmt_next_rowset_func)(pdo_stmt_t *stmt);
399 typedef int (*pdo_stmt_cursor_closer_func)(pdo_stmt_t *stmt);
545 pdo_stmt_t *stmt; /* for convenience in dtor */ member
647 pdo_stmt_t *stmt; member
679 PDO_API void pdo_raise_impl_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt,
[all …]
/php-src/ext/mysqli/tests/bind_fetch/
H A Dsystem_variable.phpt18 $stmt = mysqli_prepare($link, "SELECT @@autocommit");
20 mysqli_stmt_bind_result($stmt, $c0);
21 mysqli_stmt_execute($stmt);
23 mysqli_stmt_fetch($stmt);

Completed in 43 milliseconds

12345678910>>...18