maxdb_stmt_result_metadata

Description

Procedural style:

Object oriented style (method):

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.

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

Return Values

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

See also:

maxdb_prepare(), maxdb_free_result()

Example

Example 1. Object oriented style <?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. Procedural style <?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); ?>

The above examples would produce the following output:

Fieldname: ID