Movatterモバイル変換

mysql_stmt_bind_result() is used to associate (that is, bind) output columns in the result set to data buffers and length buffers. Whenmysql_stmt_fetch() is called to fetch data, the MySQL client/server protocol places the data for the bound columns into the specified buffers.

All columns must be bound to buffers prior to callingmysql_stmt_fetch().bind is the address of an array ofMYSQL_BIND structures. The client library expects the array to contain one element for each column of the result set. If you do not bind columns toMYSQL_BIND structures,mysql_stmt_fetch() simply ignores the data fetch. The buffers should be large enough to hold the data values, because the protocol does not return data values in chunks.

A column can be bound or rebound at any time, even after a result set has been partially retrieved. The new binding takes effect the next timemysql_stmt_fetch() is called. Suppose that an application binds the columns in a result set and callsmysql_stmt_fetch(). The client/server protocol returns data in the bound buffers. Then suppose that the application binds the columns to a different set of buffers. The protocol places data into the newly bound buffers when the next call tomysql_stmt_fetch() occurs.

To bind a column, an application callsmysql_stmt_bind_result() and passes the type, address, and length of the output buffer into which the value should be stored.Section 6.2, “C API Prepared Statement Data Structures”, describes the members of eachMYSQL_BIND element and how they should be set to receive output values.

Zero for success. Nonzero if an error occurred.

See the Example inSection 6.4.11, “mysql_stmt_fetch()”.