mysqli_stmt(3) [php man page]

MYSQLI_STMT(3)								 1							    MYSQLI_STMT(3)

The mysqli_stmt class

INTRODUCTION

	Represents a prepared statement.

CLASS SYNOPSIS

       mysqli_stmt

       mysqli_stmt

       Properties

       o

	 int$mysqli_stmt->affected_rows

       o

	 int$mysqli_stmt->errno

       o

	 array$mysqli_stmt->error_list

       o

	 string$mysqli_stmt->error

       o

	 int$mysqli_stmt->field_count

       o

	 int$mysqli_stmt->insert_id

       o

	 int$mysqli_stmt->num_rows

       o

	 int$mysqli_stmt->param_count

       o

	 string$mysqli_stmt->sqlstate

       Methods

       o

	 mysqli_stmt::__construct (mysqli  $link, [string  $query])

       o

	 int mysqli_stmt::attr_get (int  $attr)

       o

	 bool mysqli_stmt::attr_set (int  $attr, int  $mode)

       o

	 bool mysqli_stmt::bind_param (string  $types, mixed  &$var1, [mixed  &$...])

       o

	 bool mysqli_stmt::bind_result (mixed  &$var1, [mixed  &$...])

       o

	 bool mysqli_stmt::close (void	)

       o

	 void mysqli_stmt::data_seek (int  $offset)

       o

	 bool mysqli_stmt::execute (void  )

       o

	 bool mysqli_stmt::fetch (void	)

       o

	 void mysqli_stmt::free_result (void  )

       o

	 mysqli_result mysqli_stmt::get_result (void  )

       o

	 object mysqli_stmt::get_warnings (mysqli_stmt	$stmt)

       o

	 mixed mysqli_stmt::prepare (string  $query)

       o

	 bool mysqli_stmt::reset (void	)

       o

	 mysqli_result mysqli_stmt::result_metadata (void  )

       o

	 bool mysqli_stmt::send_long_data (int	$param_nr, string  $data)

       o

	 bool mysqli_stmt::store_result (void  )

PHP Documentation Group 													    MYSQLI_STMT(3)

MYSQLI_STMT_ATTR_SET(3) 						 1						   MYSQLI_STMT_ATTR_SET(3)

mysqli_stmt::attr_set - Used to modify the behavior of a prepared statement

       Object oriented style

SYNOPSIS

       bool mysqli_stmt::attr_set (int	$attr, int  $mode)

DESCRIPTION

       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

	      o $
		stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).

	      o $attr
		- The attribute that you want to set. It can have one of the following values:

	      Attribute values

	      +-----------------------------------+---------------------------------------------------+
	      | 	   Character		  |						      |
	      | 				  |						      |
	      | 				  |		       Description		      |
	      | 				  |						      |
	      +-----------------------------------+---------------------------------------------------+
	      |MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH |						      |
	      | 				  |						      |
	      | 				  |  Setting	      to	  TRUE	       causes |
	      | 				  | mysqli_stmt_store_result(3) to update  the	meta- |
	      | 				  | data MYSQL_FIELD->max_length value. 	      |
	      | 				  |						      |
	      |   MYSQLI_STMT_ATTR_CURSOR_TYPE	  |						      |
	      | 				  |						      |
	      | 				  |  Type  of  cursor  to  open  for  statement  when |
	      | 				  | mysqli_stmt_execute(3) is invoked. $mode  can  be |
	      | 				  | MYSQLI_CURSOR_TYPE_NO_CURSOR   (the  default)  or |
	      | 				  | MYSQLI_CURSOR_TYPE_READ_ONLY.		      |
	      | 				  |						      |
	      |  MYSQLI_STMT_ATTR_PREFETCH_ROWS   |						      |
	      | 				  |						      |
	      | 				  |  Number of rows to fetch from server  at  a  time |
	      | 				  | when  using  a  cursor. $mode can 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_TYPE option with MYSQLI_CURSOR_TYPE_READ_ONLY, a cursor is opened for the statement when you
	      invoke mysqli_stmt_execute(3). If there is already an open cursor from a previous mysqli_stmt_execute(3) call, it closes the  cursor
	      before  opening  a  new  one.  mysqli_stmt_reset(3)  also  closes  any  open cursor before preparing the statement for re-execution.
	      mysqli_stmt_free_result(3) closes any open cursor.  If you open a cursor for a prepared  statement,  mysqli_stmt_store_result(3)	is
	      unnecessary.

	      o $mode
		-The value to assign to the attribute.

SEE ALSO

       Connector/MySQL mysql_stmt_attr_set().

PHP Documentation Group 												   MYSQLI_STMT_ATTR_SET(3)