Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-5.5/ext/mysqli/tests/
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 Dbug33263.phpt23 $stmt = $mysql->prepare("SELECT DATABASE()");
24 $stmt->execute();
25 $stmt->bind_result($database);
26 $stmt->fetch();
27 $stmt->close();
H A D017.phpt16 if (!$stmt = mysqli_prepare($link, "SELECT md5('bar'), database(), 'foo'"))
19 mysqli_stmt_bind_result($stmt, $c0, $c1, $c2);
20 mysqli_stmt_execute($stmt);
22 mysqli_stmt_fetch($stmt);
23 mysqli_stmt_close($stmt);
H A D019.phpt28 …if (!$stmt = mysqli_prepare($link, "INSERT INTO insert_read(col1,col10, col11, col6) VALUES (?,?,?…
31 mysqli_stmt_bind_param($stmt, "issd", $c1, $c2, $c3, $c4);
38 mysqli_stmt_execute($stmt);
39 mysqli_stmt_close($stmt);
41 …if (!$stmt = mysqli_prepare($link, "SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, c…
44 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11);
45 mysqli_stmt_execute($stmt);
47 mysqli_stmt_fetch($stmt);
53 mysqli_stmt_close($stmt);
H A Dbug66043.phpt17 $stmt = $db->stmt_init();
18 $stmt->prepare("SELECT User FROM user WHERE password=\"\"");
19 $stmt->execute();
20 $stmt->bind_result($testArg);
H A Dmysqli_change_user_prepared_statements.phpt16 if (!$stmt = mysqli_prepare($link, "SELECT 'prepared statements should be released'"))
22 if ($stmt->execute() && $stmt->bind_result($wrong) && $stmt->fetch()) {
25 if ($stmt->errno == 0)
H A Dmysqli_stmt_get_result_metadata.phpt20 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);
46 !mysqli_stmt_execute($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 Dbug_mysql_49406.phpt30 if (!$stmt = $link->prepare($query))
33 if (!$stmt->execute() || !$stmt->store_result())
34 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error);
64 $meta_res = $stmt->result_metadata();
81 if (!$stmt->bind_result($row_stmt) || !$stmt->fetch())
82 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error);
90 $stmt->close();
/PHP-5.5/ext/pdo/tests/
H A Dpdo_025.phpt30 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)");
32 $stmt->execute($row);
39 $stmt = $db->prepare('SELECT * FROM test');
40 $stmt->setFetchMode(PDO::FETCH_INTO, new Test);
41 $stmt->execute();
43 foreach($stmt as $obj) {
54 $stmt->setFetchMode(PDO::FETCH_INTO, new Fail);
55 $stmt->execute();
57 foreach($stmt as $obj) {
H A Dpdo_013.phpt23 $stmt = $db->prepare($SELECT);
25 $stmt->execute();
26 $stmt->setFetchMode(PDO::FETCH_NUM);
27 foreach ($stmt as $data)
40 unset($stmt);
47 unset($stmt);
49 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test', array('WOW'));
51 foreach($stmt as $data)
H A Dpdo_019.phpt26 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
28 $stmt->execute();
29 $cont = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE);
34 $stmt->bindColumn('idx', $idx);
35 $stmt->bindColumn('txt', $txt);
36 $stmt->execute();
38 while($stmt->fetch(PDO::FETCH_BOUND)) {
/PHP-5.5/ext/oci8/tests/
H A Derror_bind.phpt22 $stmt = oci_parse($c, "insert into bind_test values (:name)");
23 oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR);
24 var_dump(oci_execute($stmt));
28 var_dump(oci_execute($stmt));
31 oci_bind_by_name($stmt, ":name", $c);
32 var_dump(oci_execute($stmt));
37 $stmt = oci_parse($c, "update bind_test set name='xyz' returning rowid into :r_id");
38 oci_bind_by_name($stmt, ":r_id", $c);
39 var_dump(oci_execute($stmt));
H A Dbug42841.phpt50 $stmt = oci_parse($c, $sql);
52 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR);
54 oci_execute($stmt, OCI_DEFAULT);
61 oci_free_statement($stmt);
68 $stmt = oci_parse($c, $sql);
70 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR);
72 oci_execute($stmt, OCI_DEFAULT);
79 oci_free_statement($stmt);
96 oci_bind_by_name($stmt, ':cur', $cur, -1, OCI_B_CURSOR);
97 oci_execute($stmt, OCI_DEFAULT);
[all …]
H A Dbug37220.phpt29 $stmt = oci_parse ($c, $query);
31 oci_bind_by_name($stmt, ':data', $clob, -1, OCI_B_CLOB);
33 $success = oci_execute($stmt, OCI_COMMIT_ON_SUCCESS);
34 oci_free_statement($stmt);
40 $stmt = oci_parse ($c, $query);
42 oci_execute($stmt);
44 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
/PHP-5.5/ext/pdo_odbc/
H A Dodbc_driver.c41 if (stmt) { in pdo_odbc_fetch_error_func()
42 S = (pdo_odbc_stmt*)stmt->driver_data; in pdo_odbc_fetch_error_func()
70 if (stmt) { in pdo_odbc_error()
71 S = (pdo_odbc_stmt*)stmt->driver_data; in pdo_odbc_error()
74 pdo_err = &stmt->error_code; in pdo_odbc_error()
78 statement = S->stmt; in pdo_odbc_error()
202 stmt->driver_data = S; in odbc_handle_preparer()
203 stmt->methods = &odbc_stmt_methods; in odbc_handle_preparer()
228 PDO_ODBC_HSTMT stmt; in odbc_handle_doer() local
251 rc = SQLRowCount(stmt, &row_count); in odbc_handle_doer()
[all …]
/PHP-5.5/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();
/PHP-5.5/ext/pdo_oci/tests/
H A Dbug46274.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-5.5/ext/pdo_mysql/tests/
H A Dbug_41997.phpt30 $stmt = $db->query("CALL p()");
32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
33 } while ($stmt->nextRowset());
34 var_dump($stmt->errorInfo());
36 $stmt = $db->query('SELECT 2 AS "two"');
37 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
38 var_dump($stmt->errorInfo());
H A Dbug_39858.phpt42 $stmt = $db->prepare("CALL p()");
43 $stmt->execute();
45 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
46 } while ($stmt->nextRowset());
48 $stmt = $db->prepare("CALL p()");
49 $stmt->execute();
51 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
52 } while ($stmt->nextRowset());
53 $stmt->closeCursor();
H A Dpdo_mysql_stmt_bindparam_types.phpt25 if ((!$stmt = @$db->prepare($sql)) || (!@$stmt->execute()))
30 if (!$stmt->bindParam(1, $value)) {
32 var_export($stmt->errorInfo(), true));
35 if (!$stmt->execute()) {
37 var_export($stmt->errorInfo(), true));
43 if (!$stmt->bindColumn(1, $id)) {
48 if (!$stmt->bindColumn(2, $label)) {
54 if (!$stmt->fetch(PDO::FETCH_BOUND)) {
59 $stmt->closeCursor();
68 $stmt->execute();
[all …]
H A Dpdo_mysql_attr_oracle_nulls.phpt28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
35 $stmt = $db->query('SELECT VERSION() as _version');
36 $row = $stmt->fetch(PDO::FETCH_ASSOC);
48 $stmt = $db->prepare('CALL p()');
49 $stmt->execute();
61 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
66 } while ($stmt->nextRowset());
68 $stmt->execute();
70 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
[all …]
H A Dpdo_mysql_stmt_getcolumnmeta.phpt11 $row = $stmt->fetch(PDO::FETCH_ASSOC);
32 $stmt->execute();
57 $stmt->execute();
74 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) {
86 $stmt->execute();
87 $meta = $stmt->getColumnMeta(1);
92 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
145 $stmt->execute();
238 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
259 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
[all …]
H A Dpdo_mysql_pconnect.phpt23 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
27 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1');
28 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
31 $stmt = $db2->query('SELECT CONNECTION_ID() as _con2');
32 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
40 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1');
41 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
63 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1');
64 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
68 $stmt = $db2->query('SELECT CONNECTION_ID() as _con2');
[all …]
/PHP-5.5/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 price');
32 $stmt->execute();
38 unset($stmt);
/PHP-5.5/ext/pdo_pgsql/tests/
H A Dis_in_transaction.phpt24 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)");
25 $stmt->bindValue(1, 1);
26 $stmt->bindValue(2, "test insert");
27 $stmt->execute();
37 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)");
38 $stmt->bindValue(1, "error");
39 $stmt->bindValue(2, "test insert");
40 $stmt->execute();

Completed in 32 milliseconds

12345678910>>...16