©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_stmt_result_metadata -- maxdb_stmt::result_metadata — Returns result set metadata from a prepared statement
过程化风格
$stmt
)面向对象风格
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:
maxdb_num_fields()
maxdb_fetch_field()
maxdb_fetch_field_direct()
maxdb_fetch_fields()
maxdb_field_count()
maxdb_field_seek()
maxdb_field_tell()
maxdb_free_result()
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 ();
$result = $stmt -> result_metadata ();
$field = $result -> fetch_field ();
printf ( "Fieldname: %s\n" , $field -> name );
$result -> close ();
$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 );
$result = maxdb_stmt_result_metadata ( $stmt );
$field = maxdb_fetch_field ( $result );
printf ( "Fieldname: %s\n" , $field -> name );
maxdb_free_result ( $result );
maxdb_close ( $link );
?>
以上例程的输出类似于:
Fieldname: ID