SQLite3
在线手册:中文 英文
PHP手册

SQLite3::changes

(PHP 5 >= 5.3.0)

SQLite3::changes Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement

说明

public int SQLite3::changes ( void )

Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement.

参数

此函数没有参数。

返回值

Returns an integer value corresponding to the number of database rows changed (or inserted or deleted) by the most recent SQL statement.

范例

Example #1 SQLite3::changes() example

<?php
$db 
= new SQLite3('mysqlitedb.db');

$query $db->exec('UPDATE counter SET views=0 WHERE page="test"');
if (
$query) {
    echo 
'Number of rows modified: '$db->changes();
}
?>


SQLite3
在线手册:中文 英文
PHP手册
PHP手册 - N: Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement

用户评论:

krebs dot seb at googlemail dot com (10-Nov-2011 09:25)

It seems, that this method doesn't report the affected rows properly, when using with savepoints or a transaction.