SQLite3
PHP Manual

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 Manual