« mysqli::$warning_count
mysqli_stmt::$affected_rows »
PHP Manual
Mysqli
MySQLi_STMT类
MySQLi_STMT类
(PHP 5, PHP 7)
简介
代表一个预编译 SQL 语句。
类摘要
mysqli_stmt
{
/* 属性 */
int
$
affected_rows
;
int
$
errno
;
array
$
error_list
;
string
$
error
;
int
$
field_count
;
int
$
insert_id
;
int
$
num_rows
;
int
$
param_count
;
string
$
sqlstate
;
/* 方法 */
mysqli_stmt_affected_rows
(
mysqli_stmt
$stmt
) :
int
attr_get
(
int
$attr
) :
int
attr_set
(
int
$attr
,
int
$mode
) :
bool
bind_param
(
string
$types
,
mixed
&$var1
[,
mixed
&$...
] ) :
bool
bind_result
(
mixed
&$var1
[,
mixed
&$...
] ) :
bool
close
(
void
) :
bool
data_seek
(
int
$offset
) :
void
mysqli_stmt_errno
(
mysqli_stmt
$stmt
) :
int
mysqli_stmt_error_list
(
mysqli_stmt
$stmt
) :
array
mysqli_stmt_error
(
mysqli_stmt
$stmt
) :
string
execute
(
void
) :
bool
fetch
(
void
) :
bool
mysqli_stmt_field_count
(
mysqli_stmt
$stmt
) :
int
free_result
(
void
) :
void
get_result
(
void
) :
mysqli_result
get_warnings
(
void
) :
object
mysqli_stmt_insert_id
(
mysqli_stmt
$stmt
) :
mixed
public
more_results
(
void
) :
bool
public
next_result
(
void
) :
bool
num_rows
(
void
) :
int
mysqli_stmt_param_count
(
mysqli_stmt
$stmt
) :
int
prepare
(
string
$query
) :
mixed
reset
(
void
) :
bool
result_metadata
(
void
) :
mysqli_result
send_long_data
(
int
$param_nr
,
string
$data
) :
bool
mysqli_stmt_sqlstate
(
mysqli_stmt
$stmt
) :
string
store_result
(
void
) :
bool
}
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::__construct
— Constructs a new mysqli_stmt object
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_list
— Returns a list of errors from the last statement executed
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_result
— Gets a result set from a prepared statement
mysqli_stmt::get_warnings
— Get result of SHOW WARNINGS
mysqli_stmt::$insert_id
— Get the ID generated from the previous INSERT operation
mysqli_stmt::more_results
— Check if there are more query results from a multiple query
mysqli_stmt::next_result
— Reads the next result from a multiple query
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