|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #56668 rowCount return nothing with SQLite3 pragma query
Submitted: 2005-11-21 15:16 UTC Modified: 2005-11-21 15:25 UTC
From: fhenninot at freesurf dot fr Assigned:
Status: Not a bug Package: PDO (PECL)
PHP Version: Irrelevant OS: Linux
Private report: No CVE-ID: None
 [2005-11-21 15:16 UTC] fhenninot at freesurf dot fr
This bug was verified with PHP-5.1RC6.

when PRAGMA query for SQLite3 can be return several rows, the rowCount method return 0.

Reproduce code:
$res = $PDO_DB->query("PRAGMA table_info(t1);");
echo "nb : ".$res->rowCount()."<br>";

Expected result:
the number of row, in this example, this will be return the number of table's columns.

Actual result:
nb : 0


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2005-11-21 15:25 UTC] ilia at prohost dot org
Sorry, but your problem does not imply a bug in PECL itself.  For a
list of more appropriate places to ask for help using PECL, please
visit as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PECL.

This is SQLite problem, the underlying library simply does not return the number of rows affected/returned by the PRAGMA operations.
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Sun Jun 07 04:01:28 2020 UTC