(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
Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement.
This function has no parameters.
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();
}
?>