[+/-]
mysql_stmt_affected_rows()
mysql_stmt_attr_get()
mysql_stmt_attr_set()
mysql_stmt_bind_param()
mysql_stmt_bind_result()
mysql_stmt_close()
mysql_stmt_data_seek()
mysql_stmt_errno()
mysql_stmt_error()
mysql_stmt_execute()
mysql_stmt_fetch()
mysql_stmt_fetch_column()
mysql_stmt_field_count()
mysql_stmt_free_result()
mysql_stmt_init()
mysql_stmt_insert_id()
mysql_stmt_num_rows()
mysql_stmt_param_count()
mysql_stmt_param_metadata()
mysql_stmt_prepare()
mysql_stmt_reset()
mysql_stmt_result_metadata()
mysql_stmt_row_seek()
mysql_stmt_row_tell()
mysql_stmt_send_long_data()
mysql_stmt_sqlstate()
mysql_stmt_store_result()
To prepare and execute queries, use the functions described in detail in the following sections.
In MySQL 4.1.2, the names of several prepared statement functions were changed, as shown here:
Old Name | New Name |
mysql_bind_param() |
mysql_stmt_bind_param() |
mysql_bind_result() |
mysql_stmt_bind_result() |
mysql_prepare() |
mysql_stmt_prepare() |
mysql_execute() |
mysql_stmt_execute() |
mysql_fetch() |
mysql_stmt_fetch() |
mysql_fetch_column() |
mysql_stmt_fetch_column() |
mysql_param_count() |
mysql_stmt_param_count() |
mysql_param_result() |
mysql_stmt_param_metadata() |
mysql_get_metadata() |
mysql_stmt_result_metadata() |
mysql_send_long_data() |
mysql_stmt_send_long_data() |
All functions that operate with a MYSQL_STMT
structure begin with the prefix mysql_stmt_
.
Also in 4.1.2, the signature of the
mysql_stmt_prepare()
function was
changed to int mysql_stmt_prepare(MYSQL_STMT *stmt, const
char *query, unsigned long length)
. To create a
MYSQL_STMT
handle, you should use the
mysql_stmt_init()
function.
User Comments
Add your own comment.