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

說明

public SQLite3::changes(): int

Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement.

參數(shù)

此函數(shù)沒有參數(shù)。

返回值

Returns an int value corresponding to the number of database rows changed (or inserted or deleted) by the most recent SQL statement.

范例

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