bool mysql_stmt_bind_param(MYSQL_STMT *stmt, MYSQL_BIND *bind)
used to bind input data for the parameter markers in the SQL
statement that was passed to
mysql_stmt_prepare(). It uses
MYSQL_BIND structures to supply the data.
bind is the address of an array of
MYSQL_BIND structures. The client library
expects the array to contain one element for each
? parameter marker that is present in the
Suppose that you prepare the following statement:
INSERT INTO mytbl VALUES(?,?,?)
When you bind the parameters, the array of
MYSQL_BIND structures must contain three
elements, and can be declared like this:
For a description of the members of the
MYSQL_BIND structure and how they should be
set to provide input values, see
Section 6.2, “C API Prepared Statement Data Structures”.
See the Example in Section 6.4.10, “mysql_stmt_execute()”.