MySQL PDO row counts

Question

Possible Duplicate:
PHP PDO - Num Rows

I am working with PDO and MySQL, and I am fairly new to PDO.

So Have two questions?

What function do I use to count the number of rows found based on a select?
What function do I use to count the number of rows affected by an insert/delete/update?

According to the documentation it says:

If the last SQL statement executed by the associated PDOStatement was a SELECT statement, some databases may return the number of rows returned by that statement. However, this behavior is not guaranteed for all databases and should not be relied on for portable applications.

That being said what should I use for these?

@nickb thanks, that pretty much answers my question. – Get Off My Lawn Jan 12 '13 at 22:13 — Get Off My Lawn, Jan 12 '13 at 22:13

score 4 · Accepted Answer · answered Jan 12 '13 at 22:14

To guarantee a correct number of rows based on a select, you will need to use a PDO::query() with a SELECT COUNT(*) statement. Then use PDOStatement::fetchColumn() to retrieve the number of rows that will be returned.
For insert/update/delete, you can use PDOStatement::rowCount()

For more information, take a look at the PHP manual

score 2 · Answer 2 · answered Jan 12 '13 at 22:06

2

$stmt->rowCount() will return the number of rows returned by the query.

answered Jan 12 '13 at 22:06

Cody Covey

1,060
6
9

score 0 · Answer 3 · answered Jan 12 '13 at 22:05

0

The function required would be rowCount(). Usage here.

answered Jan 12 '13 at 22:05

hjpotter92

78,589
36
144
183

MySQL PDO row counts

3 Answers3