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

doc_php
2016-02-24 16:18:33
Comments
Leave a Comment

Please login to continue.