maxdb_stmt_store_result

maxdb_stmt::store_result

(PECL maxdb >= 1.0)

maxdb_stmt_store_result -- maxdb_stmt::store_result — Transfers a result set from a prepared statement

说明

过程化风格

maxdb_stmt_store_result ( resource $stmt ) : bool

面向对象风格

maxdb_stmt::store_result ( void ) : object

maxdb_stmt_store_result() has no functionally effect and should not be used for retrieving data from MaxDB server.

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

范例

Example #1 面向对象风格

<?php
/* Open a connection */
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT name, zip FROM hotel.city ORDER BY name";
if ($stmt = $maxdb->prepare($query)) {

   /* execute query */
   $stmt->execute();

   /* store result */
   $stmt->store_result();

   printf("Number of rows: %d.\n", $stmt->num_rows);

   /* free result */
   $stmt->free_result();

   /* close statement */
   $stmt->close();
}

/* close connection */
$maxdb->close();
?>

Example #2 过程化风格

<?php
/* Open a connection */
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT name, zip FROM hotel.city ORDER BY name";
if ($stmt = maxdb_prepare($link, $query)) {

   /* execute query */
   maxdb_stmt_execute($stmt);

   /* store result */
   maxdb_stmt_store_result($stmt);

   printf("Number of rows: %d.\n", maxdb_stmt_num_rows($stmt));

   /* free result */
   maxdb_stmt_free_result($stmt);

   /* close statement */
   maxdb_stmt_close($stmt);
}

/* close connection */
maxdb_close($link);
?>

以上例程的输出类似于：

Number of rows: 25.

参见

相关文章
php ibm db2 函数 requests the next result set from a stored procedurephp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp maxdb 函数 set result pointer to a specified field offsetphp maxdb 函数 prepare next result from multi queryphp maxdb 函数 binds variables to a prepared statement for result storagephp maxdb 函数 seeks to an arbitray row in statement result setphp maxdb 函数 fetch results from a prepared statement into the bound variablesphp maxdb 函数 frees stored result memory for the given statement handlephp maxdb 函数 return the number of rows in statements result setphp maxdb 函数 returns result set metadata from a prepared statementphp maxdb 函数 transfers a result set from a prepared statementphp maxdb 函数 transfers a result set from the last queryphp maxdb 函数 initiate a result set retrievalphp oci8 函数 returns the next child statement resource from a parent statement resource that has oracle database 12c implicit result setsphp postgresql 函数 sends a request to execute a prepared statement with given parameters without waiting for the result s php sqlite 函数 fetches a column from the current row of a result setphp mysqli stmt gets a result set from a prepared statementphp mysqli stmt returns result set metadata from a prepared statementphp mysqli stmt transfers a result set from a prepared statementphp mysqlnduhconnection transfers a result set from the last query
关注编程学问公众号