SQLite3::busyTimeout
It seems, that this method doesn't report the affected rows properly, when using with savepoints or a transaction.
SQLite3::changes
(PHP 5 >= 5.3.0)
SQLite3::changes — Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement
Opis
public int SQLite3::changes
( void
)
Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement.
Parametry
Ta funkcja nie posiada parametrów.
Zwracane wartości
Returns an integer value corresponding to the number of database rows changed (or inserted or deleted) by the most recent SQL statement.
Przykłady
Przykład #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();
}
?>
add a note
User Contributed Notes
SQLite3::changes
krebs dot seb at googlemail dot com
10-Nov-2011 06:25