Re: PDOStatement::rowCount() bug?
| From: | Nathan Nobbe | Date: | Tue, 23 Feb 2010 03:48:24 +0000 |
| Subject: | Re: PDOStatement::rowCount() bug? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-302290@lists.php.net to get a copy of this message | ||
On Mon, Feb 22, 2010 at 8:39 PM, Paul M Foster <paulf@quillandmouse.com>wrote:
> On Mon, Feb 22, 2010 at 08:18:25PM -0700, Nathan Nobbe wrote:
>
> > On Mon, Feb 22, 2010 at 7:50 PM, Paul M Foster <paulf@quillandmouse.com>
> wrote:
> >
> > Using MySQL 5.075, PHP 5.25 on Debian unstable.
> >
> > Has anyone noticed, when issuing a PDOStatement::rowCount() call
> after a
> > DELETE, UPDATE or INSERT, the return is uniformly zero, rather than
> the
> > actual number of rows affected?
> >
> >
> > quick test shows rowCount() working in all 3 cases:
> >
> > <?php
> > /**
> > * lets test a PDOStatement::rowCount() bug
> > * using an sqlite3 memory resident database
> > */
>
> Nifty, but you'll notice that I'm using MySQL, not SQLite3. And you
> didn't mention which version PHP you're using.
>
it had occurred to me that you may be using a diff db and that could have
something to do w/ it; however, ive just made a slight alteration to the
script and its working np w/ mysql:
-----------
sql
-----------
mysql> create database TESTING;
Query OK, 1 row affected (0.00 sec)
mysql> use TESTING;
Database changed
mysql> CREATE TABLE TESTING (
-> id INT NOT NULL AUTO_INCREMENT,
-> name CHAR(30) NOT NULL,
-> PRIMARY KEY (id)
-> );
-----------
php
-----------
<?php
/**
* lets test a PDOStatement::rowCount() bug
* using an sqlite3 database
*/
try
{
$oPdo = new PDO('mysql:host=192.168.56.101;dbname=TESTING', 'root',
'');
$oStmt = $oPdo->query("INSERT INTO TESTING (name) VALUES ('nate
dogg')");
echo 'Num rows inserted: ' . $oStmt->rowCount() . PHP_EOL;
$oStmt = $oPdo->query("UPDATE TESTING SET name = 'snoop dog' WHERE id =
1");
echo "Num rows updated: " . $oStmt->rowCount() . PHP_EOL;
$oStmt = $oPdo->query("DELETE FROM TESTING WHERE id = 1");
echo "Num rows deleted: " . $oStmt->rowCount() . PHP_EOL;
}
catch(Exception $oE)
{
die($oE->getMessage() . PHP_EOL);
}
?>
------------
version
------------
php version:
PHP 5.2.6-3ubuntu4.5 with Suhosin-Patch 0.9.6.2
mysql version:
Server version: 5.1.31-1ubuntu2
-nathan