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