PHP PDO: get number of rows returned

Question

I can't find a way of finding the number of rows returned, after scouring the manual and other questions. How can I modify my fetchAll() method?

class Product {
    var $count;
    public function fetchAll(){
        $this->query = $this->pdo->prepare("SELECT * FROM $table");
        $this->query->setFetchMode( PDO::FETCH_ASSOC );
        $this->query->execute();
    }
    public function next(){
        $this->row = $this->query->fetch();
        if (!is_array($this->row)) return false;
        foreach ($this->row as $key => $val) {
            $this->{$key} = $val;
        }   
    }
    public function getCount(){
        return $this->count;
    }
}

$records = $stmt->fetchAll(PDO::FETCH_ASSOC); $num_rows = count($rows); voila, you're done. — N.B.
– N.B., Commented Apr 11, 2014 at 10:02
Re your now deleted question, here's some possible things to try. — halfer
– halfer, Commented Apr 11, 2014 at 10:40

Ameer · Accepted Answer · 2014-04-11 10:08:40Z

2

try $rows = $this->query->fetchAll(PDO::FETCH_ASSOC); return count($rows); after the $this->query->execute(); You can also use rowCount()

edited Apr 11, 2014 at 10:08

answered Apr 11, 2014 at 10:01

Ameer

7811 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jayy Over a year ago

Thanks - I will use PDO's fetchAll() if I have to, but I'd prefer a PDO method. Sadly the manual says for rowCount() " returns the number of rows affected by the last DELETE, INSERT, or UPDATE statement". (No SELECT)

The Blue Dog Over a year ago

@Jodes: rowCount() works fine for SELECT when using MySQL, try it and see.

N.B. Over a year ago

If you count the number of records in the array after you're done selecting, you'll have that number. Why do people complicate simple things.. rowCount isn't always safe and in certain cases can return 0 when in reality you have rows that are > 0. Just count your array with records.

Your Common Sense · Accepted Answer · 2014-04-11 10:54:35Z

1

It depends on why do you need the count.

If you want to know how many products you have but not products themselves, then you have to run a distinct query.

If you want products, then you need no dedicated method for count at all.

answered Apr 11, 2014 at 10:54

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Collectives™ on Stack Overflow

PHP PDO: get number of rows returned

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related