mysqli->warning_count
mysqli_stmt->affected_rows
Mysqli
PHP Manual
The MySQLi_STMT class
Introduction
Represents a prepared statement.
Class synopsis
MySQLi_STMT
{
/* Properties */
int
$affected_rows
;
int
$errno
;
string
$error
;
int
$field_count
;
int
$insert_id
;
int
$num_rows
;
int
$param_count
;
string
$sqlstate
;
/* Methods */
int
MySQLi_STMT::mysqli_stmt_affected_rows
(
mysqli_stmt
$stmt
)
int
mysqli_stmt::attr_get
(
int
$attr
)
bool
mysqli_stmt::attr_set
(
int
$attr
,
int
$mode
)
bool
mysqli_stmt::bind_param
(
string
$types
,
mixed
&$var1
[,
mixed
&$...
] )
bool
mysqli_stmt::bind_result
(
mixed
&$var1
[,
mixed
&$...
] )
bool
mysqli_stmt::close
(
void
)
void
mysqli_stmt::data_seek
(
int
$offset
)
int
mysqli_stmt_errno
(
mysqli_stmt
$stmt
)
string
mysqli_stmt_error
(
mysqli_stmt
$stmt
)
bool
mysqli_stmt::execute
(
void
)
bool
mysqli_stmt::fetch
(
void
)
int
mysqli_stmt_field_count
(
mysqli_stmt
$stmt
)
void
mysqli_stmt::free_result
(
void
)
object
mysqli_stmt::get_warnings
(
mysqli_stmt
$stmt
)
mixed
mysqli_stmt_insert_id
(
mysqli_stmt
$stmt
)
int
mysqli_stmt_num_rows
(
mysqli_stmt
$stmt
)
int
mysqli_stmt_param_count
(
mysqli_stmt
$stmt
)
mixed
mysqli_stmt::prepare
(
string
$query
)
bool
mysqli_stmt::reset
(
void
)
mysqli_result
mysqli_stmt::result_metadata
(
void
)
bool
mysqli_stmt::send_long_data
(
int
$param_nr
,
string
$data
)
string
mysqli_stmt_sqlstate
(
mysqli_stmt
$stmt
)
bool
mysqli_stmt::store_result
(
void
)
}
Table of Contents
mysqli_stmt->affected_rows
— Returns the total number of rows changed, deleted, or inserted by the last executed statement
mysqli_stmt::attr_get
— Used to get the current value of a statement attribute
mysqli_stmt::attr_set
— Used to modify the behavior of a prepared statement
mysqli_stmt::bind_param
— Binds variables to a prepared statement as parameters
mysqli_stmt::bind_result
— Binds variables to a prepared statement for result storage
mysqli_stmt::close
— Closes a prepared statement
mysqli_stmt::data_seek
— Seeks to an arbitrary row in statement result set
mysqli_stmt->errno
— Returns the error code for the most recent statement call
mysqli_stmt->error
— Returns a string description for last statement error
mysqli_stmt::execute
— Executes a prepared Query
mysqli_stmt::fetch
— Fetch results from a prepared statement into the bound variables
mysqli_stmt->field_count
— Returns the number of field in the given statement
mysqli_stmt::free_result
— Frees stored result memory for the given statement handle
mysqli_stmt::get_warnings
— Get result of SHOW WARNINGS
mysqli_stmt->insert_id
— Get the ID generated from the previous INSERT operation
mysqli_stmt::num_rows
— Return the number of rows in statements result set
mysqli_stmt->param_count
— Returns the number of parameter for the given statement
mysqli_stmt::prepare
— Prepare an SQL statement for execution
mysqli_stmt::reset
— Resets a prepared statement
mysqli_stmt::result_metadata
— Returns result set metadata from a prepared statement
mysqli_stmt::send_long_data
— Send data in blocks
mysqli_stmt::sqlstate
— Returns SQLSTATE error from previous statement operation
mysqli_stmt::store_result
— Transfers a result set from a prepared statement
mysqli->warning_count
mysqli_stmt->affected_rows
Mysqli
PHP Manual