|
Последние активные темы форума |
|
maxdb_stmt_result_metadata
(no version information, might be only in CVS) maxdb_stmt_result_metadata -- Returns result set metadata from a prepared statement
DescriptionПроцедурный стиль: mixed maxdb_stmt_result_metadata ( resource 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.
Замечание: 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()
Замечание:
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 occured.
Example
Пример 1. Процедурный стиль
<?php
$link
=
maxdb_connect
(
"localhost"
,
"MONA"
,
"RED"
);
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
);
?>
|
|
The above examples would produce the following output:
|