Edit report at https://bugs.php.net/bug.php?id=45080&edit=1
ID: 45080 Comment by: jmichae3 at yahoo dot com Reported by: paul dot cocei at gmail dot com Summary: PDOStatement - Mysql Driver - rowCount Status: Not a bug Type: Feature/Change Request Package: Feature/Change Request Operating System: CentOS 5.1 PHP Version: 5.2.6 Block user comment: N Private report: N New Comment: since it's not defined in the manual, to me, "affected rows" simply means the rows in question. are you speaking of UPDATE and DELETE? please put in better documentation on this function that explains the definition of "affected rows", thanks. if rowCount doesn't always return the row count, what are we supposed to use to get the row count? Previous Comments: ------------------------------------------------------------------------ [2013-08-22 01:17:08] jmichae3 at yahoo dot com I am having this problem too, and so are other people on the net. getting 0 always from rowCount() on SELECT. ------------------------------------------------------------------------ [2008-08-20 22:46:30] ka...@php.net This is expected behavior, the manual also says that the rowCount will return affected rows. ------------------------------------------------------------------------ [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 https://bugs.php.net/bug.php?id=45080&edit=1
