#45080 [Opn->Bgs]: PDOStatement - Mysql Driver - rowCount
| From: | kalle@php.net | Date: | Wed, 20 Aug 2008 22:46:31 +0000 |
| Subject: | #45080 [Opn->Bgs]: PDOStatement - Mysql Driver - rowCount | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-128268@lists.php.net to get a copy of this message | ||
ID: 45080
Updated by: kalle@php.net
Reported By: paul dot cocei at gmail dot com
-Status: Open
+Status: Bogus
Bug Type: Feature/Change Request
Operating System: CentOS 5.1
PHP Version: 5.2.6
New Comment:
This is expected behavior, the manual also says that the rowCount will
return affected rows.
Previous Comments:
------------------------------------------------------------------------
[2008-05-23 13:10:24] paul dot cocei at gmail dot com
Description:
------------
Because libmysql contains a method named mysql_stmt_num_rows, it is
possible in the mysql PDO driver to return correctly the total count of
rows selected by a SELECT statement.
Right now, the source code for mysql PDOStatement uses
mysql_stmt_affected_rows, which evidentely returns "0" for SELECT
queries.
Localization: php-5.2.6/ext/pdo_mysql.c, line 202.
Reproduce code:
---------------
row_count = mysql_stmt_affected_rows(S->stmt);
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=45080&edit=1