SQLite3
Note that SQLite3::changes() returns 1 or more even if the row(s) was not actually changed.
<?php
...
$query = $db->exec('UPDATE counter SET views=0 WHERE page="test"');
if ($query) {
echo 'Number of rows modified: ', $db->changes();
}
$query = $db->exec('UPDATE counter SET views=0 WHERE page="test"');
if ($query) {
echo 'Number of rows modified: ', $db->changes();
}
?>
Will print
Number of rows modified: 1 // or more
Number of rows modified: 1 // or more
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
Description
public int SQLite3::changes
( void
)
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 integer 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();
}
?>
add a note
User Contributed NotesSQLite3::changes
Anonymous
19-Jun-2009 10:29
19-Jun-2009 10:29