Zend_Db query and row count without pulling back everything up front

Question

I've created my select:

$select = $zdb->select()
              ->from(array("b" => "blogs"),
                     array("id", "active", "updated_by", "title", "synopsis", "create_date", "body"))
              ->join(array("u" => "users"),
                     'b.updated_by = u.id',
                     array("first_name", "last_name"))
              ->where("u.blogger = ?", 1)
              ->where("b.publish_date > ?", '2020-01-01')
              ->where("b.active = ?", 1)
              ->group("b.id")
              ->order("b.publish_date DESC")
              ->limit(5);

and I want to pull the data back a row at a time:

$stmt = $db->query($select);

while ($asset = $stmt->fetch()) {
    // do stuff
}

How can I check to make sure that there are rows, without returning the entire resultset?

JF Dion · Accepted Answer · 2010-10-14 18:50:05Z

1

Using the select you already have, something like that should help you parse every entry

$rows = $zdb->fetchAll($select);

foreach($rows as $row){
    ...
}

To get the values you just have to do $row['fieldName'] where fieldName is the name of the field in your database

answered Oct 14, 2010 at 18:50

JF Dion

4,0542 gold badges26 silver badges35 bronze badges

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

2 Comments

Glen Solsberry Over a year ago

Except that I don't want to fetch everything back, as I suggested in the title of the question. I want to know how many rows I can expect, via the stmt.

JF Dion Over a year ago

The only other way I see would be with a SELECT count(*) with the same where parameters and without the LIMIT

Collectives™ on Stack Overflow

Zend_Db query and row count without pulling back everything up front

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related