maxdb_stmt_result_metadata

maxdb_stmt::result_metadata

(PECL maxdb >= 1.0)

maxdb_stmt_result_metadata -- maxdb_stmt::result_metadata — Returns result set metadata from a prepared statement

说明

过程化风格

maxdb_stmt_result_metadata ( resource $stmt ) : resource

面向对象风格

maxdb_stmt::result_metadata ( void ) : resource

If a statement passed to maxdb_prepare() is one that produces a result set, maxdb_stmt_result_metadata() returns the result resource that can be used to process the meta information such as total number of fields and individual field information.

Note:

This result set pointer can be passed as an argument to any of the field-based functions that process result set metadata, such as:

The result set structure should be freed when you are done with it, which you can do by passing it to maxdb_free_result()

Note:

The result set returned by maxdb_stmt_result_metadata() contains only metadata. It does not contain any row results. The rows are obtained by using the statement handle with maxdb_fetch().

返回值

maxdb_stmt_result_metadata() returns a result resource or FALSE if an error occurred.

范例

Example #1 面向对象风格

<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

$maxdb->query("CREATE TABLE temp.friends (id int, name varchar(20))");

$maxdb->query("INSERT INTO temp.friends VALUES (1,'Hartmut')");
$maxdb->query("INSERT INTO temp.friends VALUES (2, 'Ulf')");

$stmt = $maxdb->prepare("SELECT id, name FROM temp.friends");
$stmt->execute();

/* get resultset for metadata */
$result = $stmt->result_metadata();

/* retrieve field information from metadata result set */
$field = $result->fetch_field();

printf("Fieldname: %s\n", $field->name);

/* close resultset */
$result->close();

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

Example #2 过程化风格

<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

maxdb_query($link, "CREATE TABLE temp.friends (id int, name varchar(20))");

maxdb_query($link, "INSERT INTO temp.friends VALUES (1,'Hartmut')");
maxdb_query($link, "INSERT INTO temp.friends VALUES (2, 'Ulf')");

$stmt = maxdb_prepare($link, "SELECT id, name FROM temp.friends");
maxdb_stmt_execute($stmt);

/* get resultset for metadata */
$result = maxdb_stmt_result_metadata($stmt);

/* retrieve field information from metadata result set */
$field = maxdb_fetch_field($result);

printf("Fieldname: %s\n", $field->name);

/* close resultset */
maxdb_free_result($result);

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

以上例程的输出类似于：

Fieldname: ID

参见

相关文章
php ibm db2 函数 returns a result set listing the columns and associated metadata for a tablephp ibm db2 函数 returns a single column from a row in the result setphp ibm db2 函数 returns a result set listing the tables and associated metadata in a databasephp maxdb 函数 returns the error code from last connect callphp maxdb 函数 returns the next field in the result setphp maxdb 函数 returns an array of resources representing the fields in a result setphp maxdb 函数 returns the lengths of the columns of the current row in the result setphp maxdb 函数 returns the current row of a result set as an objectphp 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 函数 returns result set metadata from a prepared statementphp maxdb 函数 returns sqlstate error from previous statement operationphp maxdb 函数 transfers a result set from a prepared statementphp maxdb 函数 transfers a result set from the last queryphp oci8 函数 returns the next child statement resource from a parent statement resource that has oracle database 12c implicit result setsphp 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 sqlite3stmt executes a prepared statement and returns a result set object
关注编程学问公众号