|
PHP5中文手册
mysqli_stmt_affected_rowsmysqli_stmt->affected_rows(PHP 5) mysqli_stmt->affected_rows — Returns the total number of rows changed, deleted, or inserted by the last executed statement 说明Procedural style :
int mysqli_stmt_affected_rows
( mysqli_stmt $stmt
)
Object oriented style (property): mysqli_stmt
int$affected_rows;
Returns the number of rows affected by INSERT, UPDATE, or DELETE query. This function only works with queries which update a table. In order to get the number of rows from a SELECT query, use mysqli_stmt_num_rows() instead. 返回值An integer greater than zero indicates the number of rows affected or retrieved. Zero indicates that no records where updated for an UPDATE/DELETE statement, no rows matched the WHERE clause in the query or that no query has yet been executed. -1 indicates that the query has returned an error.
范例Example#1 Object oriented style
<?php Example#2 Procedural style
<?php 上例将输出:
|