SQLite3::changes
PHP function
Edit on GitHub ✎
(PHP 5 >= 5.3.0, PHP 7, PHP 8)
Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement
Description
SQLite3::changes(): int
Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement.
Parameters Parameters
Return Values
Returns an int value corresponding to the number of database rows changed (or inserted or deleted) by the most recent SQL statement.
Examples
SQLite3::changes() example
php
<?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();
}
?>