SQLite3::changes

(PHP 5 >= 5.3.0, PHP 7, PHP 8)

SQLite3::changes — Devuelve el nĂșmero de lĂ­neas modificadas (o insertadas, borradas) por la Ășltima consulta SQL

DescripciĂłn

public function SQLite3::changes(): int

Devuelve el nĂșmero de lĂ­neas modificadas (o insertadas, borradas) por la Ășltima consulta SQL.

ParĂĄmetros

Esta funciĂłn no contiene ningĂșn parĂĄmetro.

Valores devueltos

Devuelve un int correspondiente al nĂșmero de lĂ­neas modificadas (o insertadas, borradas) por la Ășltima consulta SQL.

Ejemplos

Ejemplo #1 Ejemplo con SQLite3::changes()

<?php
$db = new SQLite3('mysqlitedb.db');

$query = $db->exec('UPDATE counter SET views=0 WHERE page="test"');
if ($query) {
echo 'NĂșmero de lĂ­neas modificadas : ', $db->changes();
}
?>

Found A Problem?

Learn How To Improve This Page ‱ Submit a Pull Request ‱ Report a Bug
add a note

User Contributed Notes 1 note

up
3
teclado at tandex dot com ¶
10 years ago
There is an issue that may be meant or not, but in my case is annoying. If you have have a schema like the following:

[code]
pragma foreign_key = on;
create table parent (
  id integer,
  a varchar,
  primary key (id asc)
);
create table child (
  id integer,
  b varchar,
  a integer,
  primary key (id asc),
  foreign key (a) references a (id) on delete cascade on update cascade
);
[/code]

When you try to delete a parent row (delete from parent where parent.id=?) it deletes all the childs referenced to this parent, but the method SQLite3::changes() is still returning 1, as if it only have deleted the parent.
add a note