©
本文档使用 PHP中文网手册 发布
(PECL maxdb >= 1.0)
maxdb_stmt_affected_rows -- maxdb_stmt::affected_rows — Returns the total number of rows changed, deleted, or inserted by the last executed statement
过程化风格
$stmt
)面向对象风格
maxdb_stmt_affected_rows() returns the number of rows affected by INSERT, UPDATE, or DELETE query. If the last query was invalid or the number of rows can not determined, this function will return -1.
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 or the number of rows can not determined.
Example #1 面向对象风格
<?php
$maxdb = new maxdb ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
$maxdb -> query ( "CREATE TABLE temp.mycity LIKE hotel.city" );
$query = "INSERT INTO temp.mycity SELECT * FROM hotel.city WHERE state LIKE ?" ;
if ( $stmt = $maxdb -> prepare ( $query )) {
$code = 'N%' ;
$stmt -> bind_param ( "s" , $code );
$stmt -> execute ();
printf ( "rows inserted: %d\n" , $stmt -> affected_rows );
$stmt -> close ();
}
$maxdb -> close ();
?>
Example #2 过程化风格
<?php
$link = maxdb_connect ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
maxdb_query ( $link , "CREATE TABLE temp.mycity LIKE hotel.city" );
$query = "INSERT INTO temp.mycity SELECT * FROM hotel.city WHERE state LIKE ?" ;
if ( $stmt = maxdb_prepare ( $link , $query )) {
$code = 'N%' ;
maxdb_stmt_bind_param ( $stmt , "s" , $code );
maxdb_stmt_execute ( $stmt );
printf ( "rows inserted: %d\n" , maxdb_stmt_affected_rows ( $stmt ));
maxdb_stmt_close ( $stmt );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
rows inserted: 4