SQLite3::changes

(PHP 5 >= 5.3.0, PHP 7)

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

public int SQLite3::changes ( void )

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

Returns:

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

Examples:

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

Links:

http://php.net/manual/en/sqlite3.changes.php

doc_php

2025-01-10 15:47:30

Comments