/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | bug70313.phpt | 18 $stmt = $db->prepare(");"); 20 $stmt->execute([1]); 27 $stmt = $db->prepare(");"); 29 $stmt->execute([1]);
|
/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_fetch_non_select.phpt | 27 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 39 if (!is_object($stmt = $db->query('SHOW ENGINES'))) 44 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 61 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) 85 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 119 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 151 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) 164 $stmt->execute(); 172 $stmt->execute(); 173 $stmt->execute(); [all …]
|
H A D | pdo_mysql_prepare_native_column.phpt | 20 $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 D | bug46292.phpt | 43 $stmt = $pdoDb->prepare("SELECT * FROM testz"); 45 var_dump($stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE | PDO::FETCH_GROUP)); 46 $stmt->execute(); 48 var_dump($stmt->fetch()); 49 var_dump($stmt->fetch()); 50 var_dump($stmt->fetchAll());
|
H A D | pdo_mysql_stmt_fetch_serialize.phpt | 88 $stmt = $db->prepare('INSERT INTO test(id, myobj) VALUES (?, ?)'); 89 $stmt->bindValue(1, $id); 90 $stmt->bindValue(2, $myobj); 91 $stmt->execute(); 97 $stmt = $db->prepare('SELECT myobj FROM test'); 99 $stmt->execute(); 100 var_dump($stmt->fetch()); 103 $stmt = $db->prepare('SELECT myobj FROM test'); 104 $stmt->setFetchMode(PDO::FETCH_CLASS, 'myclass', array('PDO shall call __construct()')); 105 $stmt->execute(); [all …]
|
H A D | pdo_mysql_begintransaction.phpt | 39 $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 D | pdo_mysql_stmt_fetch_serialize_simple.phpt | 48 $stmt = $db->prepare('SELECT myobj FROM test'); 49 $stmt->execute(); 50 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO')); 53 $stmt->execute(); 54 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass'); 58 $stmt = $db->prepare('SELECT myobj FROM test'); 59 $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO')); 60 $stmt->execute(); 61 var_dump($stmt->fetch());
|
H A D | pdo_mysql_stmt_nextrowset.phpt | 32 $stmt = $db->query('SELECT id FROM test'); 33 if (false !== ($tmp = $stmt->nextRowSet())) 37 if (false !== ($tmp = $stmt->nextRowSet(1))) 43 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 45 while ($stmt->fetch()) ; 51 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 52 var_dump($stmt->nextRowSet()); 60 $stmt = $db->query('CALL p()'); 62 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 63 } while ($stmt->nextRowSet()); [all …]
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_007.phpt | 22 $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 D | pdo_031.phpt | 26 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 28 $stmt->execute($row); 31 unset($stmt); 35 $stmt = $db->query('SELECT * FROM test'); 37 foreach(new RecursiveTreeIterator(new RecursiveArrayIterator($stmt->fetchAll(PDO::FETCH_ASSOC)), Re…
|
/PHP-7.4/ext/mysqli/ |
H A D | mysqli_priv.h | 65 extern void php_clear_stmt_bind(MY_STMT *stmt); 137 #define MYSQLI_REPORT_STMT_ERROR(stmt) \ argument 138 if ((MyG(report_mode) & MYSQLI_REPORT_ERROR) && mysql_stmt_errno(stmt)) { \ 139 …php_mysqli_report_error(mysql_stmt_sqlstate(stmt), mysql_stmt_errno(stmt), mysql_stmt_error(stmt))…
|
/PHP-7.4/ext/oci8/tests/ |
H A D | select_null.phpt | 12 $stmt = oci_parse($pc, "select NULL from dual"); 13 oci_execute($stmt); 14 var_dump(oci_fetch_array($stmt, OCI_RETURN_NULLS));
|
H A D | bug37581.phpt | 33 $stmt = oci_parse($c,'begin bug37581_pkg.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);
|
/PHP-7.4/ext/pdo_dblib/tests/ |
H A D | bug_71667.phpt | 12 $stmt = $db->prepare("SELECT 1, 2 AS named, 3"); 13 $stmt->execute(); 14 var_dump($stmt->fetchAll());
|
H A D | bug_68957.phpt | 13 $stmt = $db->query($query); 14 $stmt->nextRowset(); // Added line 15 $rows = $stmt->fetchAll();
|
H A D | stringify_uniqueidentifier.phpt | 31 $stmt = $db->query($sql); 32 $row = $stmt->fetch(PDO::FETCH_ASSOC); 41 $stmt = $db->query($sql); 42 $row = $stmt->fetch(PDO::FETCH_ASSOC); 55 $stmt = $db->query($sql); 56 $row = $stmt->fetch(PDO::FETCH_ASSOC);
|
/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_stmt_get_result_seek.phpt | 16 if (!$stmt = mysqli_stmt_init($link)) 19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3")) 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)); 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)); 42 $i, mysqli_stmt_errno($stmt), $stmt->error); 90 mysqli_stmt_close($stmt);
|
H A D | bug35517.phpt | 16 $stmt = $mysql->prepare("SELECT id FROM temp"); 17 $stmt->execute(); 18 $stmt->bind_result($id); 19 while ($stmt->fetch()) { 31 $stmt->close();
|
H A D | mysqli_stmt_prepare.phpt | 30 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 (false !== ($tmp = mysqli_stmt_prepare($stmt, "SELECT id FROM test")))
|
H A D | mysqli_stmt_attr_get.phpt | 41 $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 (false !== ($tmp = @mysqli_stmt_attr_get($stmt, $attr))) {
|
/PHP-7.4/ext/sqlite3/tests/ |
H A D | bug76665.phpt | 11 $stmt = $db->prepare("INSERT INTO foo VALUES (:bar)"); 12 $stmt->bindValue(':bar', 17, SQLITE3_FLOAT); 13 $stmt->execute();
|
/PHP-7.4/ext/pdo_sqlite/tests/ |
H A D | bug79664.phpt | 12 $stmt = $pdo->query('select 1 where 0'); 13 if ($stmt->columnCount()) { 14 var_dump($stmt->getColumnMeta(0));
|
/PHP-7.4/ext/pdo_odbc/tests/ |
H A D | bug80783.phpt | 18 $stmt = $db->prepare("SELECT name FROM bug80783"); 19 $stmt->bindColumn(1, $data, PDO::PARAM_LOB); 20 $stmt->execute(); 21 $stmt->fetch(PDO::FETCH_BOUND);
|
/PHP-7.4/ext/pdo_odbc/ |
H A D | php_pdo_odbc_int.h | 146 PDO_ODBC_HSTMT stmt; member 169 void pdo_odbc_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, PDO_ODBC_HSTMT statement, char *what, const c… 171 #define pdo_odbc_stmt_error(what) pdo_odbc_error(stmt->dbh, stmt, SQL_NULL_HSTMT, what, __FILE__, _… 172 #define pdo_odbc_doer_error(what) pdo_odbc_error(dbh, NULL, stmt, what, __FILE__, __LINE__)
|
/PHP-7.4/ext/pdo_oci/ |
H A D | oci_driver.c | 41 if (stmt) { in pdo_oci_fetch_error_func() 67 if (stmt) { in _oci_error() 68 S = (pdo_oci_stmt*)stmt->driver_data; in _oci_error() 70 pdo_err = &stmt->error_code; in _oci_error() 168 if (stmt) { in _oci_error() 306 stmt->driver_data = S; in oci_handle_preparer() 307 stmt->methods = &oci_stmt_methods; in oci_handle_preparer() 320 OCIStmt *stmt; in oci_handle_doer() local 330 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer() 338 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer() [all …]
|