SQLite3::changes
(PHP 5 >= 5.3.0, PHP 7, PHP 8)
SQLite3::changes — Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement
Description
Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement.
Parameters
This function has no 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
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();
}
?>来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
