- 3.10 The mysqli_stmt class (mysqli_stmt)
- 3.10.1 mysqli_stmt::$affected_rows, mysqli_stmt_affected_rows
- 3.10.2 mysqli_stmt::attr_get, mysqli_stmt_attr_get
- 3.10.3 mysqli_stmt::attr_set, mysqli_stmt_attr_set
- 3.10.4 mysqli_stmt::bind_param, mysqli_stmt_bind_param
- 3.10.5 mysqli_stmt::bind_result, mysqli_stmt_bind_result
- 3.10.6 mysqli_stmt::close, mysqli_stmt_close
- 3.10.7 mysqli_stmt::data_seek, mysqli_stmt_data_seek
- 3.10.8 mysqli_stmt::$errno, mysqli_stmt_errno
- 3.10.9 mysqli_stmt::$error_list, mysqli_stmt_error_list
- 3.10.10 mysqli_stmt::$error, mysqli_stmt_error
- 3.10.11 mysqli_stmt::execute, mysqli_stmt_execute
- 3.10.12 mysqli_stmt::fetch, mysqli_stmt_fetch
- 3.10.13 mysqli_stmt::$field_count, mysqli_stmt_field_count
- 3.10.14 mysqli_stmt::free_result, mysqli_stmt_free_result
- 3.10.15 mysqli_stmt::get_result, mysqli_stmt_get_result
- 3.10.16 mysqli_stmt::get_warnings, mysqli_stmt_get_warnings
- 3.10.17 mysqli_stmt::$insert_id, mysqli_stmt_insert_id
- 3.10.18 mysqli_stmt::more_results, mysqli_stmt_more_results
- 3.10.19 mysqli_stmt::next_result, mysqli_stmt_next_result
- 3.10.20 mysqli_stmt::$num_rows, mysqli_stmt_num_rows
- 3.10.21 mysqli_stmt::$param_count, mysqli_stmt_param_count
- 3.10.22 mysqli_stmt::prepare, mysqli_stmt_prepare
- 3.10.23 mysqli_stmt::reset, mysqli_stmt_reset
- 3.10.24 mysqli_stmt::result_metadata, mysqli_stmt_result_metadata
- 3.10.25 mysqli_stmt::send_long_data, mysqli_stmt_send_long_data
- 3.10.26 mysqli_stmt::$sqlstate, mysqli_stmt_sqlstate
- 3.10.27 mysqli_stmt::store_result, mysqli_stmt_store_result
Copyright 1997-2012 the PHP Documentation Group.
mysqli_stmt::attr_setmysqli_stmt_attr_setUsed to modify the behavior of a prepared statement
Description
Object oriented style
bool mysqli_stmt::attr_set(int attr,
int mode);Procedural style
bool mysqli_stmt_attr_set(mysqli_stmt stmt,
int attr,
int mode);Used to modify the behavior of a prepared statement. This function may be called multiple times to set several attributes.
Parameters
-
stmt Procedural style only: A statement identifier returned by
mysqli_stmt_init.-
attr The attribute that you want to set. It can have one of the following values:
Table 3.12. Attribute values
Character Description MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH If set to 1, causes mysqli_stmt_store_resultto update the metadataMYSQL_FIELD->max_lengthvalue.MYSQLI_STMT_ATTR_CURSOR_TYPE Type of cursor to open for statement when mysqli_stmt_executeis invoked.modecan beMYSQLI_CURSOR_TYPE_NO_CURSOR(the default) orMYSQLI_CURSOR_TYPE_READ_ONLY.MYSQLI_STMT_ATTR_PREFETCH_ROWS Number of rows to fetch from server at a time when using a cursor. modecan be in the range from 1 to the maximum value of unsigned long. The default is 1.If you use the
MYSQLI_STMT_ATTR_CURSOR_TYPEoption withMYSQLI_CURSOR_TYPE_READ_ONLY, a cursor is opened for the statement when you invokemysqli_stmt_execute. If there is already an open cursor from a previousmysqli_stmt_executecall, it closes the cursor before opening a new one.mysqli_stmt_resetalso closes any open cursor before preparing the statement for re-execution.mysqli_stmt_free_resultcloses any open cursor.If you open a cursor for a prepared statement,
mysqli_stmt_store_resultis unnecessary.-
mode The value to assign to the attribute.
User Comments
Add your own comment.