PHP 5.4.31 Released

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

Descrição

public int SQLite3::changes ( void )

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

Parâmetros

Esta função não possui parâmetros.

Valor Retornado

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

Exemplos

Exemplo #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 add a note

User Contributed Notes 1 note

up
-1
krebs dot seb at googlemail dot com
2 years ago
It seems, that this method doesn't report the affected rows properly, when using with savepoints or a transaction.
To Top