(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
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();
}
?>