SQLITE_CHANGES(3)														 SQLITE_CHANGES(3)

sqlite_changes - Returns the number of rows that were changed by the most recent SQL statement

SYNOPSIS

       int sqlite_changes (resource  $dbhandle)

DESCRIPTION

       Object oriented style (method): int SQLiteDatabase::changes (void  )

	Returns the numbers of rows that were changed by the most recent SQL statement executed against the $dbhandle database handle.

PARAMETERS

	      o $dbhandle
		- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
		object-oriented method.

RETURN VALUES

	Returns the number of changed rows.

EXAMPLES

       Example #1

	      Procedural style

	      <?php
	      $dbhandle = sqlite_open('mysqlitedb');
	      $query = sqlite_query($dbhandle, "UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'");
	      if (!$query) {
		  exit('Error in query.');
	      } else {
		  echo 'Number of rows modified: ', sqlite_changes($dbhandle);
	      }
	      ?>

       Example #2

	      Object oriented style

	      <?php
	      $dbhandle = new SQLiteDatabase('mysqlitedb');
	      $query = $dbhandle->query("UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'");
	      if (!$query) {
		  exit('Error in query.');
	      } else {
		  echo 'Number of rows modified: ', $dbhandle->changes();
	      }
	      ?>

SEE ALSO

       sqlite_open(3).

PHP Documentation Group 													 SQLITE_CHANGES(3)