SQLite3
PHP Manual

SQLite3::changes

(PHP 5 >= 5.3.0, PHP 7)

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

Descrierea

public int SQLite3::changes ( void )

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

Parametri

Această funcție nu are parametri.

Valorile întoarse

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

Exemple

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