php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #33841 PDO_SQLITE: $stmt->rowCount() always returns 0 on INSERT, UPDATE and DELETE
Submitted: 2005-07-23 23:23 UTC Modified: 2005-07-24 01:32 UTC
From: people05 at sopic dot com Assigned:
Status: Closed Package: PDO related
PHP Version: 5.1.0b3 OS: Debian GNU/Linux 3.1
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: people05 at sopic dot com
New email:
PHP Version: OS:

 

 [2005-07-23 23:23 UTC] people05 at sopic dot com
Description:
------------
I'm not sure if it's a error in the docs or a PDO bug. http://
www.php.net/manual/en/function.pdostatement-rowcount.php says, 
"PDOStatement::rowCount() returns the number of rows affected 
by the last DELETE, INSERT, or UPDATE statement executed by 
the corresponding PDOStatement object." When I execute my code 
sample, $stmt->rowCount() always returns int(0) instead of the 
expected int(1).

Some lines down the page, the docs say that rowCount() doesn't 
work on a SELECT with the most databases, but there's no 
exception for INSERT, UPDATE or DELETE.

Reproduce code:
---------------
<?php

try {
	$db = new PDO("sqlite:/tmp/sqlite.sdb");
	$stmt = $db->prepare("INSERT INTO test ( name ) VALUES ( :name ) ");
	$stmt->bindParam(':name', $name);
	$name = 'Andreas';
	$stmt->execute();
	var_dump($stmt->rowCount());
	$last_insert_id = $db->lastInsertId();
	$stmt = $db->prepare("UPDATE test SET name = :name ");
	$stmt->bindParam(':name', $name);
	$name = 'Peter';
	$stmt->execute();
	var_dump($stmt->rowCount());
	$stmt = $db->prepare("DELETE FROM test");
	$stmt->execute();
	var_dump($stmt->rowCount());
} catch (Exception $e) {
	echo $e->getMessage();	
}

?>

Expected result:
----------------
int(1)
int(1)
int(1)

Actual result:
--------------
int(0)
int(0)
int(0)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-07-23 23:38 UTC] iliaa@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

The number of rows affected by those operations will be provided to you by the exec() method as the returned value.
 [2005-07-24 01:32 UTC] iliaa@php.net
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Dec 03 17:01:29 2024 UTC